您所在位置：主题：[讨论]C#将控件中的数据向SQL中提交时提示对象〔表〕无效！！
jmtbai
[专家分：0] 发布于 2008-12-19 16:17:00
将控件中的数据提交到SQL数据库中，表的结构如下：
表名Nomal,表中有标识自动增加id.
代码如下：
SqlConnection conn =new SqlConnection("server=C89D111BE62A4FB;database=WareHouse;Uid=sa;Pwd=1124_asdf");
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "insert into Normal([Mno],[Mname],[Mamount],[Mprice],[Mmin],[Mmax],[Mclass],[Mbatch],[Shelf],[Intime],[Admin],[Supplier],[Notes]) Values ('" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox6.Text + "','" + textBox8.Text + "','" + textBox9.Text + "','" + comboBox2.SelectedItem.ToString () + "','" + textBox1.Text + "','" + textBox7.Text + "','" + comboBox1.SelectedItem.ToString () + "','" + textBox10.Text + "','" + textBox2.Text + "','" + richTextBox1.Text + "')";
cmd.Connection = conn;
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception err)
{
MessageBox.Show(err.Message, "修改记录失败");
}
finally
{
conn.Close();
}
可是老是提示，对象'Nomal'无效！
请高手帮我看看！[em18]
表名Nomal,表中有标识自动增加id.
代码如下：
SqlConnection conn =new SqlConnection("server=C89D111BE62A4FB;database=WareHouse;Uid=sa;Pwd=1124_asdf");
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "insert into Normal([Mno],[Mname],[Mamount],[Mprice],[Mmin],[Mmax],[Mclass],[Mbatch],[Shelf],[Intime],[Admin],[Supplier],[Notes]) Values ('" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox6.Text + "','" + textBox8.Text + "','" + textBox9.Text + "','" + comboBox2.SelectedItem.ToString () + "','" + textBox1.Text + "','" + textBox7.Text + "','" + comboBox1.SelectedItem.ToString () + "','" + textBox10.Text + "','" + textBox2.Text + "','" + richTextBox1.Text + "')";
cmd.Connection = conn;
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception err)
{
MessageBox.Show(err.Message, "修改记录失败");
}
finally
{
conn.Close();
}
可是老是提示，对象'Nomal'无效！
请高手帮我看看！[em18]