Dim cn1 As Data.OracleClient.OracleConnection
cn1 = New Data.OracleClient.OracleConnection("userid=guanlizhe;datasource=dbsky;password=1;")
Dim MyString1 As String = "Select * from usertable"
Dim cmd1 As Data.OracleClient.OracleCommand = New Data.OracleClient.OracleCommand(MyString1)
cn1.Open()
DataGrid1.DataSource = cmd1.ExecuteReader()
DataGrid1.DataBind()
Label2.Text = "ok"
系统提示:The connection is closed!
请问这是为什么啊?感谢感谢!!!
cn1 = New Data.OracleClient.OracleConnection("userid=guanlizhe;datasource=dbsky;password=1;")
Dim MyString1 As String = "Select * from usertable"
Dim cmd1 As Data.OracleClient.OracleCommand = New Data.OracleClient.OracleCommand(MyString1)
cn1.Open()
DataGrid1.DataSource = cmd1.ExecuteReader()
DataGrid1.DataBind()
Label2.Text = "ok"
系统提示:The connection is closed!
请问这是为什么啊?感谢感谢!!!
应该为:Dim cmd1 As Data.OracleClient.OracleCommand = New Data.OracleClient.OracleCommand(MyString1,cnl)