how to bind database data into datatable?
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???????????
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Ravi ShekharPosted May 7, 2013, 7:34 AM
Please gothrough with the below code...
SqlDataAdapter adp = new SqlDataAdapter("select * from RootAndChildNodeEntry", con);
DataTable dt = new DataTable();
adp.Fill(dt);
sara chinchuPosted May 9, 2013, 1:42 AM
Satyapriya NayakPosted May 7, 2013, 10:00 AM
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();
}
}
Riddhi ValechaPosted May 7, 2013, 7:24 AM
Create table-
Table Name- Person
Change the connection string in Web.Config file.
Rest, the code is attached.