一个数据库更新的问题，请高手指点。谢谢！

Question

给你一个例子
SqlConnection myConnection=new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
myConnection.Open();
string mySql;
mySql="Update UserTable Set UserName='"+ UName.Text +"',Password='"+ PWord.Text +"',UserGroup='"+ nGroup +"' Where Id='"+ nId +"'";
SqlCommand myCommand=new SqlCommand(mySql,myConnection);
myCommand.ExecuteNonQuery();

Answer 1

我的代码如下：
好象也没什么问题呀？
UpdateSqlCommand=KhSqlConnection.CreateCommand();UpdateSqlCommand.CommandText="UPDATE kehu  "+"SET CompanyName=@NewCompanyName, "+"ContactName=@NewContactName,"+"Tel=@NewTel,Fax=@NewFax,PostalCode=@NewPostalCode, "+"City=@NewCity,Address=@NewAddress"+"WHERE ID=@OldID ";UpdateSqlCommand.Parameters.Add("@NewCompanyName",SqlDbType.NVarChar,50,"CompanyName");UpdateSqlCommand.Parameters.Add("@NewContactName",SqlDbType.NVarChar,50,"ContactName");UpdateSqlCommand.Parameters.Add("@NewTel",SqlDbType.NVarChar,24,"Tel");UpdateSqlCommand.Parameters.Add("@NewFax",SqlDbType.NVarChar,24,"Fax");
UpdateSqlCommand.Parameters.Add("@NewPostalCode",SqlDbType.NVarChar,10,"PostalCode");UpdateSqlCommand.Parameters.Add("@NewCity",SqlDbType.NVarChar,15,"City");UpdateSqlCommand.Parameters.Add("@NewAddress",SqlDbType.NVarChar,50,"Address");UpdateSqlCommand.Parameters.Add("@OldID",SqlDbType.Char,10,"ID");UpdateSqlCommand.Parameters["@OldID"].SourceVersion=DataRowVersion.Original; KhSqlDataAdapter.UpdateCommand=UpdateSqlCommand;KhDataView[KhCurrencyManager.Position].BeginEdit();KhDataView[KhCurrencyManager.Position]["CompanyName"]=textBox1.Text;KhDataView[KhCurrencyManager.Position]["ContactName"]=textBox2.Text;KhDataView[KhCurrencyManager.Position]["Tel"]=textBox3.Text;KhDataView[KhCurrencyManager.Position]["Fax"]=textBox4.Text;KhDataView[KhCurrencyManager.Position]["PostalCode"]=textBox5.Text;KhDataView[KhCurrencyManager.Position]["City"]=textBox6.Text;KhDataView[KhCurrencyManager.Position]["Address"]=textBox7.Text;KhDataView[KhCurrencyManager.Position].EndEdit();KhSqlDataAdapter.Update(KhDataSet,"kehu");请跟我看看！谢谢