Set a field value

Question

MJV

9 Years Ago

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.

3 Contributors
3 Replies
4 Views
9 Years Discussion Span
Latest Post 9 Years Ago by JerryShaw

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