Fill Method in ADO.NET

Question

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

Vithal Wadje · Answer

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/

Vulpes · Answer

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 Sharma · Answer

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.

Fill Method in ADO.NET

Answers (3)