Expertrating - ASP.Net Tutorial, ADO.NET

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

ASP.NET Tutorial - ADO.NET

Page 11 of 14

Example 32 OledbParameterUpdate.asp

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

Sub Button_Click (s As Object, e As EventArgs)

Dim conNorthwind As OledbConnection

Dim strUpdate As String

Dim cmdUpdate As OledbCommand

Dim intRecordCount As Integer

conNorthwind=NewOledbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;

DATA Source =c:\Books.mdb")

strUpdate = "Update Books Set Author=@author_name Where bookName=@book_name"

cmdUpdate = New OledbCommand( strUpdate, conNorthwind )

cmdUpdate.Parameters.Add( "@book_name", txtBookName.Text )

cmdUpdate.Parameters.Add( "@author_name", txtAuthorName.Text )

conNorthwind. Open ()

intRecordCount = cmdUpdate.ExecuteNonQuery()

conNorthwind. Close ()

lblAuthor. Text = intRecordCount & " records updated!"

End Sub

</Script>

<html>

<body>

<h3>Update Book's Name</h3>

<br>

<asp:TextBox

ID="txtBookName"

Runat="Server" />

<p>

<br>

<b>Author's Name</b>

<br>

<asp:TextBox

ID="txtAuthorName"

Runat="Server" />

<p>

<asp:Button

Text="Update Author"

OnClick="Button_Click"

Runat="Server" />

<p>

<asp:Label

ID="lblAuthor"

Runat="Server" />

</form>

</body>

</html>

The output of this example is as shown below:-

The above example has two TextBox controls: one for a Book’s name and other in Author’s Name. When you click the Update Author! Button, the Button Click subroutine is executed, and the phone number for the proper author is updated.

Finally, the number of records updated is retrieved from the ExecuteNonQuery () method of the OleDbCommand class. This result is assigned to a Label control lblAuthor.

ExpertRating ASP.NET Certification - Get Certified Now!!