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