private void LoadSubZone() { SubZoneBL objsubzone = new SubZoneBL() { ZoneID = Convert.ToInt32(txtZoneID.SelectedValue) }; var dt = objsubzone.SearchByZone(); if (dt != null) { txtSubZone.DataSource = dt; txtSubZone.DisplayMember = "SubRouteName"; txtSubZone.ValueMember = "SubROuteId"; } else { MessageBox.Show("No Record Found"); } }
private void LoadData() { SubZoneBL obJBl = new SubZoneBL(); var dt = obJBl.Select(); if (dt != null) { //DataGridViewImageColumn edit = new DataGridViewImageColumn(); //edit.Image = Properties.Resources.edit; //edit.ImageLayout = DataGridViewImageCellLayout.Zoom; //edit.HeaderText = "Edit"; //DataGridViewImageColumn delete = new DataGridViewImageColumn(); //delete.Image = Properties.Resources.delete; //delete.ImageLayout = DataGridViewImageCellLayout.Zoom; //delete.HeaderText = "Delete"; //edit.Width = delete.Width = 20; //dgvSubZone.Columns.Add(edit); //dgvSubZone.Columns.Add(delete); dgvSubZone.DataSource = dt; dgvSubZone.Columns["ZoneID"].Visible = false; dgvSubZone.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; } }
private void btnSave_Click(object sender, EventArgs e) { try { if (FormValidate() == true) { SubZoneBL objBl = new SubZoneBL() { ZoneID = Convert.ToInt32(txtZone.SelectedValue), SubRouteName = txtSubZoneName.Text }; objBl.Save(); MessageBox.Show("Record Saved Successfull"); ClearGroup(); formDisable(); btnAddnew.Enabled = true; } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
//private void btnSearch_Click(object sender, EventArgs e) //{ // if(!string.IsNullOrEmpty(txtSearch.Text)) // { // SubZoneBL objBl = new SubZoneBL() // { // SubRouteName = txtSearch.Text // }; // var dt = objBl.SearchByName(); // if(dt!= null) // { // } // } //} private void txtSearch_TextChanged(object sender, EventArgs e) { if (txtSearch.Text == string.Empty) { LoadData(); } else { SubZoneBL objTest = new SubZoneBL() { SubRouteName = txtSearch.Text.ToLower() }; var dt = objTest.SearchByName(); AutoCompleteStringCollection coll = new AutoCompleteStringCollection(); txtSearch.AutoCompleteMode = AutoCompleteMode.Suggest; txtSearch.AutoCompleteSource = AutoCompleteSource.CustomSource; txtSearch.AutoCompleteCustomSource = coll; if (dt.Count > 0) { dgvSubZone.DataSource = dt; } } }