Method to execute on DataAdapter control for loading Dataset

Question

Which method I can execute on DataAdapter control for loading Dataset with data

Tulasi · Answer

hi use System.Data.SqlClient; System.Data; SqlConnection sqlcon=new SqlConnection(connectionstring); SqlDataAdapter sqldad=new SqlDataAdapter(Select * from Emp sqlcon); Dataset ds=new Datset(); sqldad.fill(dsEmployee);

Kunal Naik · Answer

Hi use these 2 namespace in your class System.Data; System.Data.SqlClient; To execute on DataAdapter for loading DataSet there is Fill() method available. Below is an example to use this method string qry = Select * from TableName; SqlConnection SqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings[MyConn].ConnectionString); SqlDataAdapter Da = new SqlDataAdapter(qrySqlConn); DataSet ds = new DataSet(); Da.Fill(ds TableName);

Pravin More · Answer

Hi Monika you can use Fill() methos on adapter like below example... string queryString = SELECT CustomerID CompanyName FROM dbo.Customers; SqlDataAdapter adapter = new SqlDataAdapter(queryString connection); DataSet customers = new DataSet(); adapter.Fill(customers); Thanks Pravin.