private void PopulateClientAddress() { StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions(); DataTable dt = ui.GetClientAddress(SelectedClientID.ToString()); // populate the address data if( dt.Rows.Count > 0 ) { txtAddress1.Text = dt.Rows[0]["address1"].ToString(); txtAddress2.Text = dt.Rows[0]["address2"].ToString(); txtCity.Text = dt.Rows[0]["CITY"].ToString(); txtZip.Text = dt.Rows[0]["zip"].ToString(); // set the state drop down list ddlClientState.SelectedValue = dt.Rows[0]["state_id"].ToString(); } else { txtAddress1.Text = ""; txtAddress2.Text = ""; txtCity.Text = ""; txtZip.Text = ""; // set the state drop down list ddlClientState.SelectedValue = "1"; } }