Insert data to database using SQL (C#) : Insert OleDbConnection « ADO.net Database « ASP.Net





Insert data to database using SQL (C#)

<%@ Page 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=C:\Northwind.mdb";
    strConnection += @"Data Source="+MapPath("EmployeeDatabase.mdb");
     
    // Create and open the connection object
    objConnection = new OleDbConnection(strConnection);
    objConnection.ConnectionString = strConnection;

    objConnection.Open();
    
    // set the SQL string
    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.Generate SQL insert command (VB.net)
2.Insert data to OleDbConnection using SQL (VB.net)