OracleConnection cn = new OracleConnection(@"data source = ctitest;user=oper;password=oper;");
cn.Open();
strSql="select ID,CONNECTID,ANI,DNIS,AGENTID,CUSTOMID,TYPEID,PROGRAMID,TITLE,FLAG,ADDTIME from ccproject_new";
cmd = new OracleCommand(strSql,cn);
Da=new OracleDataAdapter(cmd);
Da.Fill(dset,"ccproject_new");
dset.ReadXml(@"C:\Documents and Settings\Meteor1\My Documents\Visual Studio Projects\声讯数据统计\bin\Debug\free.xml" );
Da.Update(dset,"ccproject_new");
cn.Open();
strSql="select ID,CONNECTID,ANI,DNIS,AGENTID,CUSTOMID,TYPEID,PROGRAMID,TITLE,FLAG,ADDTIME from ccproject_new";
cmd = new OracleCommand(strSql,cn);
Da=new OracleDataAdapter(cmd);
Da.Fill(dset,"ccproject_new");
dset.ReadXml(@"C:\Documents and Settings\Meteor1\My Documents\Visual Studio Projects\声讯数据统计\bin\Debug\free.xml" );
Da.Update(dset,"ccproject_new");
解决方案 »
- asp.net网页设置为1100px,怎么不能居中啊
- 大家看一下这个代码哪里错了???
- ==很奇怪的问题== 程序偶尔在 Thread.Start() 处卡住
- 更改winform窗体标题栏的图标
- E章,思归,旗娃等大哥,请问如何判断客户端与服务器之间的连接状态,或者能判断与服务器sqlserver的是否连通?????
- 能否在不启动vs2008的情况下编译整个solution?
- C#掉用API,帮忙啊!
- 在Web页面中如何动态时实获知文本框内容发生改变?在线急等变!!!
- 程序A嵌入程序B问题,急!!!!
- c sharp 可以用代码产生一个新页面码?(不用点击,也不用java)
- 在WEB的DATAGRID中一行程序总是过不去?请各位指教...
- 关于TreeView的问题
OracleCommand cmd = new OracleCommand(strSql,cn);
OracleDataAdapter Da=new OracleDataAdapter(cmd);
DataSet dset= new DataSet();
你们可以给段例子吗?
command.CommandType = CommandType.StoredProcedure
With command.Parameters
.Add(New SqlParameter("@sheetobjid", SqlDbType.NChar, 38))
.Add(New SqlParameter("@cbiobjid", SqlDbType.NChar, 38))
.Add(New SqlParameter("@cbiitemobjid", SqlDbType.NChar, 38))
.Add(New SqlParameter("@safevalue", SqlDbType.SmallInt))
.Add(New SqlParameter("@riskvalue", SqlDbType.SmallInt)) .Item(0).SourceColumn = "SheetObjID"
.Item(1).SourceColumn = "CBIObjID"
.Item(2).SourceColumn = "CBIItemObjID"
.Item(3).SourceColumn = "SafeValue"
.Item(4).SourceColumn = "RiskValue" End With
Dim comm As New Common
command.Transaction = trans
Dim upload_Adapter As New SqlDataAdapter
upload_Adapter.TableMappings.Add("Table", "SheetCBI")
upload_Adapter.InsertCommand = command
upload_Adapter.Update(ds_SheetCBI, "SheetCBI")
If ds_SheetCBI.HasErrors Then
ds_SheetCBI.Tables("SheetCBI").GetErrors(0).ClearErrors()
Else
ds_SheetCBI.AcceptChanges()
UploadSheetCBI = True
End If
End Function
今天上午才写的一段代码,不知对你是否有帮助,你看看吧!
System.Data.OracleClient.OracleCommandBuilder cmb=new OracleCommandBuilder(Da)