Progress Monitor for IdealProgrammer.com

Take Swift, Intelligent, Massive, Planned, Loving, Effective (S.I.M.P.L.E.) Action to Transform Self into Ideal

Skip Repetitive Navigational Links

Home

News

Presenters

Contact

Please login

C# ASP.NET Sql Command Update Statement Source Code Example

Description: Illustrates using Sql Command Update Statement in C-Sharp ASP.NET.

Example Webform 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:TextBox>
        </td>
        </tr>
        <tr>
        <td>Update Last Name with this: </td><td>
        <asp:TextBox ID="txtLastName" runat="server"></asp:TextBox>
        </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:Label><br />
        <asp:GridView ID="GridView1" runat="server" DataSourceID="sdsEmployees">
        </asp:GridView>
        <asp:SqlDataSource ID="sdsEmployees" runat="server" 
            ConnectionString="<%$ ConnectionStrings:Northwind_ConnectionString %>" 
            SelectCommand="SELECT [FirstName], [LastName] FROM [Employees]">
        </asp:SqlDataSource>
    </div>
    </form>
</body>
</html>

Example Code Behind:

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;
 
    }
}

Example Connection String:

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