//this is for updating private void btnEdit_Click(object sender, EventArgs e) { try { if (dgvState.RowCount != 0) { StateDialog dlgState = new StateDialog(); dlgState.CountryName = (dgvState.SelectedRows[0].Cells[2].Value).ToString(); dlgState.stateName = (dgvState.SelectedRows[0].Cells[3].Value).ToString(); dlgState.IsActive = (bool)(dgvState.SelectedRows[0].Cells[4].Value); int stateId = (int)(dgvState.SelectedRows[0].Cells[0].Value); StateBO objStateBO = new StateBO(); StateData objStateData = new StateData(); if (dlgState.ShowDialog() == DialogResult.OK) { objStateData.StateId = stateId; objStateData.FKCountryId = dlgState.countryId; objStateData.StateName = dlgState.stateName; objStateData.IsActive = dlgState.IsActive; objStateBO.UpdateInState(objStateData); } } } catch { MessageBox.Show("error at edit form"); } dgvState.DataSource = StateBO.GetStates(); }
//filling the combe box in the form public void FillInCombo() { cmbStateName.DisplayMember = "StateName"; cmbUserName.DisplayMember = "UserName"; cmbStateName.ValueMember = "PKStateId"; cmbUserName.ValueMember = "PKUserId"; cmbUserName.DataSource = UserBO.GetUser(); cmbStateName.DataSource = StateBO.GetStates(); }
private void StateForm_Load(object sender, EventArgs e) { dgvState.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dgvState.AutoGenerateColumns = false; dgvState.ReadOnly = true; dgvState.AllowUserToAddRows = false; dgvState.AllowUserToDeleteRows = false; dgvState.AllowUserToOrderColumns = false; dgvState.MultiSelect = false; dgvState.DataSource = StateBO.GetStates(); }
private void btnAdd_Click(object sender, EventArgs e) { try { StateDialog dlgState = new StateDialog(); if (dlgState.ShowDialog() == DialogResult.OK) { StateBO objstateBO = new StateBO(); objstateBO.InsertInState(dlgState.countryId, dlgState.stateName, dlgState.IsActive); dgvState.DataSource = StateBO.GetStates(); } } catch { MessageBox.Show("Error in state form"); } }
public void BindGridView() { try { DataSet ds; StateBO objStateBO = new StateBO(); ds = objStateBO.GetStates(-1); dgvState.DataSource = ds.Tables[0]; } catch (System.Data.SqlClient.SqlException) { MessageBox.Show("1.Check the Connection Connection string ", "Unable to connect database "); } catch (Exception) { MessageBox.Show("connection string is invalid"); } }
private void btnDelete_Click(object sender, EventArgs e) { if (dgvState.RowCount != 0) { DialogResult dr; dr = MessageBox.Show("Are you sure?", "Delete", MessageBoxButtons.YesNo); if (dr == DialogResult.No) { return; } else { int stateId = (int)(dgvState.SelectedRows[0].Cells[0].Value); StateBO objStateBO = new StateBO(); objStateBO.DeleteInState(stateId); } } dgvState.DataSource = StateBO.GetStates(); }
//AddressBookEntities context = new AddressBookEntities(); public object Getdetails(int a) { if (a == 1) { qry = null; qry = CountryBO.GetCountries(); } else if (a == 2) { qry = null; qry = StateBO.GetStates(); } else if (a == 3) { qry = null; qry = UserDB.GetUserDetails(); } //if (a == 4) //{ // qry = null; // qry = AddressBookDB.GetAddressbook(); //} return(qry); }
private void btnReset_Click(object sender, EventArgs e) { dgvState.DataSource = StateBO.GetStates(); }