private void btnSave_Click(object sender, EventArgs e) { try { POCS.Ds.POCSTableAdapters.VendorTableAdapter tAdapter = new POCS.Ds.POCSTableAdapters.VendorTableAdapter(); if (!IsEditMode) { if (IsValidEntry(this.Frame1)) { tAdapter.Insert(txtVendorFirmName.Text, txtVendorCnctPerson.Text, txtVendorAdd.Text, txtVendorPh.Text, txtVendorMob.Text, txtVendorZip.Text, txtVendorFax.Text, txtVendorEmail.Text, "1", txtVendorCity.Text, "-", txtVendorCountry.Text, TxtRegNo.Text, dtpRegDate.Value, txtVendorCode.Text, chkAVL.Checked, 45); } else { MessageBox.Show("Please Enter all Required Vendor Detail Entries", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } else { tAdapter.UpdateVendorDetails(txtVendorFirmName.Text, txtVendorCnctPerson.Text, txtVendorAdd.Text, txtVendorPh.Text, txtVendorMob.Text, txtVendorZip.Text, txtVendorFax.Text, txtVendorEmail.Text, "1", txtVendorCity.Text, "-", txtVendorCountry.Text, TxtRegNo.Text, dtpRegDate.Value, txtVendorCode.Text, chkAVL.Checked, 45, VendorID); vendorTableAdapter.Update(this.pOCS.Vendor); dgvVendors.Refresh(); MessageBox.Show("Vendor Information Updated Succesfully", Application.ProductName, MessageBoxButtons.OK); } } catch { } }
private void txtVendorId_TextChanged(object sender, EventArgs e) { POCS.Ds.POCSTableAdapters.VendorTableAdapter dAdapter = new POCS.Ds.POCSTableAdapters.VendorTableAdapter(); txtVendorFirmName.Text = dAdapter.GetDataByVendorID(Decimal.Parse(txtVendorId.Text)).v_nameColumn.Table.Columns[0].ToString(); }