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");
<title>Data Grid Control example</title>
<asp:DataGrid id="DataGrid1" runat="server"  />

Enjoyed this post? Share it!


Leave a comment

Your email address will not be published.