SqlConnection cnn = new SqlConnection();
cnn.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True";
/// SqlCommand cmm = new SqlCommand();
SqlCommand cmm = new SqlCommand("Insert Into Table1(dd) Values(@dd)", cnn);
/// cmm.Connection = cnn;
cnn.Open();
///cmm.CommandText = "Insert Into t0522(type)" + "Values(@type)";
///cmm.Parameters.Add("@type", System.Data.SqlDbType.NVarChar).Value=L1.Text; ///这种也是加参数的方式,只是下面一种更加简洁
// cmm.Parameters.AddWithValue("@id", 50);
cmm.Parameters.AddWithValue("@dd", "happy");
//cmm.Parameters.AddWithValue("@err_message", str[ERR_NUM]);
///cmm.Parameters["@type"].Value = L1.Text;
///cmm.ExecuteNonQuery();
int s = cmm.ExecuteNonQuery();
//以下这几句是用于在dataGridView中显示数据库中的全部数据
SqlDataAdapter adp = new SqlDataAdapter("select id,dd From Table1", cnn);
DataTable dt = new DataTable();
adp.Fill(dt);
GridView1.DataSource = dt.DefaultView;
if (s > 0)
{
MessageBox.Show("数据上传成功");
}
else
{
MessageBox.Show("数据更新失败");
}
cnn.Close();