SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=data;User ID=sa;password=sa;Integrated Security=False");
//参数化sql语句
public void InSertData(string s1,string s2, string s3)//插入数据库
{
string sql = "insert into table(A,B,C) values(@A, @B, @C)";
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("@A", s1);
cmd.Parameters.AddWithValue("@B", s2);
cmd.Parameters.AddWithValue("@C", s3);
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
}
}
private void button1_Click(object sender, EventArgs e)
{
DataSet ds = getdata();//dataset
tr
c# 将dataset中的数据导入到sql数据库中
最新推荐文章于 2023-04-17 17:25:29 发布