一定需要
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#上传到数据库
![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLiAzNfRHLGZkRGZkRfJ3bs92YsYTMfVmepNHL90TUPVTRq50dJRkTyUERNlHNywEMW1mY1RzRapnTtxkb5ckYplTeMZTTINGMShUYfRHelRHLwEzX39GZhh2css2RkBnVHFmb1clWvB3MaVnRtp1XlBXe0xyayFWbyVGdhd3LcV2Zh1Wa9M3clN2byBXLzN3btg3Pn5GcukTMwETNxcTMzEzMwAjMwIzLc52YucWbp5GZzNmLn9Gbi1yZtl2Lc9CX6MHc0RHaiojIsJye.png)
_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为自定义的数据库帮助类
成功