Error converting data type varchar to float.
price_range = BulletedList3.Items[e.Index].Value; if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("select pro_img,pro_name,price from product where price= '" + price_range + "'and status='A' and type='retail' ", con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); DataList1.DataSource = ds; DataList1.DataBind(); con.Close();
SqlCommand cmd = new SqlCommand("select pro_img,pro_name,price from product where price= " + price_range.ToString() + " and status='A' and type='retail' ", con);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)