oleDbCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ temp +";Extended Properties=Excel 8.0";
oleDbCom.CommandText = "select * from [aa$]";
oleDbCom.Connection = oleDbCon;
oleDbDA.SelectCommand = oleDbCom;
oleDbDA.Fill(this.dataSet1,"aa"); DataGrid1.DataSource = dataSet1.Tables["aa"].DefaultView;
DataGrid1.DataBind();oleDbCon.ConnectionString = "Location=192.168.0.130:50000;Provider=\"IBMDADB2.1\";Mode=ReadWrite;User ID= db2admin;Data Source=AISNB;Password = db2admin";
oleDbCom.CommandText = "select * from units where unit='aaa'";
oleDbCom.Connection = oleDbCon;
oleDbDA.SelectCommand = oleDbCom;
System.Data.OleDb.OleDbCommandBuilder cb=new System.Data.OleDb.OleDbCommandBuilder(oleDbDA);
oleDbCon.Open();
oleDbDA.Fill(this.dataSet2,"aa");
oleDbCon.Close();//
dataSet2 = dataSet1.Copy();
dataSet2.Tables["aa"].PrimaryKey = new DataColumn[]{dataSet2.Tables["aa"].Columns["unit"]};//建立一个主键
DataGrid2.DataSource = dataSet2.Tables["aa"].DefaultView;
DataGrid2.DataBind();
Response.Write(oleDbDA.Update(dataSet2,"aa"));
//总是返回为0没更新任何一行
如果不用copy()采用dataSet2.Tables["aa"].Rows.Add(dr);报错说是没有updatecommand
oleDbCom.CommandText = "select * from [aa$]";
oleDbCom.Connection = oleDbCon;
oleDbDA.SelectCommand = oleDbCom;
oleDbDA.Fill(this.dataSet1,"aa"); DataGrid1.DataSource = dataSet1.Tables["aa"].DefaultView;
DataGrid1.DataBind();oleDbCon.ConnectionString = "Location=192.168.0.130:50000;Provider=\"IBMDADB2.1\";Mode=ReadWrite;User ID= db2admin;Data Source=AISNB;Password = db2admin";
oleDbCom.CommandText = "select * from units where unit='aaa'";
oleDbCom.Connection = oleDbCon;
oleDbDA.SelectCommand = oleDbCom;
System.Data.OleDb.OleDbCommandBuilder cb=new System.Data.OleDb.OleDbCommandBuilder(oleDbDA);
oleDbCon.Open();
oleDbDA.Fill(this.dataSet2,"aa");
oleDbCon.Close();//
dataSet2 = dataSet1.Copy();
dataSet2.Tables["aa"].PrimaryKey = new DataColumn[]{dataSet2.Tables["aa"].Columns["unit"]};//建立一个主键
DataGrid2.DataSource = dataSet2.Tables["aa"].DefaultView;
DataGrid2.DataBind();
Response.Write(oleDbDA.Update(dataSet2,"aa"));
//总是返回为0没更新任何一行
如果不用copy()采用dataSet2.Tables["aa"].Rows.Add(dr);报错说是没有updatecommand
解决方案 »
- 关于sql语句
- 求asp.net项目的例子或者方法
- 正被别的用户锁定
- ajax中的getElementByTagName问题?
- 刚入门的ASP.NET新手如何有效快速学习
- 求一存储过程的最好方法...
- 请教关于DataGrid的问题!感谢!
- 网页中访问Directory.GetFiles("z:\abc"),z盘为映射其他机器。提示“登录失败: 未知的用户名或错误密码”
- 我在datalist里面放若干个<imagebutton><label>,怎么才能获取<imagebutton>的onclick事件。<imagebutton>的个数从数据表中得到。
- datagrid 数据绑定问题!!!!!
- 如何让前进,后退按钮 进入页面无效
- 把数据读到DataSet之后,还能不能通过sql语句从DataSet中读取数据,进行二次查询
string strSelSql = ""
SqlDataAdapter sqlAdapter = new SqlDataAdapter(strSelSql,sqlConn);
//用于Update ---必须要有
SqlCommandBuilder sqlCommBuilder = new SqlCommandBuilder(sqlAdapter); DataSet dsSql = new DataSet();
sqlAdapter.Fill(dsSql);
//
for (int i=0;i<dt.Rows.Count;i++)
{
DataRow dr = dtSql.NewRow();
//设置其他列
for (int n=0;n<dt.Columns.Count;n++)
{ .......... }
dtSql.Rows.Add(dr);
}
//更新--Update sqlAdapter.Update(dsSql);
sqlCommBuilder.RefreshSchema();
oleDbDA.SelectCommand = oleDbCom;
oleDbDA.UpdateCommand = oleDbCom;
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.InvalidOperationException: 对于不返回任何基表信息的 SelectCommand 不支持动态 SQL 生成。
OleDbCommandBuilder我也加了之后用cb.GetInsertCommand().CommandText之类的看不到任何东西