not all variables bound

[kebele]

I am trying to bound my sql statement to with this SqlDataSource1.SelectCommand and i am getting an error message.I am also passing one parameter to this sql statement using the below code. your help is really appreciated.


ORA-01008: not all variables bound

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OracleClient.OracleException: ORA-01008: not all variables bound


Sub VendorSearch()

Dim Sql As String = " select * from vendor where vnamel like :VendorName"
Dim myCommand3 As OracleCommand = New OracleCommand(Sql, New OracleConnection(GetConnectionString()))

myCommand3.Parameters.AddWithValue(":VendorName", "%" & txtVendorName.Text & "%")
Dim myAdapter3 As New OracleDataAdapter(myCommand3)

Response.Write("Sql " & "<br/>" & Sql & "<hr/>")
SqlDataSource1.SelectCommand = Sql

End Sub

 

[PGoRule]

Try with the following...

myCommand3.Parameters.Add("@VendorName", [i]oracle datatype[/i]).Value =  "%" & txtVendorName.Text & "%"

Sharing the best from my side...

--Prashant--

 

[kebele]

Thanks prashant for the tip.since i am using sqldatasource i had to add the paramter like what i did below.one more question though, how can i make sure the value that entered by the user is always upper case since the info. that i need to pull is upper case in the database. Is it possible to surround the

Dim Sql As String = " select * from vendor where vnamel like UCASEVendorName)" I am not sure if this is right.

thanks for the help i get from you guys. It really mean a lot to me.



<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" >
<SelectParameters>
<asp:ControlParameter ControlID="txtVendorName" Name="VendorName" PropertyName="Text" Type="String" />
</SelectParameters>
</asp:SqlDataSource>


Sub VendorSearch()

Dim Sql As String = " select * from vendor where vnamel like :VendorName"
SqlDataSource1.SelectCommand = Sql

End Sub

 

[PGoRule]

You can use the functions with SQL query. Try using this way...in SQL server

select * from table_name where table_column = upper('xyz')

Sharing the best from my side...

--Prashant--