how to bind database data into datatable?

Question

HI AM NEW TO ASP.NET. I dont knw how to bind database data into datatable? and datatable SHOULD bind in gridview . can anyone help me with simple example???????????

Ravi Shekhar · Answer

Hi sara, Please gothrough with the below code... SqlDataAdapter adp = new SqlDataAdapter("select * from RootAndChildNodeEntry", con); DataTable dt = new DataTable(); adp.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); Regards, Ravi mark it as answer if it helped you

Satyapriya Nayak · Answer

Untitled Page Text="Using Datatable" /> 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.OleDb; public partial class _Default : System.Web.UI.Page { OleDbConnection con; OleDbCommand com; OleDbDataAdapter oda; DataSet ds; DataTable dataTable; protected void Button2_Click(object sender, EventArgs e) { con = new OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0; Data Source = D:\mydb.mdb"); dataTable = new DataTable(); com = new OleDbCommand(); com.Connection = con; con.Open(); com.CommandText = "Select * from emp"; oda = new OleDbDataAdapter(com); oda.Fill(dataTable); con.Close(); GridView1.DataSource = dataTable; GridView1.DataMember = "emp"; GridView1.DataBind(); } }

sara chinchu · Answer

thanku :)

Riddhi Valecha · Answer

Hi.. Create table- Table Name- Person Change the connection string in Web.Config file. Rest, the code is attached.

how to bind database data into datatable?

Answers (4)