Exemplo n.º 1
0
 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();
 }
Exemplo n.º 2
0
        private string GetConnectionDetail()
        {
            string conn;

            using (MyOledbHandler handeler = new MyOledbHandler())
            {
                conn = handeler.GetConnection();
            }
            return(conn);
        }
Exemplo n.º 3
0
 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();
 }