Oracle parameter problem - type string

[Guest]

I created a new Web application and added the following code which returns
records:
-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click

Dim OracleSelectCommand1 As System.Data.OracleClient.OracleCommand
Dim OracleConnection1 As System.Data.OracleClient.OracleConnection
Dim OracleDataAdapter1 As System.Data.OracleClient.OracleDataAdapter
Dim dt As New Data.DataTable("DenseReport")

OracleSelectCommand1 = New System.Data.OracleClient.OracleCommand
OracleConnection1 = New System.Data.OracleClient.OracleConnection
OracleDataAdapter1 = New System.Data.OracleClient.OracleDataAdapter

OracleSelectCommand1.CommandText = "SELECT DRE_YEAR FROM DENSEREPORT
WHERE DRE_YEAR = '2001'"

OracleConnection1.ConnectionString = "user id=remv2;data
source=remv2;password=sievert2"
OracleSelectCommand1.Connection = OracleConnection1
OracleDataAdapter1.SelectCommand = OracleSelectCommand1
OracleDataAdapter1.Fill(dt)
Label1.Text = dt.Rows.Count.ToString
End Sub
-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/
The following code returns no records:
-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click

Dim OracleSelectCommand1 As System.Data.OracleClient.OracleCommand
Dim OracleConnection1 As System.Data.OracleClient.OracleConnection
Dim OracleDataAdapter1 As System.Data.OracleClient.OracleDataAdapter
Dim dt As New Data.DataTable("DenseReport")

OracleSelectCommand1 = New System.Data.OracleClient.OracleCommand
OracleConnection1 = New System.Data.OracleClient.OracleConnection
OracleDataAdapter1 = New System.Data.OracleClient.OracleDataAdapter

OracleSelectCommand1.CommandText = "SELECT DRE_YEAR FROM DENSEREPORT
WHERE DRE_YEAR = Year"
OracleSelectCommand1.Parameters.Add(New
System.Data.OracleClient.OracleParameter("pYear", "2001"))

OracleConnection1.ConnectionString = "user id=remv2;data
source=remv2;password=sievert2"
OracleSelectCommand1.Connection = OracleConnection1
OracleDataAdapter1.SelectCommand = OracleSelectCommand1
OracleDataAdapter1.Fill(dt)
Label1.Text = dt.Rows.Count.ToString
End Sub
-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/
Adding a : character before pYear in the OracleSelectCommand1.Parameters.Add
call doesn't change anything.


Does anyone know why? Any help would be much appreciated.

Brian

 

[Guest]

See answer in microsoft.public.dotnet.framework.


---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************