this i my query and parameter list i got msg "Not All Variable bound"
Dim cmd As New OracleCommand("select POLICY_REFER, ....
from POLICY_MASTER
where ISSUE_DATE BETWEEN :DFrom AND :DTo
And (CLIENT_NAME = :client or :client is null)
and (POLICY_PRODUCT = :product or :product is null)
and DOC_STATUS = 'Parked'", sgcnn)
cmd.Parameters.Add("@DFrom", OracleDbType.Date).Value = DtpFrom.Value.ToShortDateString
cmd.Parameters.Add("@DTo", OracleDbType.Date).Value = DtpTo.Value.ToShortDateString
cmd.Parameters.Add("@Product", OracleDbType.Varchar2).Value = CmbProduct.Text
cmd.Parameters.Add("@Client", OracleDbType.Varchar2).Value = CmbClient.Text
if i used just client_name in query in parameter list then it work but when i used client_name and product i got msg "Not All Variable bound"
You SQL string has six parameters
Thus you must provide six parameters:
I don't know whether
@
is permitted/required for parameter name. Then you should removeToShortDateString
. Parameter is declared asOracleDbType.Date
, so just provide theDateTime
value, you don't have to consider any format topics - that's a major benefit of using bind parameters instead of putting the values as strings.