C# การสสร้างฐานข้อมูลลูกค้าด้วย DataGridView แบบ บ้านๆ

private void tblContact_CompanyslistDataGridView_CellEndEdit(object sender, DataGridViewCellEventArgs e)
        {

            if (tblContact_CompanyslistDataGridView[1, e.RowIndex].Value.toString() == "")
            {
                tblContact_CompanyslistDataGridView[1, e.RowIndex].Value = (e.RowIndex == 0) ? "CUS0001" :
               (Convert.ToInt32(tblContact_CompanyslistDataGridView[1, e.RowIndex-1].Value.toString().Replace("CUS", ""))+1).ToString("CUS0000");
            }
        }

 #region _SaveDATA
        private void SaveContactlist_Click(object sender, EventArgs e)
        {
            this.Validate();
            this.tblContact_CompanyslistBindingSource.EndEdit();
            this.tableAdapterManager.UpdateAll(this.dATADataSet);
            this.tblContact_CompanyslistTableAdapter.Fill(this.dATADataSet.tblContact_Companyslist);
        }
        private void SaveContactAddress_Click(object sender, EventArgs e)
        {
            this.Validate();
            this.tblContact_AddressBindingSource.EndEdit();
            this.tableAdapterManager.UpdateAll(this.dATADataSet);
            this.tblContact_AddressTableAdapter.Fill(this.dATADataSet.tblContact_Address);
        }
        private void SaveContactConttype_Click(object sender, EventArgs e)
        {
            this.Validate();
            this.tblContact_ConttypeBindingSource.EndEdit();
            this.tableAdapterManager.UpdateAll(this.dATADataSet);
            this.tblContact_ConttypeTableAdapter.Fill(this.dATADataSet.tblContact_Conttype);
        }
        private void SaveContactFileRef_Click(object sender, EventArgs e)
        {
            this.Validate();
            this.tblContact_FileRefBindingSource.EndEdit();
            this.tableAdapterManager.UpdateAll(this.dATADataSet);
            this.tblContact_FileRefTableAdapter.Fill(this.dATADataSet.tblContact_FileRef);
        }
        private void SaveContactContacs_Click(object sender, EventArgs e)
        {
            this.Validate();
            this.tblContact_ContacsBindingSource.EndEdit();
            this.tableAdapterManager.UpdateAll(this.dATADataSet);
            this.tblContact_ContacsTableAdapter.Fill(this.dATADataSet.tblContact_Contacs);
        }
        #endregion

private void cusIDTextBox_TextChanged(object sender, EventArgs e)
        {
            tblContact_AddressBindingSource.Filter = "CusID = " + cusIDTextBox.Text;
            tblContact_ConttypeBindingSource.Filter = "CusID = " + cusIDTextBox.Text;
            tblContact_ConttypeBindingSource.Filter = "CusID = " + cusIDTextBox.Text;
            tblContact_FileRefBindingSource.Filter = "CusID = " + cusIDTextBox.Text;
            tblContact_ContacsBindingSource.Filter = "CusID = " + cusIDTextBox.Text;
        }

private void tblContact_AddressDataGridView_CellEndEdit(object sender, DataGridViewCellEventArgs e)
        {
            SetCusID(tblContact_AddressDataGridView, e);
        }
        private void tblContact_ContacsDataGridView_CellEndEdit(object sender, DataGridViewCellEventArgs e)
        {
            SetCusID(tblContact_ContacsDataGridView, e);
        }
        private void tblContact_ConttypeDataGridView_CellEndEdit(object sender, DataGridViewCellEventArgs e)
        {
            SetCusID(tblContact_ConttypeDataGridView, e);
        }
        private void tblContact_FileRefDataGridView_CellEndEdit(object sender, DataGridViewCellEventArgs e)
        {
            SetCusID(tblContact_FileRefDataGridView, e);
        }
//ใช้ได้เฉพาะ กรณีที่ e.ColumnIndex เท่ากันนะครับถ้าไม่เท่ากันก็ต้องเขียนแยกใน method นั้นๆนะครับ
//อย่างในตัวอย่าง e.ColumnIndex = 1 ครับ
        void SetCusID(DataGridView dgv, DataGridViewCellEventArgs e)
        {
            if (dgv[1, e.RowIndex].Value.toString() == "")
            {
                dgv[1, e.RowIndex].Value = cusIDTextBox.Text;
            }
        }