Use direct SQL to insert (C#) : OleDBCommand « ADO.net Database « ASP.Net






  1. ASP.Net
  2. ADO.net Database
  3. OleDBCommand

Use direct SQL to insert (C#)

<%@ Page Language="C#" Debug="true" %>
<%@ 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, strSQL;
    strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
    strConnection += @"Data Source="+MapPath("EmployeeDatabase.mdb");

    objConnection = new OleDbConnection(strConnection);
    objConnection.Open();

    strSQL = "INSERT INTO Employee(FirstName,LastName) VALUES ('Beth', 'Hart')";

    // Create the Command and set its properties

    objCmd = new OleDbCommand(strSQL, objConnection);

    // Execute the command

    objCmd.ExecuteNonQuery();
    lblStatus.Text = "Command run";
  }
</script>

<html>
  <body>
    <h2>Using SQL directly</h2>
    <asp:Label id="lblStatus" runat="server"/>
  </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.Create SQL command from OleDbCommand (C#)