CSharp Insert Data To Database Using Sql (C#) – ADO.Net Database

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

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.