1.用SQl语句
use pangu
update department
set d_name = ’财务部’
where dept_id = ’1002’这样好呢?2.用datatable or dataset string connString = "Server=WWW-28E16B9FC9D;Database=test;Integrated Security=SSPI";
SqlConnection conn = new SqlConnection(connString);
SqlDataAdapter myAdapter = new SqlDataAdapter();
SqlCommand myCommand = new SqlCommand("select * from player", conn);
myAdapter.SelectCommand = myCommand;
SqlCommandBuilder myCommandBuilder1 = new SqlCommandBuilder(myAdapter);
myAdapter.Update(dt);还是这样好?3.情景: winform中创建一个datagridview,然后绑定,然后进行数据的修改更新
4.用了第二个 第一个什么时候使用合适?
use pangu
update department
set d_name = ’财务部’
where dept_id = ’1002’这样好呢?2.用datatable or dataset string connString = "Server=WWW-28E16B9FC9D;Database=test;Integrated Security=SSPI";
SqlConnection conn = new SqlConnection(connString);
SqlDataAdapter myAdapter = new SqlDataAdapter();
SqlCommand myCommand = new SqlCommand("select * from player", conn);
myAdapter.SelectCommand = myCommand;
SqlCommandBuilder myCommandBuilder1 = new SqlCommandBuilder(myAdapter);
myAdapter.Update(dt);还是这样好?3.情景: winform中创建一个datagridview,然后绑定,然后进行数据的修改更新
4.用了第二个 第一个什么时候使用合适?
想问 1 能完成不? 应该可以吧。就是用sql语句完成更新,不是像2中的直接把dataset或者是datatable更新到数据库。
没什么可比性? why? 求教
SqlConnection conn = new SqlConnection(connString);
SqlDataAdapter myAdapter = new SqlDataAdapter();
SqlCommand myCommand = new SqlCommand("update department set d_name = ’财务部’where dept_id = ’1002’", conn);
myAdapter.SelectCommand = myCommand;
SqlCommandBuilder myCommandBuilder1 = new SqlCommandBuilder(myAdapter);
myAdapter.Update(dt);
结了啊