Fill Into DataSet

Using Oledb

DataSet DtaSet=new DataSet();

OleDbDataAdapter OAdp = new OleDbDataAdapter(StrSQL, StrCon);

//StrCon is Connection string

//StrSQL is Sql Quories

OAdp.Fill(DtaSet);

Using SqlClient

DataSet DtaSet=new DataSet();

SqlDataAdapter OAdp = new SqlDataAdapter(StrSQL, StrCon);

//StrCon is Connection string

//StrSQL is Sql Quories

SqlAdp.Fill(DtaSet);