ASP Net Controls ASP.Net Tutorial

  1. Home
  2. ASP.Net Tutorial
  3. ASP Net Controls
  4. Set HeaderStyle and ItemStyle for asp
<%@ Page Language="C#" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>

    void Page_Load(object sender, EventArgs e) {
    
        string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+ Server.MapPath("EmployeeDatabase.mdb;");
        string CommandText = "select * from employee";
    
        OleDbConnection myConnection = new OleDbConnection(ConnectionString);
        OleDbCommand myCommand = new OleDbCommand(CommandText, myConnection);
    
        myConnection.Open();
    
        DataGrid1.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
        DataGrid1.DataBind();
    
        myConnection.Close();
    }





    
                              runat="server" 
                      CellSpacing="1" 
                      GridLines="None" 
                      CellPadding="3" 
                      BackColor="White" 
                      ForeColor="Black" 
                      EnableViewState="False">