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

Filed under:
|
|
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

Related posts about sql-server

Related posts about c#