Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
get value from Sql Statement and store in a variable
peter piper
Aug 1 2015 11:51 AM
378
Reply
This is the Sql statement I am using behind a button in c# which
will populate a DataGridView
SqlDataAdapter = new SqlDataAdapter(@"SELECT detail.branch,
SUM(CONVERT(DECIMAL(8, 2), detail.total)) AS TOTAL,
SUM(CONVERT(DECIMAL(8, 2), detail.typeA)) AS SALES
FROM detail
I need to extract and store the value of TOTAL so I can use it in another
Sql Statement. Is this possible ?
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
C# Regular Expression to validate phone number
Print Notepad all page in c# 4.0