c# 将dataset中的数据导入到sql数据库中

来源：互联网发布：中俄青年大数据编辑：程序博客网时间：2024/05/16 01:22

 　　　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            try            {                foreach (DataRow dr in ds.Tables[0].Rows)                {                       InSertData(dr[0].ToString(), dr[1].ToString(), dr[2].ToString());                }            }            catch (Exception ex)            {                MessageBox.Show(ex.Message);            }        }

0 0