How to get a price from database in a variable?

See more:

ASP.NET

Can anyone know this.

This is my coding.

In this code in a database price is there which datatype is varchar and in this bulletedlist i have given the price but it gets only the string but i want that instead of string the value should be passed like 500.

protected void BulletedList3_Click(object sender, BulletedListEventArgs e)
    {
        price = BulletedList3.Items[e.Index].Value;
        if (con.State == ConnectionState.Closed)
        {
            con.Open();
        }
        switch (price)
        {
            case "Below Rs.500/-":
                SqlCommand cmd = new SqlCommand("select pro_img,pro_name,price from product where price='" + price + "' and status='A' and type='retail'", con);
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                da.Fill(ds);
                DataList1.DataSource = ds;
                DataList1.DataBind();
                 break;