CSharp Set Asp:Datagrid Title Bar (C#) – ADO.Net Database

<%@ 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>

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.