private void ExportParentChildInfo() { SMSSyncBAL bal = new SMSSyncBAL(); try { bal.Connect_SBP(); bal.Connect_SMS(); bal.TruncateTable_SMSSyncExport_AccountGrouping_Info_UITransApplied(); SqlDataReader dr_AccountGrouping = bal.GetIPO_AccountGrouping_Info_UITransApplied(); bal.InsertTable_SMSSyncExport_AccountGrouping_Info_UITransApplied(dr_AccountGrouping); bal.Commit_SBP(); bal.Commit_SMS(); } catch (Exception ex) { bal.Rollback_SBP(); bal.Rollback_SMS(); } finally { bal.CloseConnection_SBP(); bal.CloseConnection_SMS(); } }
private void button7_Click(object sender, EventArgs e) { try { SMSSyncBAL bal = new SMSSyncBAL(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }