public void FetchFromClient(Int32 _clientNum) { Whitfieldcore _wc = new Whitfieldcore(); IDataReader iReader = _wc.GetClientInfo(_clientNum); while (iReader.Read()) { txttele.Text = iReader["Phone"] == DBNull.Value ? "" : iReader["Phone"].ToString(); txtFax.Text = iReader["Fax"] == DBNull.Value ? "" : iReader["Fax"].ToString(); txtAddress.Text = iReader["Street"] == DBNull.Value ? "" : iReader["Street"].ToString(); String City = iReader["City"] == DBNull.Value ? "" : iReader["City"].ToString(); ddlCity.SelectedIndex = ddlCity.Items.IndexOf(ddlCity.Items.FindByValue(City.ToString())); String Statecd = iReader["State"] == DBNull.Value ? "" : iReader["State"].ToString(); ddlState.SelectedIndex = ddlState.Items.IndexOf(ddlState.Items.FindByValue(Statecd.ToString())); //txtzip.Text = iReader["Zip"] == DBNull.Value ? "" : iReader["Zip"].ToString(); } }
public void FetchAndBind(Int32 _clientNumber) { Whitfieldcore _wc = new Whitfieldcore(); IDataReader iReader = _wc.GetClientInfo(_clientNumber); // ' Loop through the DataReader and write out each entry while (iReader.Read()) { txtclientname.Text = iReader["Name"] == DBNull.Value ? "" : iReader["Name"].ToString(); String cType = iReader["ClientType"] == DBNull.Value ? "" : iReader["ClientType"].ToString(); ddlClientType.SelectedIndex = ddlClientType.Items.IndexOf(ddlClientType.Items.FindByValue(cType.ToString())); txtstreet.Text = iReader["Street"] == DBNull.Value ? "" : iReader["Street"].ToString(); String City = iReader["City"] == DBNull.Value ? "" : iReader["City"].ToString(); ddlCity.SelectedIndex = ddlCity.Items.IndexOf(ddlCity.Items.FindByValue(City.ToString())); String Statecd = iReader["State"] == DBNull.Value ? "" : iReader["State"].ToString(); ddlState.SelectedIndex = ddlState.Items.IndexOf(ddlState.Items.FindByValue(Statecd.ToString())); txtPhNumber.Text = iReader["Phone"] == DBNull.Value ? "" : iReader["Phone"].ToString(); txtFaxNumber.Text = iReader["Fax"] == DBNull.Value ? "" : iReader["Fax"].ToString(); txtFTP.Text = iReader["Web"] == DBNull.Value ? "" : iReader["Web"].ToString(); txtLogin.Text = iReader["login"] == DBNull.Value ? "" : iReader["login"].ToString(); txtPass.Text = iReader["pw"] == DBNull.Value ? "" : iReader["pw"].ToString(); txtWeb.Text = iReader["Web"] == DBNull.Value ? "" : iReader["Web"].ToString(); txtNotes.Text = iReader["Notes"] == DBNull.Value ? "" : iReader["Notes"].ToString(); } }