Ejemplo n.º 1
0
        private void dgSearchItem_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            try
            {
                string str = dgSearchItem.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();

                Admin Bind = new Admin();
                ArrayList data_contract = Bind.BindAllItemDetails(str);

                if (data_contract.Count == 0)
                {
                    MessageBox.Show("NO DATA MATCH WITH DATABASE RECORDS", "NO DATA FOUND", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
                else
                {
                    for (int i = 0; i < data_contract.Count; i = i + 5)
                    {
                        string ItemNumber = (string)data_contract[i];
                        string ItemName = (string)data_contract[i + 1];
                        string ItemDescription = (string)data_contract[i + 2];
                        string ItemCategory = (string)data_contract[i + 3];
                        Int64 ItemStock = (Int64)data_contract[i + 4];

                        tbSearchItemNumber.Text = ItemNumber;
                        tbSearchItemName.Text = ItemName;
                        tbSearchItemDescription.Text = ItemDescription;
                        tbSearchItemCategory.Text = ItemCategory;
                        tbSearchItemStock.Text = ItemStock.ToString();
                    }
                }
            }
            catch (SqlException)
            {
                MessageBox.Show("MICROSOFT SQL SERVER DATABASE ERROR!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            catch (InvalidOperationException)
            {
                MessageBox.Show("INVALID OPERATION!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString(), "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }