哪位前辈给看看这段代码哪错了 我在网上搜了好久 似乎说是sql语句错了 不知道怎么改 求赐教
private void cbxID_SelectedIndexChanged(object sender, System.EventArgs e)
{
//创建SQL命令对象
SqlCommand sqlcmd = new SqlCommand("SELECT * FROM [Dev_Test].[dbo].[Customers] WHERE CustomersID = @ ID", sqlConnection1);
//设置参数
sqlcmd.Parameters.AddWithValue("@ ID", cbxID.Text);
SqlDataReader sdr;
sqlConnection1.Open();
sdr = sqlcmd.ExecuteReader();
if (sdr.Read())
{
//使用不同的方式读取特定字段的值
txtCompanyName.Text = sdr.GetString(1);
txtContactName.Text = sdr["ContactName"].ToString();
txtContactTitle.Text = sdr[3].ToString();
txtAddress.Text = sdr.GetValue(4).ToString();
txtCity.Text = sdr["City"].ToString();
txtRegion.Text = sdr.GetValue(6).ToString();
txtPostalCode.Text = sdr[7].ToString();
txtCountry.Text = sdr[8].ToString();
txtPhone.Text = sdr[9].ToString();
txtFax.Text = sdr[10].ToString();
}
sdr.Close();
sqlConnection1.Close();
}
private void cbxID_SelectedIndexChanged(object sender, System.EventArgs e)
{
//创建SQL命令对象
SqlCommand sqlcmd = new SqlCommand("SELECT * FROM [Dev_Test].[dbo].[Customers] WHERE CustomersID = @ ID", sqlConnection1);
//设置参数
sqlcmd.Parameters.AddWithValue("@ ID", cbxID.Text);
SqlDataReader sdr;
sqlConnection1.Open();
sdr = sqlcmd.ExecuteReader();
if (sdr.Read())
{
//使用不同的方式读取特定字段的值
txtCompanyName.Text = sdr.GetString(1);
txtContactName.Text = sdr["ContactName"].ToString();
txtContactTitle.Text = sdr[3].ToString();
txtAddress.Text = sdr.GetValue(4).ToString();
txtCity.Text = sdr["City"].ToString();
txtRegion.Text = sdr.GetValue(6).ToString();
txtPostalCode.Text = sdr[7].ToString();
txtCountry.Text = sdr[8].ToString();
txtPhone.Text = sdr[9].ToString();
txtFax.Text = sdr[10].ToString();
}
sdr.Close();
sqlConnection1.Close();
}
sqlcmd.Parameters.AddWithValue("@ID", cbxID.Text);
我把空格去了出现这个错误是什么意思
Must declare the scalar variable "@ID".