Question

C#数据库编程中，如何编写删除一行记录的代码？

这是我目前写的代码，请大家在基础上帮我修改完善一下谢谢！
SqlConnection Conn = new SqlConnection();
Conn.Open();
SqlConnection conn = new SqlConnection();
string connString = "Data Source=PC201311011615;Initial Catalog=地面信息数据库-Database;Integrated Security=True";
string deleteQuery = "DELETE FROM house where hno= " + textBox1.Text;
conn.ConnectionString = connString;
SqlCommand mycommand = new SqlCommand(deleteQuery, conn);
mycommand.ExecuteNonQuery();

Answer 1

貌似你这几行可以删除记录，难道有什么错误，不过你用的那些对象都要释放的，否则内存泄露