In this article I will explain with an example, how to Update data into Database in ASP.Net using C# and VB.Net.
ADO.Net will be used to perform Update operation in ASP.Net.
 
 

Database

I have made use of the following table Customers with the schema as follows.
Update data into Database in ASP.Net using C# and VB.Net
 
I have already inserted few records in the table.
Update data into Database in ASP.Net using C# and VB.Net
 
Note: You can download the database table SQL by clicking the download link below.
           Download SQL file
 
 

HTML Markup

The HTML Markup consists of:
TextBox – For entering Id, Name and Country.
Button – Submitting the Form.
The Button has been assigned OnClick event handler.
<table border="0" cellpadding="0" cellspacing="0">
    <tr>
        <td style="width: 60px">Id<br />
            <asp:TextBox ID="txtId" runat="server" Width="50px" />
        </td>
        <td style="width: 150px">Name<br />
            <asp:TextBox ID="txtName" runat="server" Width="140px" />
        </td>
        <td style="width: 150px">Country:<br />
            <asp:TextBox ID="txtCountry" runat="server" Width="140px" />
        </td>
        <td style="width: 200px">
            <br />
            <asp:Button Text="Update" runat="server" OnClick="OnSubmit" />
        </td>
    </tr>
</table>
 
 

Namespaces

You will need to import the following namespaces.
C#
using System.Configuration;
using System.Data.SqlClient;
 
VB.Net
Imports System.Configuration
Imports System.Data.SqlClient
 
 

Updating the record in Database in ASP.Net

When the Update Button is clicked, following event handler is executed.
Inside this event handler, the CustomerId, Name and Country fields are fetched from their respective TextBoxes and the record is updated into the SQL Server database table using ADO.Net.
Finally, appropriate message is displayed in JavaScript Alert Message Box using RegisterStartupScript method.
C#
protected void OnSubmit(object sender, EventArgs e)
{
    string query = "UPDATE Customers SET Name=@Name, Country=@Country WHERE CustomerId=@CustomerId";
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand(query))
        {
            cmd.Parameters.AddWithValue("@CustomerId", txtId.Text);
            cmd.Parameters.AddWithValue("@Name", txtName.Text);
            cmd.Parameters.AddWithValue("@Country", txtCountry.Text);
            cmd.Connection = con;
            con.Open();
            int i = cmd.ExecuteNonQuery();
            con.Close();
 
            if (i > 0)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Customer record updated.');", true);
            }
            else
            {
                ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Customer not found.');", true);
            }
        }
    }
}
 
VB.Net
Protected Sub OnSubmit(ByVal sender As Object, ByVal e As EventArgs)
    Dim query As String = "UPDATE Customers SET Name=@Name, Country=@Country WHERE CustomerId=@CustomerId"
    Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Using con As SqlConnection = New SqlConnection(constr)
        Using cmd As SqlCommand = New SqlCommand(query)
            cmd.Parameters.AddWithValue("@CustomerId", txtId.Text)
            cmd.Parameters.AddWithValue("@Name", txtName.Text)
            cmd.Parameters.AddWithValue("@Country", txtCountry.Text)
            cmd.Connection = con
            con.Open()
            Dim i As Integer = cmd.ExecuteNonQuery()
            con.Close()
 
            If i > 0 Then
                ClientScript.RegisterStartupScript(Me.GetType(), "alert", "alert('Customer record updated.');", True)
            Else
                ClientScript.RegisterStartupScript(Me.GetType(), "alert", "alert('Customer not found.');", True)
            End If
        End Using
    End Using
End Sub 
 
 

Screenshot

Update data into Database in ASP.Net using C# and VB.Net
 
 

Downloads

Download Code