Set a field value

Question

0

Hi im new to C# and I have a form with customer data on it. There is a combo box with the customer name and some address fields. When I select the customer name I would like the address field to be automatically updated from the customer table. Can anyone help me with the code for this. Thanks in advance.

c#

3

Contributors

3

Replies

4

Views

8 Years

Discussion Span

8 Years Ago

Last Post by JerryShaw

This Question has been Answered

c#

LizR 171 · Answer 1 · 2009-02-10T21:13:27+00:00

thats normally why you bind the control to the table/query

MJV · Answer 2 · 2009-02-10T21:39:58+00:00

thats normally why you bind the control to the table/query

This form is used to fill out another table for quoting. The customer table is used as reference to fill out the customer portion of the quote form.

JerryShaw 46 · Answer 3 · 2009-02-11T20:41:05+00:00

As LizR said, binding is the best approach, however you can manually locate the Customer in the table and populate the address text box.

string custName = combobox.Text;
DataRow[] addressInfo = custData.Select(string.Format("Customer='{0}'",custName));
if(addressInfo.Length > 0)
{
    edStreet.Text = (string)addressInfo[0]["Street"];
    edCity.Text = (string)addressInfo[0]["City"];
    // and so on...
}

Hope this helps,
Jerry