Bind Data to asp DataGrid in C#
<%@ 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>
EmployeeDatabase.zip( 10 k)Related examples in the same category