FillMethod in ADO.NET

Question

Hi.... I am working in ADO.NET and use FillMethod(). How can we define FillMethod() with connectionstring for the particular Database and define uses?

Satyapriya Nayak · Answer

Hi Rajesh, Filling the DataSet Once you have a DataSet and SqlDataAdapter instances, you need to fill the DataSet. Here's how to do it, by using the Fill method of the SqlDataAdapter: daCustomers.Fill(dsCustomers, "Customers"); The Fill method, in the code above, takes two parameters: a DataSet and a table name. The DataSet must be instantiated before trying to fill it with data. The second parameter is the name of the table that will be created in the DataSet. You can name the table anything you want. Its purpose is so you can identify the table with a meaningful name later on. Typically, I'll give it the same name as the database table. However, if the SqlDataAdapter's select command contains a join, you'll need to find another meaningful name. The Fill method has an overload that accepts one parameter for the DataSet only. In that case, the table created has a default name of "table1" for the first table. The number will be incremented (table2, table3, ..., tableN) for each table added to the DataSet where the table Refer http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson05.aspx Ex:- To show data in gridview using fill method. using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlCommand com; SqlDataAdapter sqlda; DataSet ds; string str; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindGrid(); } } void BindGrid() { SqlConnection con = new SqlConnection(connStr); con.Open(); str = "select * from student"; com = new SqlCommand(str, con); sqlda = new SqlDataAdapter(com); con.Close(); ds = new DataSet(); sqlda.Fill(ds, "student"); GridView1.DataSource = ds; GridView1.DataMember = "student"; GridView1.DataBind(); } } Thanks

FillMethod in ADO.NET

Answers (1)