先贴上System.Data.OracleClient类的下载地址安装安装再说
解决方案 »
- 一个串口写入时的问题,急啊!!!!!
- 一个简单的AJAX问题
- SQL如何清楚空格或换行符!!!!!!!!!!!送分!!!!!!!!!!!!!
- winform中datagrid如何设置一列的颜色!谢谢大家,着急!!!
- 微软专家救命:c#编译器bug,程序停止不动
- 请问,url传值到由两个frame组成的页面的问题
- 在C#中,在打安装包的时候如何也让SQLserver2000数据库也安装上去!求救!!!!分不够再加!!!
- 高手帮帮忙,如何获取光标所在区域的控件名!谢谢~~~~~~~~
- C#教程推荐一本
- [急]高分求教关于c#的简单问题 期待高手指教~~~~~在线等~~~~~~
- 请教,哪位朋友做过单点登录系统(Single Sign On,SSO) ,可否赐教一二?
- c#的web程序中如何在frameset中建tree
http://msdn.microsoft.com/downloads/sample.asp?url=/msdn-files/027/001/940/msdncompositedoc.xml
NULL, "PRPNM" NUMBER(1), "LYNM" NUMBER(1), "WTTP" NUMBER(1),
"GETM" DATE, "CODMN" NUMBER(4, 1), "CODCR" NUMBER, "BOD5" NUMBER(
5, 1), "DSSCCO2" NUMBER(4, 2), "CRRDCO2" NUMBER(4, 2), "CL"
NUMBER, "SO4" NUMBER, "HCO3" NUMBER(5, 2), "CO3" NUMBER(5, 2),
"F" NUMBER(5, 2), "SMION" NUMBER(7, 2), "TRIGTY" NUMBER(6, 2),
"TALKNTY" NUMBER(6, 2), "DO" NUMBER, "NH4N" NUMBER, "NH3" NUMBER,
"NO2" NUMBER, "NO3" NUMBER, "CN" NUMBER, "TCN" NUMBER, "TP"
NUMBER(5, 3), "TN" NUMBER(5, 2), "N" NUMBER(4, 2), "P" NUMBER(6,
4), "PO4" NUMBER(5, 3), "S2" NUMBER, "SI" NUMBER(5, 3), "B2"
NUMBER(4, 2), "I" NUMBER(5, 3), "DSSCCL" NUMBER(5, 3), "ASS"
CHAR(7), "SE" NUMBER(7, 5), "HXL" NUMBER(5, 3), "CHLA" NUMBER(4,
2))
TABLESPACE "USERS" PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE ( INITIAL 64K NEXT 128K MINEXTENTS 1 MAXEXTENTS 4096
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
LOGGING
Cause: An invalid or uninitialized number is passed in. Action: Use a valid number. To initialize number, call OCINumberInit(). 这是Oracle错误代码;说明此错误是Oracle抛出的,你应该将你的语句打印一下确认://myConn.Close(); //此处为什么要关闭?试着注释一下
cmd.Connection=myConn;count=cmd.ExecuteOracleScalar();
Console.WriteLine(count.toString());
--------------------------------------------------------
write belew:
Private Sub btnOracleClient_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles btnOracleClient.Click
Dim OraCon As New OracleConnection()
Dim OraComm As New OracleCommand()
Dim Cnt As IntegerOraCon.ConnectionString = "Password=xxxx;User ID=yyyy;Data
Source=TEST"
OraComm.CommandType = CommandType.Text
OraComm.CommandText = "SELECT COUNT(*) FROM MYTABLE"
OraCon.Open()
Cnt = OraComm.ExecuteOracleScalarMessageBox.Show(Cnt, "Total No of Rows in MYTABLE Table")OraComm = Nothing
OraCon.Close()
OraCon = NothingEnd Sub
End Class
---------------------------------------------------------------
have a happy study!