private void ComboSetNo_TextChanged(object sender, EventArgs e) { FormatBtnUpdate(ComboSetNo, TxtSettlementNo, ComboLocation, TxtTotalAmount, TxtReason); FormatBtnDelete(ComboSetNo); // // Loading data into form try { using (DBAuditDataContext dc = new DBAuditDataContext()) { if (ComboSetNo.Text != "") { string StrSetNo = null; int? IntLocID = null; string StrLocation = null; DateTime?VarSetDate = null; decimal? DecimalAmount = null; string StrDetails = null; string StrNotes = null; var c = dc.ProSelectSettlement(ComboSetNo.Text, ref StrSetNo, ref IntLocID, ref VarSetDate, ref DecimalAmount, ref StrDetails, ref StrNotes); TxtSettlementNo.Text = StrSetNo; var d = dc.ProGetLocationByID(IntLocID, ref StrLocation); ComboLocation.Text = StrLocation; if (VarSetDate != null) { DateSettlement.Value = VarSetDate.Value; } else { DateSettlement.Value = DateTime.Now; } TxtTotalAmount.Text = DecimalAmount.ToString(); TxtReason.Text = StrDetails; TxtNotes.Text = StrNotes; } else { TxtSettlementNo.Text = null; ComboLocation.Text = null; DateSettlement.Value = DateTime.Now; TxtTotalAmount.Text = null; TxtReason.Text = null; TxtNotes.Text = null; } } } catch (NullReferenceException) { } catch (InvalidOperationException) { DateSettlement.Value = DateTime.Now; BtnDelete.Enabled = false; } catch (Exception EX) { MessageBox.Show(EX.Message.ToString()); } }