更新.txt

来自「C#知识库是在学习C#时积累的一些知识。本软件用C#编写,运行需要Microso」· 文本 代码 · 共 11 行

OleDbConnection myConn=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\D\DevCs\Works2\Person.mdb;");
myConn.Open();
OleDbDataAdapter thisAdapter= new OleDbDataAdapter("SELECT * FROM Intro",myConn);
OleDbCommandBuilder thisBuilder=new OleDbCommandBuilder(thisAdapter);
DataSet thisDataSet=new DataSet();
thisAdapter.Fill(thisDataSet,"Intro");
Console.WriteLine("Name before change:{0}",thisDataSet.Tables["Intro"].Rows[1]["TheName"]);
thisDataSet.Tables["Intro"].Rows[1]["TheName"]="Acme";//更新
thisAdapter.Update(thisDataSet,"Intro");
Console.WriteLine("Name after change:{0}",thisDataSet.Tables["Intro"].Rows[1]["TheName"]);
myConn.Close();