Call store procedure through OldDbconnection 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 = 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();
}
</script>
<html>
<body>
<h2>Using a stored procedure</h2>
<asp:datagrid id="dgSales" runat="server" />
</body>
</html>
Northwind.zip( 736 k)Related examples in the same category