VB.NET ASP.NET Sql Command Update Statement Source Code Example
| .NET | .NET Programming (C# or VB) (Web or Desktop) | |||
| Key Supporting Languages | HTML | CSS | JavaScript | SQL Server |
| Access | AJAX | ASP | Blogging | ColdFusion |
| Expression Blend | mySQL | Perl | PHP | Ruby |
| SEO | SharePoint | Silverlight | Web Design | Web Dev |
Sql Command Update Statement
Purpose: – Illustrates using Sql Command Update Statement in VB.NET ASP.NET.
Prerequistes:
- Install Visual Web Developer 2008
- Install SQL Server Express
- Download Northwind and Pubs Databases
- Attach Northwind Database to Databases in Sql Express
- Attach pubs Database to Databases in Sql Express
Notes:
- You can build your own library of syntax examples by using same web site over and over and just add new web forms to it.
Instructions:
- Use Visual Web Developer 2008
- Create new web site;
- Click File/New Web Site
- Select ASP.NET Website Template
- Select Visual Basic for Language
- name of Web Site could be VBNET_ASPNET_Syntax.
- Add New folder named "Database_ADONET"
- Right-click project name in solution explorer;
- add new folder;
- name of folder could be: Database_ADONET
- Add Web Form Named SqlCommandUpdate to Database_ADONET folder
- Right-click Database_ADONET folder;
- add new item;
- Select Web Form
- Check place code behind in separate file
- Web Form name could be SqlCommandUpdate
- Click on copy code in code below to copy code into web form SqlCommandUpdate.aspx
- Click on copy code in second set of code below to copy code into code-behind SqlCommandUpdate.aspx.vb
- Right-click on SqlCommandUpdate.aspx in solution explorer and select view in browser
Step 1: Click on Copy Code to Cut-n-paste code into SqlCommandUpdate.aspx
| XML | | copy code | | ? |
| 01 | |
| 02 | <%@ Page Language="VB" AutoEventWireup="false" CodeFile="SqlCommandUpdate.aspx.vb" Inherits="Database_ADONET_SqlCommandUpdate" %> |
| 03 | |
| 04 | <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
| 05 | |
| 06 | <html xmlns="http://www.w3.org/1999/xhtml"> |
| 07 | <head runat="server"> |
| 08 | <title></title> |
| 09 | </head> |
| 10 | <body> |
| 11 | <form id="form1" runat="server"> |
| 12 | <div> |
| 13 | <table> |
| 14 | <tr> |
| 15 | <td>Find this First Name: </td><td> |
| 16 | <asp:TextBox ID="txtFirstName" runat="server"></asp:TextBox> |
| 17 | </td> |
| 18 | </tr> |
| 19 | <tr> |
| 20 | <td>Update Last Name with this: </td><td> |
| 21 | <asp:TextBox ID="txtLastName" runat="server"></asp:TextBox> |
| 22 | </td> |
| 23 | </tr> |
| 24 | </table><br /> |
| 25 | <asp:Button ID="btnUpdate" runat="server" Text="Update" /><br /> |
| 26 | <asp:Label ID="lblErrMsg" runat="server" Text="lblErrMsg" ForeColor="#FF3300" |
| 27 | Visible="False"></asp:Label><br /> |
| 28 | <asp:GridView ID="GridView1" runat="server" DataSourceID="sdsEmployees"> |
| 29 | </asp:GridView> |
| 30 | <asp:SqlDataSource ID="sdsEmployees" runat="server" |
| 31 | ConnectionString="<%$ ConnectionStrings:Northwind_ConnectionString %>" |
| 32 | SelectCommand="SELECT [FirstName], [LastName] FROM [Employees]"> |
| 33 | </asp:SqlDataSource> |
| 34 | </div> |
| 35 | </form> |
| 36 | </body> |
| 37 | </html> |
| 38 | |
| 39 |
Step 2: Click on Copy Code to Cut-n-paste code into SqlCommandUpdate.aspx.vb
| Visual Basic | | copy code | | ? |
| 01 | |
| 02 | Imports System |
| 03 | Imports System.Data |
| 04 | Imports System.Data.SqlClient |
| 05 | |
| 06 | Partial Class Database_ADONET_SqlCommandUpdate |
| 07 | Inherits System.Web.UI.Page |
| 08 | |
| 09 | Protected Sub btnUpdate_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnUpdate.Click |
| 10 | Dim thisConnection As New SqlConnection(ConfigurationManager.ConnectionStrings("Northwind_ConnectionString").ConnectionString) |
| 11 | |
| 12 | 'Create Command object |
| 13 | Dim nonqueryCommand As SqlCommand = thisConnection.CreateCommand() |
| 14 | |
| 15 | Try |
| 16 | ' Open Connection |
| 17 | thisConnection.Open() |
| 18 | |
| 19 | ' 1. Create Command |
| 20 | ' Sql Update Statement |
| 21 | Dim updateSql As String = _ |
| 22 | "UPDATE Employees " & _ |
| 23 | "SET LastName = @LastName " & _ |
| 24 | "WHERE FirstName = @FirstName" |
| 25 | Dim UpdateCmd As New SqlCommand(updateSql, thisConnection) |
| 26 | |
| 27 | ' 2. Map Parameters |
| 28 | |
| 29 | UpdateCmd.Parameters.Add("@FirstName", _ |
| 30 | SqlDbType.NVarChar, 10, "FirstName") |
| 31 | |
| 32 | UpdateCmd.Parameters.Add("@LastName", _ |
| 33 | SqlDbType.NVarChar, 20, "LastName") |
| 34 | |
| 35 | |
| 36 | UpdateCmd.Parameters("@FirstName").Value = txtFirstName.Text |
| 37 | UpdateCmd.Parameters("@LastName").Value = txtLastName.Text |
| 38 | |
| 39 | UpdateCmd.ExecuteNonQuery() |
| 40 | |
| 41 | Catch ex As SqlException |
| 42 | ' Display error |
| 43 | lblErrMsg.Text = ex.ToString() |
| 44 | lblErrMsg.Visible = True |
| 45 | |
| 46 | Finally |
| 47 | ' Close Connection |
| 48 | thisConnection.Close() |
| 49 | |
| 50 | End Try |
| 51 | GridView1.DataBind() |
| 52 | End Sub |
| 53 | |
| 54 | Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load |
| 55 | lblErrMsg.Visible = False |
| 56 | |
| 57 | End Sub |
| 58 | End Class |
| 59 | |
| 60 |
Step 3: Click on Copy Code to Cut-n-paste code into web.config right after the appSettings section
| XML | | copy code | | ? |
| 1 | |
| 2 | <connectionStrings> |
| 3 | <add name="Northwind_ConnectionString" |
| 4 | connectionString="Server=(local)\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=SSPI" /> |
| 5 | <add name="Pubs_ConnectionString" |
| 6 | connectionString="Server=(local)\SQLEXPRESS;Initial Catalog=pubs;Integrated Security=SSPI" /> |
| 7 | </connectionStrings> |
| 8 |
Related posts:
- C# ASP.NET Sql Command Update Statement Source Code Example C# ASP.NET Sql Command Update Statement Source Code Example...
- VB.NET Sql Command Update Statement Source Code Example VB.NET Source Code Example shows how to use Sql Command...
- VB.NET ASP.NET Sql Command Delete Statement Source Code Example VB.NET ASP.NET Sql Command Delete Statement Source Code Example...
- VB.NET ASP.NET Sql Command Insert Statement Source Code Example VB.NET ASP.NET Sql Command Insert Statement Source Code Example...
- C# ASP.NET Sql Command Delete Statement Source Code Example C# ASP.NET Sql Command Delete Statement Source Code Example...
Related posts brought to you by Yet Another Related Posts Plugin.

HIIII HELLO …
Im a Student in vb.net . plz ,my help
COODING. GIVE ME
SAVE, INSERT, UPDATE, PRECIOUS, BACK, and BANK STATMENT COODING, ETC……………
OF MY PROJECT ,. PLZ GIVE ME ABCE COODING….
THANKS,,,..//////……,.,,/////..//