C# ASP.NET Sql Command Update Statement Source Code Example
Putting
the Pieces of .NET Together - 8 Part Video Series | ||||
| Introduction |  | |||
| Videos 1-4 | 1. Servers (3 minutes) | 2. .NET Framework (10 minutes) | 3. Security (8 minutes) | 4. Monitoring Tools (10 minutes) |
| Videos 5-8 | 5. Web Servers (6 minutes) | 6. SQL Server (6 minutes) | 7. Software Develop Tools (10 minutes) | 8. Languages (2 minutes) |
| Download PDF | Putting the Pieces of .NET Together - 48-page PDF | |||
Sql Command Update Statement
Purpose: – Illustrates using Sql Command Update Statement in C-Sharp ASP.NET.
Prerequistes:
- Install C# (Express or Standard Edition)
- 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 C-Sharp for Language
- name of Web Site could be CSharp_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.cs
- 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 | | ? |
< %@ Page Language="C#" AutoEventWireup="false" CodeFile="SqlCommandUpdate.aspx.cs" Inherits="Database_ADONET_SqlCommandUpdate" %> |
< !DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
<html xmlns="http://www.w3.org/1999/xhtml"> |
<head id="Head1" runat="server"> |
<title></title> |
</head> |
<body> |
<form id="form1" runat="server"> |
<div> |
<table> |
<tr> |
<td>Find this First Name: </td><td> |
<asp :TextBox ID="txtFirstName" runat="server"></asp> |
</td> |
</tr> |
<tr> |
<td>Update Last Name with this: </td><td> |
<asp :TextBox ID="txtLastName" runat="server"></asp> |
</td> |
</tr> |
</table><br /> |
<asp :Button ID="btnUpdate" runat="server" Text="Update" onClick="btnUpdate_Click"/><br /> |
<asp :Label ID="lblErrMsg" runat="server" Text="lblErrMsg" ForeColor="#FF3300" |
Visible="False"></asp><br /> |
<asp :GridView ID="GridView1" runat="server" DataSourceID="sdsEmployees"> |
</asp> |
<asp :SqlDataSource ID="sdsEmployees" runat="server" |
ConnectionString="<%$ ConnectionStrings:Northwind_ConnectionString %>" |
SelectCommand="SELECT [FirstName], [LastName] FROM [Employees]"> |
</asp> |
</div> |
</form> |
</body> |
</html> |
Step 2: Click on Copy Code to Cut-n-paste code into SqlCommandUpdate.aspx.cs
| C# | | copy code | | ? |
using System; |
using System.Data; |
using System.Data.SqlClient; |
using System.Configuration; |
partial class Database_ADONET_SqlCommandUpdate : System.Web.UI.Page |
{ |
protected void btnUpdate_Click(object sender, System.EventArgs e) |
{ |
SqlConnection thisConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["Northwind_ConnectionString"].ConnectionString); |
//Create Command object |
SqlCommand nonqueryCommand = thisConnection.CreateCommand(); |
try |
{ |
// Open Connection |
thisConnection.Open(); |
// 1. Create Command |
// Sql Update Statement |
string updateSql = "UPDATE Employees " + "SET LastName = @LastName " + "WHERE FirstName = @FirstName"; |
SqlCommand UpdateCmd = new SqlCommand(updateSql, thisConnection); |
// 2. Map Parameters |
UpdateCmd.Parameters.Add("@FirstName", SqlDbType.NVarChar, 10, "FirstName"); |
UpdateCmd.Parameters.Add("@LastName", SqlDbType.NVarChar, 20, "LastName"); |
UpdateCmd.Parameters["@FirstName"].Value = txtFirstName.Text; |
UpdateCmd.Parameters["@LastName"].Value = txtLastName.Text; |
UpdateCmd.ExecuteNonQuery(); |
} |
catch (SqlException ex) |
{ |
// Display error |
lblErrMsg.Text = ex.ToString(); |
lblErrMsg.Visible = true; |
} |
finally |
{ |
// Close Connection |
thisConnection.Close(); |
} |
GridView1.DataBind(); |
} |
protected void Page_Load(object sender, System.EventArgs e) |
{ |
lblErrMsg.Visible = false; |
} |
} |
Step 3: Click on Copy Code to Cut-n-paste code into web.config right after the appSettings section
| XML | | copy code | | ? |
<connectionstrings> |
<add name="Northwind_ConnectionString" |
connectionString="Server=(local)\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=SSPI" /> |
<add name="Pubs_ConnectionString" |
connectionString="Server=(local)\SQLEXPRESS;Initial Catalog=pubs;Integrated Security=SSPI" /> |
</connectionstrings> |
Related posts:
- VB.NET ASP.NET Sql Command Update Statement Source Code Example VB.NET 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...
- C# ASP.NET Sql Command Delete Statement Source Code Example C# ASP.NET Sql Command Delete Statement Source Code Example...
- C# ASP.NET Sql Command Insert Statement Source Code Example C# ASP.NET Sql Command Insert Statement Source Code Example...
- VB.NET ASP.NET Sql Command Delete Statement Source Code Example VB.NET ASP.NET Sql Command Delete Statement Source Code Example...
Related posts brought to you by Yet Another Related Posts Plugin.