multiply textbox value and sql table coloum
                            
                         
                        
                     
                 
                
                    sql table like below
sno   items        rate
1      chips         5
i want o/p like
i havetwo textboxes  
1st textbox if value 15 ..i wnat multiply texbox1 value  * rate in sql table
if textbox value =15
rate=5
textbox2 value =15*5=75
o/p
textbox2=75
plz write csharp code.....
i am using below quarie but its not working..............
 SqlConnection con = new SqlConnection("");
        SqlDataAdapter da;
        DataSet ds;
        da = new SqlDataAdapter("Select rate from verify ", con);
         ds = new DataSet();
        da.Fill(ds);
        decimal quantity1 = Convert.ToDecimal(ds.Tables[0].Rows[0]["Rate"].ToString());
        var a = Convert.ToDecimal(TextBox1.Text);
        TextBox2.Text = (quantity1 * a).ToString();