<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
void Page_Load(object sender, EventArgs e)
{
OleDbConnection objConnection = null;
OleDbCommand objCmd = null;
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source=C:\Northwind.mdb";
// Create and open the connection object
objConnection = new OleDbConnection(strConnection);
objConnection.Open();
// Create the Command and set its properties
objCmd = new OleDbCommand();
objCmd.Connection = objConnection;
objCmd.CommandText = "[Sales by Category]";
objCmd.CommandType = CommandType.StoredProcedure;
dgSales.DataSource = objCmd.ExecuteReader(CommandBehavior.CloseConnection);
dgSales.DataBind();
}
Using a stored procedure
Northwind.zip( 736 k)