Convert a databse value

txtPrice.text=databasePriceValue;

Int intPrice=Convet.Toint32(txtPrice.text)

Use Cast or Convert to get the value in interger and then use

SELECT CAST(price AS INT) FROM Table
SELECT CONVERT(INT, price ) FROM Table

Hello friend,

for using a varchar value as integer there are many way to do that...

1) Using c# code

int price = Convert.ToInt32(price.toString());

or

int price = int.Parse(price.toString());

and it will be converted into Integer value

2) Using SQL Syntax

SELECT CAST(Price AS INT) FROM yourtablename
OR
SELECT CONVERT(INT,PRICE)FROM yourtablename

You will retrieve your data using SqlDataReader / SqlCommand Object then you will write your code as:

int price=0;
SqlCommand cmd=new SqlCommand("your query",'SqlConnection Object');
SqlDataReader dr = cmd.ExecuteReader();
if(dr.Read())
{
   price=Convert.ToInt32(dr[0].ToString());
}
dr.Close();

And you're done!
You have the integer 'price' ready to use in your code. Enjoy!

use keyword

Cast(column_name as data-type)

Ex.

Cast(price as int) as Price