开发者

How can I pass multiple values from same column in a query?

How can I pass multiple values from same column in a query? I am using vb.net and sql server 开发者_开发问答database.

With my query an exception is generated saying that @booking_date has already been declared try a different variable....

My query is:

Dim da As New SqlDataAdapter("select * from Bookings where booking_date Between (@booking_date AND @booking_date) AND booking_time Between (@booking_time AND @bookinbg_time) AND game = " & x, con)


Do you need the parentheses around the variables?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜