CSharp Bind Data To Asp Datagrid In C# – ADO.Net Database

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script language="C#" runat="server">
void Page_Load(object sender, EventArgs e)
{
  OleDbConnection objConnection;
  OleDbDataAdapter objCommand;
  string strConnect;
  string strCommand;
  DataSet DataSet1 = new DataSet();
 
  strConnect =  @"Provider=Microsoft.Jet.OLEDB.4.0;";
  //If you don't have the EmployeeDatabase.mdb database, then you will have to
  //change the following three lines to a different database
 
  strConnect += @"Data Source=" + MapPath("EmployeeDatabase.mdb;");
 
  strConnect += "Persist Security Info=False";  strCommand = "SELECT FirstName, LastName FROM Employee";
  objConnection = new OleDbConnection(strConnect);
  objCommand = new OleDbDataAdapter(strCommand, objConnection);
  objCommand.Fill(DataSet1, "Employee");
  DataGrid1.DataSource=DataSet1.Tables["Employee"].DefaultView;
  DataGrid1.DataBind();
}
</script>
<html>
<head>
<title>Data Grid Control example</title>
</head>
<body>
<asp:DataGrid id="DataGrid1" runat="server"  />
</body>
</html>

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.