如何将数据添加到数据库中?
在家试了半天,就是不能将数据添加到SQL2000中
代码如下:
private void button1_Click(object sender, EventArgs e)
{
System.Data.SqlClient.SqlConnection cnn = new System.Data.SqlClient.SqlConnection();
cnn.ConnectionString = "server(local);database=pubs;uid=sa;pwd=";
cnn.Open();
string sql = "insert into user values('" + textBox5.Text + "','" + textBox2.Text + "','" + textBox1.Text + "','" + textBox3.Text + "')";
System.Data.SqlClient.SqlCommand com = new System.Data.SqlClient.SqlCommand(sql, cnn);
com.ExecuteNonQuery();
cnn.Close();
}
请那位高手帮帮小弟