更新记录代码 [英] code for update record

问题描述

请帮助我获取SQL Server 2005中更新记录的代码.

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

推荐答案

VB.NET中的代码

Code in VB.NET

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

谢谢，
Mamun

Thanks,
Mamun

您可以按照以下代码进行操作.我在C#中的代码

You can follow the below code. My code in 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.

请参见此处 [

这篇关于更新记录代码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！