Fill Method in ADO.NET

Nitin Bhardwaj

Hi,
How to use Fill method of DataAdapter object is used to place query results into a DataSet?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vithal Wadje14y ago
SqlCommand com=new SqlCommand ("select *from employee",con); // table name
SqlDataAdapter da=new SqlDataAdapter(com);
DataSet ds =new DataSet ();
da.Fill(ds); // fill dataset
for more detail see my article here http://www.c-sharpcorner.com/UploadFile/0c1bb2/fill-Asp-Net-dropdown-list-from-database-table-using-Asp-Net/
Vulpes14y ago
Check out our article on using this method for the SQL Server data adapter:

http://www.c-sharpcorner.com/uploadfile/61b832/sqldataadapter-fill-method/
Neha Sharma14y ago
Hi,

follow the below link:

Create String :

http://nehaprogrammer.blogspot.in/search?updated-max=2012-01-12T00:06:00-08:00&max-results=7&start=28&by-date=false

Create Object :

http://nehaprogrammer.blogspot.in/2012/01/creating-objects.html

Now when you do this all you need to add code to use table:

con.con.open();
con.cmd.commandText="select * from tablename";
con.adp.fill(con.ds,"a");
GridView1.DataSource=con.ds.tables["a"];
Gridview1.bind();
Con.con.close();

Descriptions :

con.adp.fill = this line ll fill the table in an virtual table.

Learn carefull each steps you ll come to know the role and work process of fill,use brekapoints to learn in more depth.

Thanks.