How to use a string that stores integer values (result of a SQL query)?

Question

I am using C# and SQL Server.

I have to retrieve the prices of particular products from a table and make use of these values later for computation.

For eg.

I use the following query and store it in a string.

string str = " select cat_price from category where cat_itemID= 'A001'" ;

Now I need this particular value retrieved here to be stored in a variable for further computation

for eg.

int price_amount;

and I need to use mathematical operations. How do I do this?

Are you asking how to retrieve data from a DB? Or is this a type casting problem(i.e. converting from a string to an int)? — Mark Hosang
– Mark Hosang, Commented Apr 22, 2011 at 3:19
You need to perform math operations on the price within the query ? — V4Vendetta
– V4Vendetta, Commented Apr 22, 2011 at 3:24

Josh M. · Accepted Answer · 2011-04-22 03:20:08Z

3

Use the ExecuteScalar method of a SqlCommand to get the first value:

using (SqlConnection cn = new SqlConnection(...))
{
    using (SqlCommand cmd = new SqlCommand(cn, "select cat_price from category where cat_itemID= 'A001'"))
    {
        //Execute the query and just get the first result.
        int value = (int)cmd.ExecuteScalar();
    }
}

answered Apr 22, 2011 at 3:20

Josh M.

28.1k27 gold badges135 silver badges223 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nick_kill Over a year ago

Thank you for your input.I was able to solve the problem by parsing the string. decimal num = decimal.Parse(str);

Mark Hosang · Accepted Answer · 2011-04-22 03:22:37Z

0

You can use SQLDbConnection and ExecuteScaler to get get this out of the DB if that is your question. Below is a link to do this.

http://www.codeproject.com/KB/database/sql_in_csharp.aspx

answered Apr 22, 2011 at 3:22

Mark Hosang

5015 silver badges21 bronze badges

Collectives™ on Stack Overflow

How to use a string that stores integer values (result of a SQL query)?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related