void item_itemChanged(Description item) { item.AddToPrintList = false; if (item.SearchCode != "") { using (MyOledbHandler connection = new MyOledbHandler()) { try { discriptionInstence = connection.getDiscription(item.SearchCode); } catch (Exception ex) { MessageBox.Show(this, ex.Message, @"Connection Error.", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } list.Clear(); for (int i = 0; i < discriptionInstence.Rows.Count; i++) { list.Add(new Description(discriptionInstence.Rows[i][0].ToString(), discriptionInstence.Rows[i][1].ToString(), discriptionInstence.Rows[i][2].ToString()) { Currency = discriptionInstence.Rows[i][3].ToString(), Price = Decimal.Parse(discriptionInstence.Rows[i][4].ToString()) }); } this.discriptionListBox.DataSource = null; this.discriptionListBox.DataSource = list; discriptionListBox.Show(); }
private string GetConnectionDetail() { string conn; using (MyOledbHandler handeler = new MyOledbHandler()) { conn = handeler.GetConnection(); } return(conn); }
void item_itemChanged(Discription item) { item.AddToPrintList = false; if (item.SearchCode != "") { using (MyOledbHandler connection = new MyOledbHandler()) { discriptionInstence = connection.getDiscriptionLocal(item.SearchCode); } } list.Clear(); for (int i = 0; i < discriptionInstence.Rows.Count; i++) { list.Add(new Discription(discriptionInstence.Rows[i][0].ToString(), discriptionInstence.Rows[i][1].ToString(), discriptionInstence.Rows[i][2].ToString())); } this.discriptionListBox.DataSource = null; this.discriptionListBox.DataSource = list; discriptionListBox.Show(); }