Expertrating - ASP.Net Tutorial, ADO.NET

Home > Courses, Tutorials & eBooks > ASP.NET Tutorial > ADO.NET

ASP.NET Tutorial - ADO.NET

Page 8 of 14

The output of this example is as shown below:

In the above example there are two TextBox controls named txtbookName and txtAuthor. When the Add Books! Button, are clicked the Button Click subroutine is executed, and the values entered into the two TextBox controls are inserted into the Books table of Northwind database.

Example 28 demonstrates how you can add a new record to a Microsoft Access database table using classes from the System.Data.OleDb namespace.

Example 28 OleDbParameterInsert.aspx

<%@ Import Namespace="System.Data" %>

<%@ Import Namespace="System.Data.OleDb" %>

Sub Button_Click (s as Object, e As EventArgs)

Dim conNorthwind As OleDbConnection

Dim strInsert As String

Dim cmdInsert As OleDbCommand

conNorthwind = New OleDbConnection( "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=c:\Books.mdb")

strInsert = "Insert into Books ( bookName, Author ) Values ( @bkName, @bkAuthor )"

cmdInsert = New OleDbCommand( strInsert, conNorthwind )

cmdInsert.Parameters.Add( "@bkName", txtbookName.Text )

cmdInsert.Parameters.Add( "@bkAuthor",txtAuthor.Text)

conNorthwind. Open ()

cmdINsert. ExecuteNonQuery ()

conNorthwind. Close ()

End Sub

</Script>

<html>

<body>

<br>

<asp:TextBox

ID="txtbookName"

Runat="Server" />

<p>

<b>Author:</b>

<br>

<asp:TextBox

ID="txtAuthor"

Runat="Server" />

<p>

<asp:Button

Text="Add Books!"

OnClick="Button_Click"

Runat="Server" />

</form>

</body>

</html>

The output of this example is shown as below:

ExpertRating ASP.NET Certification - Get Certified Now!!