public static DataSet SelectSqlSrvRows(string myConnection, string mySelectQuery, string myTableName)
{
SqlConnection myConn = new SqlConnection(myConnection);
SqlDataAdapter myDataAdapter = new SqlDataAdapter();
myDataAdapter.SelectCommand = new SqlCommand(mySelectQuery, myConn);
SqlCommandBuilder cb = new SqlCommandBuilder(myDataAdapter); myConn.Open(); DataSet ds = new DataSet();
myDataAdapter.Fill(ds, myTableName); //code to modify data in DataSet here //Without the SqlCommandBuilder this line would fail
myDataAdapter.Update(ds, myTableName); myConn.Close(); return ds;
}
{
SqlConnection myConn = new SqlConnection(myConnection);
SqlDataAdapter myDataAdapter = new SqlDataAdapter();
myDataAdapter.SelectCommand = new SqlCommand(mySelectQuery, myConn);
SqlCommandBuilder cb = new SqlCommandBuilder(myDataAdapter); myConn.Open(); DataSet ds = new DataSet();
myDataAdapter.Fill(ds, myTableName); //code to modify data in DataSet here //Without the SqlCommandBuilder this line would fail
myDataAdapter.Update(ds, myTableName); myConn.Close(); return ds;
}
解决方案 »
- 关于文件上传下载?
- 求教:如何编程打开一个已经存在的应用程序!!
- 计算类似格式的"2008-8-4 0:00:34" 和 "2008-8-4 0:14:54" 的时间差 具体怎么写
- listview控件 如何让显示的图片在上面,文字在下面
- 怎样将PrintDocument里的内容导成jpg图片?
- 在线请教
- 超级郁闷的数据库连接问题!!!
- 急!急!急!获取访问网站的用户的ip
- 可不可以将DLL文件反编译成C#文件,如果行的话应该怎么办??
- 为什么有那么几个命名空间总是无法声明???
- 按del键,删除datagrid中的行时,发生的事件是什么?象下面这样的事件如何和datagrid关联起来?
- 请问我这段代码错在那里了,我急着用的,谢谢了
private SqlCommandBuilder sqlcmb;
改成
private static SqlDataAdapter da=new SqlDataAdapter();
private static SqlCommandBuilder sqlcmb;
就ok了
因为当你再调用类时,da已经不是原来那个了,只有加static它的值才再一次调用时不会变,只有重新开始或者da.dispose()才会变
private void frmProvider2_Load
因为窗体加载时总要从数据库取数据显示的吧