啊老是报错啊
日期：2014-05-17 浏览次数：20784 次
求助啊，，老是报错啊~~~
SqlConnection con = new SqlConnection();
con.ConnectionString = "Data Source=PHOEBE-PC;Initial Catalog=Mr_Liu_cs_design;Integrated Security=True";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = string.Format("select COUNT(8)from Mr_Liu_class2_type where t_type='{0}';", temp);
cmd.Connection = con;
con.Open(); //打开数据库连接
int count = Convert.ToInt32(cmd.ExecuteScalar());
if (count > 0)
{
MessageBox.Show("添加计量单位已存在");
}
else
{
cmd.CommandText = string.Format("insert into Mr_Liu_class2_type('{0}')", temp);
cmd.ExecuteNonQuery();//用ExecuteNonQuery()的方法来执行查询语句
MessageBox.Show("添加成功");
}
con.Close(); //关闭数据库的连接
------最佳解决方案--------------------
SqlConnection con = new SqlConnection();
con.ConnectionString = "Data Source=PHOEBE-PC;Initial Catalog=Mr_Liu_cs_design;Integrated Security=True";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = string.Format("select COUNT(8)from Mr_Liu_class2_type where t_type='{0}';", temp);
cmd.Connection = con;
con.Open(); //打开数据库连接
int count = Convert.ToInt32(cmd.ExecuteScalar());
if (count > 0)
{
MessageBox.Show("添加计量单位已存在");
}
else
{
cmd.CommandText = string.Format("insert into Mr_Liu_class2_type('{0}')", temp);
cmd.ExecuteNonQuery();//用ExecuteNonQuery()的方法来执行查询语句
MessageBox.Show("添加成功");
}
con.Close(); //关闭数据库的连接
------最佳解决方案--------------------
string c = "Data Source=PHOEBE-PC;Initial Catalog=Mr_Liu_cs_design;Integrated Security=True";
using(SqlConnection con = new SqlConnection(c)
)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = string.Format("select COUNT(8)from Mr_Liu_class2_type where t_type='{0}';", temp);
cmd.Connection = con;
con.Open(); //打开数据库连接
int count = Convert.ToInt32(cmd.ExecuteScalar());
if (count > 0)
{
MessageBox.Show("添加计量单位已存在");
}
else
{
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
