//object of dataadapter
SqlDataAdapter adp=new SqlDataAdapter(); 

// assign sqlquery to extract from database. refer previous //code for selecting data from db.
adp.selectCommand=cmd;

//object of dataset
DataSet Ds=new DataSet();

//filling dataset with records that exist in adapter
adp.fill(ds,"tempTablename");

//realeasing data adapter
adp.dispose();

using System.Data.SqlClient;

SqlConnection con=new SqlConnection();
con.connectionString="Data Source=SqlserverName;initial catalog=databasename;user id=sqlusername;password=sqlpassword;integrated security=false";
con.open();
try
{
  SqlCommand cmd=new SqlCommand();