2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by sourceskill
0

Here is an example I googled to find out:


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

Here is the link to the page where I got the information http://www.java2s.com/Code/ASP/ADO.net-Database/InsertdatatodatabaseusingSQLC.htm this website has great tutorials and examples for future reference.

NPatterson

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.