Mega Code Archive
Create SQL command from OleDbCommand (C#)
<![CDATA[
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script Language="c#" runat="server">
void Page_Load(object sender, EventArgs e)
{
string strConnection, strSQL;
DataSet objDataSet = new DataSet();
OleDbConnection objConnection = null;
OleDbDataAdapter objAdapter = null;
OleDbCommand objCommand = null;
OleDbCommandBuilder objBuilder = null;
// Set the connection and query details
strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source="+MapPath("EmployeeDatabase.mdb");
strSQL = "SELECT ID, FirstName, LastName FROM Employee";
// Open the connection and set the command
objConnection = new OleDbConnection(strConnection);
objAdapter = new OleDbDataAdapter(strSQL, objConnection);
// Create the other commands
objBuilder = new OleDbCommandBuilder(objAdapter);
objAdapter.UpdateCommand = objBuilder.GetUpdateCommand();
objAdapter.InsertCommand = objBuilder.GetInsertCommand();
objAdapter.DeleteCommand = objBuilder.GetDeleteCommand();
// Now display the CommandText property from each command
lblSelectCommand.Text = objAdapter.SelectCommand.CommandText;
lblUpdateCommand.Text = objAdapter.UpdateCommand.CommandText;
lblInsertCommand.Text = objAdapter.InsertCommand.CommandText;
lblDeleteCommand.Text = objAdapter.DeleteCommand.CommandText;
}
</script>
<html>
<body>
<table border="1">
<tr>
<td>Command</td>
<td>CommandText</td>
</tr>
<tr>
<td>SelectCommand</td>
<td><asp:Label id="lblSelectCommand" runat="server" />
</tr>
<tr>
<td>UpdateCommand</td>
<td><asp:Label id="lblUpdateCommand" runat="server" />
</tr>
<tr>
<td>InsertCommand </td>
<td><asp:Label id="lblInsertCommand" runat="server" />
</tr>
<tr>
<td>DeleteCommand</td>
<td><asp:Label id="lblDeleteCommand" runat="server" />
</tr>
</table>
</body>
</html>
EmployeeDatabase.zip( 10 k)
]]>