以下是插入语句,但我还想实现更新当前数据库中的数据,不知道UPDATA语句怎么写,请指教!谢谢string myConnectionString="Data Source=ghost;Initial Catalog=hwinfo;User Id=sa;Password=admin";
SqlConnection myConnection = new SqlConnection(myConnectionString);
string mycn="update infolist set(name,datatime,branch) values('"+this.nametext.Text+"','"+this.timetext.Text+"','"+this.branch.SelectedItem.Value+"')";
SqlCommand myComm = new SqlCommand(mycn);
myComm.Connection = myConnection;
myComm.Connection.Open();
myComm.ExecuteNonQuery();
myConnection.Close();
SqlConnection myConnection = new SqlConnection(myConnectionString);
string mycn="update infolist set(name,datatime,branch) values('"+this.nametext.Text+"','"+this.timetext.Text+"','"+this.branch.SelectedItem.Value+"')";
SqlCommand myComm = new SqlCommand(mycn);
myComm.Connection = myConnection;
myComm.Connection.Open();
myComm.ExecuteNonQuery();
myConnection.Close();
解决方案 »
- 关于NeatUpload
- C# winform TreeView 问题
- VS2008安装的问题
- datatable 循环读取数据
- 如何判断操作系统类型?是winxp,winxp sp1,sp2,sp3,还是win2003 ,win2003 sp1? vista or vista sp1?
- 类型转换问题
- 有没人做过C# winfrom 程序登录的时候初始化系统时间
- menuitem 问题,大虾进来看看!
- C#中怎么弹出密码输入提示框
- 专家不帮我??谁帮我???API调用的史无前例的super难题(PFXExportCertStoreEx)
- 好东东!!!!!!!!!!!!!!!!11111
- 我想用c#桌面程序和c#三层结构的oa和网友交换c#三层结构的全站程序学习
//a是条件
SqlConnection myConnection = new SqlConnection(myConnectionString);
string mycn="update infolist set name='"+this.nametext.Text+"',datatime='"+this.timetext.Text+"',branch='"+this.branch.SelectedItem.Value+"' where id=.....条件";
SqlCommand myComm = new SqlCommand(mycn);
myComm.Connection = myConnection;
myComm.Connection.Open();
myComm.ExecuteNonQuery();
myConnection.Close();
==》
string mycn="update infolist set name = '"+this.nametext.Text+"',datatime='"+this.timetext.Text+"',branch = '"+this.branch.SelectedItem.Value+"') where ...";
这是怎么回事!?!?
谢谢
SqlCommand myComm = new SqlCommand(mycn , myConnection);myConnection.Open();
myComm.ExecuteNonQuery();
myConnection.Close();
//a是条件