比如说有安扭btn1和updata_btn事件
private SqlCommand comm;
private SqlDataAdapter da;
private SqlCommandBuilder sqlcmb;
private DataSet ds;
...
void btn1_Click(object obj,EventArgs ea){
string str=//连接字符串
string sql="select * from aaa";
SqlConnection conn=new SqlConnection(str);
comm=new SqlCommand(sql,conn);
ds=new DataSet();
da=new SqlDataAdapter(sql,conn);
da.SelectCommand=comm;
sqlcmb=new SqlCmmandBuilder(da);
da.Fill(ds,"aaa");
dataGrid1.SetDataBinding(ds,"aaa");
}
void update_btn_Click(object obj,EventArgs ea){
da.Update(ds,"aaa"); //更新数据
} wish u good luck
Greatsft
private SqlCommand comm;
private SqlDataAdapter da;
private SqlCommandBuilder sqlcmb;
private DataSet ds;
...
void btn1_Click(object obj,EventArgs ea){
string str=//连接字符串
string sql="select * from aaa";
SqlConnection conn=new SqlConnection(str);
comm=new SqlCommand(sql,conn);
ds=new DataSet();
da=new SqlDataAdapter(sql,conn);
da.SelectCommand=comm;
sqlcmb=new SqlCmmandBuilder(da);
da.Fill(ds,"aaa");
dataGrid1.SetDataBinding(ds,"aaa");
}
void update_btn_Click(object obj,EventArgs ea){
da.Update(ds,"aaa"); //更新数据
} wish u good luck
Greatsft
SqlCmmandBuilder db;
SqlDataAdapter da;
da=new SqlDataAdapter(SqlSelect);
db=new SqlCmmandBuilder (da);//这样就不用你写Update和Delete等语句了
更该完事就可以使用da.update(dataset);
using System.Data.SqlClient;