C#：使用DataSet上傳到資料庫

一定需要

SqlCommandBuilder(sda)

SqlDataAdapter sda = new SqlDataAdapter("select * from Student", conn);
SqlCommandBuilder scb = new SqlCommandBuilder(sda);
DataSet ds = new DataSet();
sda.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
DataRow dr = ds.Tables[0].NewRow();
dr["id"] = 2013;
dr["name"] = "劉念";
dr["course"] = "高等數學";
dr["score"] = 100;
ds.Tables[0].Rows.Add(dr);
sda.Update(ds);
ds.AcceptChanges();
           

Txt檔案從c#上傳到資料庫

_2018DB db = new _2018DB();
string path = "D:/code/2017 研究所學生複試/patient.txt";
  StreamReader sr = new StreamReader(path,Encoding.UTF8);

 string line = "";
 while (sr.Peek() != -1)
 {
     line = sr.ReadLine();
//控制台顯示
     Debug.WriteLine(line);
     string[] arr=line.Split(' ');
     db.update(string.Format("insert into Patient values({0},'{1}','{2}',{3})",arr[0],arr[1],arr[2],arr[3]));

 }
 MessageBox.Show("添加成功");
           

db為自定義的資料庫幫助類

成功