SqlConnection conn = new SqlConnection();
conn.ConnectionString =" Data Source=www.wlsoft.cn,1212;Initial Catalog=YPZB;Persist Security Info=True;User ID=sa;Password=admin75";
SqlCommand UpdateCmd =new SqlCommand ();
conn.Open(); UpdateCmd.Connection = conn;
UpdateCmd.CommandText = "EXECUTE UPDATE_TBGSXX @CompanyName,@Address,@Phone,@Fax,@Postcode,@UserName,@Email,@Res";
UpdateCmd.CommandType = CommandType.StoredProcedure;
UpdateCmd.Parameters.Clear();
UpdateCmd.Parameters.Add("@CompanyName", SqlDbType.NVarChar ,50);
UpdateCmd .Parameters .Add("@Address", SqlDbType .NVarChar ,50 );
UpdateCmd .Parameters .Add("@Phone", SqlDbType .NVarChar ,20);
UpdateCmd .Parameters .Add("@Fax", SqlDbType .NVarChar ,20 );
UpdateCmd .Parameters .Add("@Postcode", SqlDbType.NChar,50);
UpdateCmd .Parameters .Add("@UserName", SqlDbType .NVarChar ,8 );
UpdateCmd .Parameters .Add("@Res", SqlDbType .NVarChar ,50 );
UpdateCmd .Parameters.Add ("@Email", SqlDbType .NVarChar,50);
UpdateCmd .Parameters .Add("@ID", SqlDbType.NVarChar,20);
UpdateCmd.Parameters["@CompanyName"].Value = CompanyName.Text;
UpdateCmd.Parameters["@Address"].Value = Address.Text;
UpdateCmd.Parameters["@Phone"].Value = Phone.Text;
UpdateCmd.Parameters["@Fax"].Value = Fax.Text;
UpdateCmd.Parameters["@Postcode"].Value = Postcode.Text;
UpdateCmd.Parameters["@UserName"].Value = UserName.Text;
UpdateCmd.Parameters["@Res"].Value = Res.Text;
UpdateCmd.Parameters["@Email"].Value = Email.Text;
UpdateCmd.Parameters["@ID"].Value = "ad"; UpdateCmd.ExecuteNonQuery();
-------------------CommandText直接写存储过程的名称,比如
UpdateCmd.CommandText = "dbo.getData";不要写exec 也不要加参数进去,参数在Parameters里添加并使用。