Set asp:datagrid title bar (C#)

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script Language="c#" runat="server">
  void Page_Load()
  {
    string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
//    strConnection += @"Data Source=C:\Northwind.mdb";
    strConnection += @"Data Source="+MapPath("EmployeeDatabase.mdb");
    string strSQL = "Select LastName, FirstName, ID from Employee;";
    OleDbConnection objConnection = new OleDbConnection(strConnection);
    OleDbCommand objCommand = new OleDbCommand(strSQL,objConnection);
    objConnection.Open();
    dgEmps.DataSource = objCommand.ExecuteReader(CommandBehavior.CloseConnection);
    dgEmps.DataBind();
  }
</script>
<html>
  <body>
    <asp:datagrid id="dgEmps"
        runat="server"
        CellPadding="3"
        Font-Name="arial"
        Font-Size="8pt"
        HeaderStyle-BackColor="#dcdcdc"
        HeaderStyle-ForeColor="blue"
    />
  </body>
</html>

EmployeeDatabase.zip( 10 k)

Related examples in the same category

1.	Pagable datagrid (VB.net)
2.	Bind data through SqlConnection to asp:DataGrid (VB.net)
3.	Bind to two different asp:datagrid (VB.net)
4.	asp:datagrid: sort expression (VB.net)
5.	Sort asp:datagrid (VB.net)
6.	Bind asp:DataGrid to access database (VB.net)
7.	Bind Data to asp DataGrid in C#

Set asp:datagrid title bar (C#) : DataGrid « ADO.net Database « ASP.Net

Related examples in the same category