I am beginning at C#. I am trying to write an application that connects, searches our database via ADO.NET and bind the values to textbox controls.

Sample Program: Enter customer ID in textbox1, click search button, and display values in textboxes. Problem that I am having is creating the entry point textbox code. Here is the code I have so far.

private void button3_Click(object sender, EventArgs e)
        {


string select = "select * from customer where master_customer_id=" + textBox3.Text;
string source = @"Data Source=DB;database=TTST;User id=sa;Password=;";
SqlConnection conn = new SqlConnection(source);
conn.Open();
//Use SqlDataAdapter to fill rows to dataset
SqlDataAdapter da = new SqlDataAdapter(select, conn);
DataSet ds = new DataSet();
da.Fill(ds, "Customer");

//Binding Data to Textbox Control
textBox1.DataBindings.Add("Text", ds, "customer.first_name");
textBox2.DataBindings.Add("Text", ds, "customer.last_name");

        }

I get the following error when I try to run and Enter in textbox3 - 000000000001, Click search
error:
Arithmetic overflow error converting numeric to data type numeric

from the first look,
string select = "select * from customer where [u]master_customer_id=" + textBox3.Text</u>;
the place where u are using textbox3.text ; // first line of your submitted code.
it should be something like Convert.ToInt32(textbox3.text); // this is based on assumption that id (master_customer_id) is int or long (numeric rather than alpha numeric).

This worked out. Thank you for your help on this.

One more question, how or where can I implement the e.g. data adapter da, or dataset ds clear() command if I wanted to run search for another ID?

I didnt get your question ! Can u be more specific.
by the way i found this cool presentation on ADO .Net
have a look if this helps or reframe your question :)
http://www.bits-pilani.ac.in:12360/c.../Lecture19.ppt

Thanks.

Refer to topic: Text

For more clarification. I figured out a solution for it already.
I have all the books I need in front of me. I look to forums for other programmers expertise and techniques :)