报错“索引(从零开始)必须大于或等于零,且小于参数列表的大小”,请问这个情况如何处理?
private void button1_Click(object sender, EventArgs e)
{
link.con.Open();
string id = textBox1.Text;
string name = textBox2.Text;
string vname = textBox3.Text;
string vzd = textBox4.Text;
string vms = textBox5.Text;
string vjc = textBox6.Text;
string vzl = textBox7.Text;
string sql = string.Format(@"update ZJ set BNAME1='{1}',YNAME='{2}',ZD='{3}',ZZ='{4}',JC='{5}',ZLQK='{6}',ZT='{7}' where BIDD='{0}'", id, name, vname, vzd, vms, vjc, vzl);
SqlCommand cmd = new SqlCommand(sql, link.con);
cmd.ExecuteNonQuery();
MessageBox.Show("已成功修改!");
link.con.Close();
}