更新记录代码 [英] 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屋!
查看全文