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(ds,"Employee");

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(qry,SqlConn); 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.

Method to execute on DataAdapter control for loading Dataset

Answers (3)