G
Guest
All,
I am using the Visual studio development tool, but I am having a problem
figuring out how to populate a parameter.
my commandtext is this:
cmdDeal.commandText = select * from tbl where deal_date = ?
on page load:
dtmDate = '08/15/05'
dim dealParam as new sqlParameter("@DealDate", dtmDate)
cmdDeal.Parameters.add(dealParam)
dealConnection.Open()
cmdDate.executeReader()
If I check what the commandtext is the sqlstatement has not changed from the
above statement.
Also when I execute the query (lets assume that it is right). Is there some
code that I need to put in before I executeReader..
thank
samantha
I am using the Visual studio development tool, but I am having a problem
figuring out how to populate a parameter.
my commandtext is this:
cmdDeal.commandText = select * from tbl where deal_date = ?
on page load:
dtmDate = '08/15/05'
dim dealParam as new sqlParameter("@DealDate", dtmDate)
cmdDeal.Parameters.add(dealParam)
dealConnection.Open()
cmdDate.executeReader()
If I check what the commandtext is the sqlstatement has not changed from the
above statement.
Also when I execute the query (lets assume that it is right). Is there some
code that I need to put in before I executeReader..
thank
samantha