Create SQL command from OleDbCommand (C#)

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

Related examples in the same category

1.	Use SQL directly to insert data into database in VB.net
2.	OleDBCommand Execute Reader (VB.net)
3.	Use direct SQL to insert (C#)

Create SQL command from OleDbCommand (C#) : OleDBCommand « ADO.net Database « ASP.Net

Related examples in the same category