Question

我用c# 向sql server2005中插入数据 然后保存 这么写为什么不行啊 怎么改 请高人指点

string connstr = "Data Source=.\\SQLEXPRESS;Initial Catalog=Table1;Integrated Security=true";
SqlConnection conn = new SqlConnection(connstr);
conn.Open();
string sql = "insert into Table_1(c_Id) values(5678 )";
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Close();

Answer 1

conn.Close()之前加上一行：cmd.ExecuteNoneQuery(); 再试试

Answer 2

SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();