GenericEditingControlShowing

Edit Text box for datagridview

private void GenericEditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)

        {

            int colIndex;

            int rowIndex;

            var txtBox = e.Control as TextBox;

            colIndex = tbl_ssi_GLTransactionDataGridView.CurrentCell.ColumnIndex;

            rowIndex = tbl_ssi_GLTransactionDataGridView.CurrentCell.RowIndex;

            if (e.Control is TextBox)

            {

                if (txtBox != null)

                {

                    DataClasses1DataContext dc = new DataClasses1DataContext(glo.ConnectionString);

                    txtBox.CharacterCasing = CharacterCasing.Upper;

                    txtBox.TextChanged += new EventHandler(ItemTxtBox_TextChanged);

                    txtBox.MaxLength = aMaxFieldLength[colIndex];

                    switch (colIndex)

                    {

                        case pCOL_BRANCHNUMBER:

                            txtBox.AutoCompleteSource = AutoCompleteSource.CustomSource;

                            txtBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend;

                            var qry = dc.tbl_employee_cost_ctrs.Select(r => new { r.Cost_Center });

                            foreach (var rc in qry)

                                txtBox.AutoCompleteCustomSource.Add(rc.Cost_Center.ToString());

                            break;

                        case pCOL_GL_ACCOUNTNUMBER:

                            txtBox.AutoCompleteSource = AutoCompleteSource.CustomSource;

                            txtBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend;

                            var qryACCT = dc.tbl_ssi_MVFees.Select(r => new { r.GL_AccountNumber  });

                            foreach (var rc in qryACCT)

                                txtBox.AutoCompleteCustomSource.Add(rc.GL_AccountNumber.ToString());

                            break;

                        default:

                            break;

                    }

                }

            }

        }