CSharp Use Direct Sql To Insert (C#) – ADO.Net Database

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

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.