Is there anyway that we can get a label value to a Sql
Posted
by Pradeep
on Stack Overflow
See other posts from Stack Overflow
or by Pradeep
Published on 2010-03-24T16:56:40Z
Indexed on
2010/03/25
0:13 UTC
Read the original article
Hit count: 113
SELECT COUNT(*) AS Expr1
FROM Book
INNER JOIN Temp_Order ON Book.Book_ID = Temp_Order.Book_ID
WHERE (Temp_Order.User_ID = 25)
AND (CONVERT (nvarchar, Temp_Order.OrderDate, 111) = CONVERT (nvarchar, GETDATE(), 111))
In here i want to change my User_ID to get from a label.Text
this Sql Statement is in a DataView. so in the Wizard it not accepting a text box values or anything.
can someone please help me to solve this
© Stack Overflow or respective owner