data type mismatch in criteria exception in C#
<p>i am making an application in which i insert a customer_Id with Double datatype in a Textbox1.</p>

<p>i use the customer_ID's value to access the database of respective customer_ID.
i had converted the value of Textbox1 into Double datatype using   </p>

<pre><code>double cust_ID;  
Cust_ID=Convert.ToDouble(Textbox1.Text);  
</code></pre>

<p>and the query is  </p>

<pre><code>string s="select * from Customer where Customer_ID='"+Cust_ID+"'";
</code></pre>

<p>But yet i am getting the data type mismatch in criteria exception error.</p>
