public void CreateSqlDataAdapter() {
string mySelectText = "SELECT * FROM Categories ORDER BY CategoryID";
string mySelectConn = "Data Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind";
SqlDataAdapter myDataAdapter = new SqlDataAdapter(mySelectText,mySelectConn);
myDataAdapter.UpdateCommand.CommandText = "UPDATE Categories SET Description='Cheeses, Milk, Ice Cream' WHERE CategoryName='Dairy Products'";
myDataAdapter.UpdateCommand.Connection = (SqlConnection)myDataAdapter.SelectCommand.Connection;
}public DataSet CreateCmdsAndUpdate(DataSet myDataSet,string myConnection,string mySelectQuery,string myTableName)
{
OleDbConnection myConn = new OleDbConnection(myConnection);
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter();
myDataAdapter.SelectCommand = new OleDbCommand(mySelectQuery, myConn);
OleDbCommandBuilder custCB = new OleDbCommandBuilder(myDataAdapter); myConn.Open(); DataSet custDS = new DataSet();
myDataAdapter.Fill(custDS); //code to modify data in dataset here myDataAdapter.Update(custDS, myTableName); myConn.Close(); return custDS;
}
string mySelectText = "SELECT * FROM Categories ORDER BY CategoryID";
string mySelectConn = "Data Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind";
SqlDataAdapter myDataAdapter = new SqlDataAdapter(mySelectText,mySelectConn);
myDataAdapter.UpdateCommand.CommandText = "UPDATE Categories SET Description='Cheeses, Milk, Ice Cream' WHERE CategoryName='Dairy Products'";
myDataAdapter.UpdateCommand.Connection = (SqlConnection)myDataAdapter.SelectCommand.Connection;
}public DataSet CreateCmdsAndUpdate(DataSet myDataSet,string myConnection,string mySelectQuery,string myTableName)
{
OleDbConnection myConn = new OleDbConnection(myConnection);
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter();
myDataAdapter.SelectCommand = new OleDbCommand(mySelectQuery, myConn);
OleDbCommandBuilder custCB = new OleDbCommandBuilder(myDataAdapter); myConn.Open(); DataSet custDS = new DataSet();
myDataAdapter.Fill(custDS); //code to modify data in dataset here myDataAdapter.Update(custDS, myTableName); myConn.Close(); return custDS;
}
解决方案 »
- FolderBrowserDialog控件可以实现选择文件吗?
- 问一个程序初始化时,自动建表的设计方案
- 关于Winform中DataGridView的数据更新速度的问题
- 着急:.net 2003 winform 添加了一个第三方控件后总是自动关闭 ,还可以自动生成成功,当把程序运行时也是自动关闭。不知道什么原因,请高人指点一下。
- 请教一个c#关于点移动的超难题!急急急!!!
- 亂碼問題
- 关于聊天室人员列表的问题???--急--在线等
- 如何从DataTable中取出不同的数据,类似sql的Distinct关键字
- 请教:尚未注册 OLE DB 访问接口 Microsoft.Jet.OLEDB.4.0
- C#使用的数据库怎样迁移?
- 怎样实现自己定义的数据类型能加减(+-)象数值型样的??
- 关于singleton模式应用的一点疑惑?
SqlCommand comm=conn.CreatCommand();
comm.CommandText="Select * from employee";
SqlDataAdapter adp=new SqlDataAdapter();
adp.UpdateCommand=comm;
DataSet ds=new DataSet();
conn.Open();
adp.Fill(ds,"employee");
conn.Close();
是新增的数据还是修改的还是删除的还是原始的意思。
SqlDataAdapter 会根据数据集中不同的版本的数据来分别执行SqlDataAdapter
中不同的sqlcommand,并将数据集中的字段值作为参数传给commandtext中的params这就实现了数据的更新。
也就是dataset中有了更改的版本的数据,那么,都会一进行更新。
无需自己建立循环来处理。
OleDbCommandBuilder custCB = new OleDbCommandBuilder(myDataAdapter);
想知道怎么写的,打印出来看看不就知道了。