Hello weird0,
"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo
wWhat I did is create a Dataset and then the option "To select
wmultiple columns was grey"
wso forcefully I had to "To select the one that returns a single
wvalue".
wI wrote the query for it which is as follows:
w>
wSELECT atm_amount,atm_branch,atm_date,balance FROM ATM_Transactions
wWHERE user_id=Session["UserId"]
w>
wThe error it gives is:
w>
wIncorrect syntax near "UserId".
What is the "Session["UserId"]" ?!
Maybe u need to use @USERID instead of this
and then using connection.Parameters.AddWithValue(@USERID, Session["UserId"])
?
---
WBR, Michael Nemtsev [C# MVP].
My blog:
http://spaces.live.com/laflour
Team blog:
http://devkids.blogspot.com/