select * from tblEmp
where convert(datetime,convert(varchar(10),a.DueDate +
i want to get the values of
to execute this query and bind data in a grid..how can i do this.
please provide me code by example..
thank you
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jaish MathewsPosted Mar 30, 2010, 9:27 AM
"select * from tblEmp
where convert(datetime,convert(varchar(10),a.DueDate + " + Int.Parse(Textbox1.Text) + ",101)) <= convert(datetime,convert(varchar(10),getdate(),101))"