Fill into DataTable

Using Oledb

Fill DataTable

DataTable DtaTbl=new DataTable();

OleDbDataAdapter OAdp=new OleDbDataAdapter(StrSQL,StrCon);

OAdp.Fill(DtaTbl);



Using SqlClient

Fill DataTable

DataTable DtaTbl=new DataTable();

SqlDataAdapter OAdp=new SqlDataAdapter(StrSQL,StrCon);

OAdp.Fill(DtaTbl);