code for update record

Question

1.00/5 (2 votes)

See more:

VB

Please help me with code for update record in SQL server 2005.

Posted 11-Dec-10 1:03am

nikhil16

Updated 11-Dec-10 1:04am

Abdul Quader Mamun

v2

Add a Solution

Comments

Abdul Quader Mamun 11-Dec-10 7:05am

Spelling check.

Sandeep Mewara 12-Dec-10 3:46am

What help?

4 solutions

Solution 2

You can follow the below code. My code in C#

C#

private void btnUpdate_Click(object sender, System.EventArgs e)
{
SqlConnection cn;
SqlCommand cmd ;
string strsql ;


try
{
cn = new SqlConnection("Server=localhost;uid=sa;pwd=;database=northwind;");
 
strsql = "Update Region set RegionDescription=@RegionDescription where RegionId=@RegionId"
cmd = new SqlCommand(strsql, cn);
cmd.Parameters.Add(new SqlParameter("@RegionId", SqlDbType.Int));
cmd.Parameters.Add(new SqlParameter("@RegionDescription", SqlDbType.NVarChar, 40));
cmd.Parameters["@RegionId"].Value = Convert.ToInt32(txtRegionID.Text);
cmd.Parameters["@RegionDescription"].Value = txtRegionDescription.Text;
cn.Open();
cmd.ExecuteNonQuery();
lblMessage.Text = "Updated Successfully";
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
lblMessage.ForeColor = Color.Red;
}
finally
{
cn.Close();
}
}

Thanks.

Posted 11-Dec-10 1:15am

Abdul Quader Mamun

Updated 13-Dec-10 6:14am

v4

Comments

fjdiewornncalwe 12-Dec-10 10:16am

Read the question properly and completely before throwing out an answer. What language has the OP asked for...

Abdul Quader Mamun 13-Dec-10 0:00am

What you understand by the question?

Abdul Quader Mamun 13-Dec-10 0:01am

He is novice programmer. Just help him.

Simon_Whale 14-Dec-10 5:04am

even though your second question is also a correct version in c# that doesn't help the OP as you've also done the same in vb.net first which is the language that he has asked for help in

Solution 1

See here[^].

Posted 11-Dec-10 1:06am

Abhinav S

Solution 4

Update, Delete and insert using SQL Statements in VB.NET[^]
Update statements using parameterised queries[^]

the second link is the best way to go if your not using SQL Server stored procedures.

Article using stored procedures[^]

Posted 13-Dec-10 23:00pm

Simon_Whale

Updated 13-Dec-10 23:04pm

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abdul Quader Mamun · Accepted Answer · 2010-12-12T19:00:00

Code in VB.NET

VB

Imports System.Data.SqlClient
Imports System.Data
Imports System.Drawing

Dim cn As SqlConnection
        Dim cmd As SqlCommand
        Dim strsql As String

        Try
            cn = New SqlConnection("Server=localhost;uid=sa;pwd=;database=northwind;")
            strsql = "Update Region set RegionDescription=@RegionDescription where RegionId=@RegionId"
            cmd = New SqlCommand(strsql, cn)

            cmd.Parameters.Add(New SqlParameter("@RegionId", SqlDbType.Int))
            cmd.Parameters.Add(New SqlParameter("@RegionDescription", SqlDbType.NVarChar, 40))
            cmd.Parameters("@RegionId").Value = Convert.ToInt32(txtRegionID.Text)
            cmd.Parameters("@RegionDescription").Value = txtRegionDescription.Text
            cn.Open()
            cmd.ExecuteNonQuery()
            lblMessage.Text = "Updated Successfully"

        Catch ex As Exception
            lblMessage.Text = ex.Message
            lblMessage.ForeColor = Color.Red
        Finally
            cn.Close()
        End Try

Thanks,
Mamun