public void getMedicalShopID() { BLMedicalShop objMedicalShopDetails = new BLMedicalShop(); DataTable dt = objMedicalShopDetails.getMedicalShopID(); for (int i = 0; i < dt.Rows.Count; i++) { for (int j = 0; j < dt.Columns.Count; j++) { if (string.IsNullOrEmpty(dt.Rows[i][j].ToString())) { //int a = 1; //txttransationId.Text = Convert.ToString(a); } else { //txttransationId.Text = dt.Rows[0][0].ToString(); } } } }
private void Usp_BindMedicalShopGrid() { try { DataTable dt = new DataTable(); BLMedicalShop objBL = new BLMedicalShop(); dt = objBL.BindFullGrid(); if (dt.Rows.Count > 0) { dgvMedicalShop.DataSource = dt; } else { dgvMedicalShop.DataSource = null; } dgvMedicalShop.Refresh(); dgvMedicalShop.Show(); { dgvMedicalShop.DataSource = dt; dgvMedicalShop.Columns[0].HeaderCell.Value = "Medical Name"; //dgvMedicalShop.Columns[1].HeaderCell.Value = "Contact Number"; dgvMedicalShop.Columns[1].HeaderCell.Value = "Country Name"; dgvMedicalShop.Columns[2].HeaderCell.Value = "State Name"; dgvMedicalShop.Columns[3].HeaderCell.Value = "City Name"; dgvMedicalShop.Columns[4].HeaderCell.Value = "Area"; dgvMedicalShop.Columns[5].HeaderCell.Value = "Address"; dgvMedicalShop.Columns[6].HeaderCell.Value = "Owner Name"; dgvMedicalShop.Columns[7].HeaderCell.Value = "Contact Number"; dgvMedicalShop.Columns[8].HeaderCell.Value = "Shop Type"; dgvMedicalShop.Columns[9].HeaderCell.Value = "IsActive"; dgvMedicalShop.Columns[9].Visible = false; dgvMedicalShop.Columns[10].HeaderCell.Value = "IsDelete"; dgvMedicalShop.Columns[10].Visible = false; dgvMedicalShop.AllowUserToAddRows = false; dgvMedicalShop.AllowUserToDeleteRows = false; dgvMedicalShop.Refresh(); dgvMedicalShop.Show(); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
private void dgvMedicalShop_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (dgvMedicalShop.SelectedRows.Count > 0) { txtMedicalName.Text = Convert.ToString(dgvMedicalShop.SelectedRows[0].Cells[0].Value); string ShopName = txtMedicalName.Text; BLMedicalShop objMedicalShop = new BLMedicalShop(); DataTable dt = objMedicalShop.GetID(ShopName); if (dt.Rows.Count != 0) { lblMedicalShopid.Text = dt.Rows[0]["MedicalShopID"].ToString(); } // lblMedicalShopid.Text = dgvMedicalShop.SelectedRows[0].Cells["MedicalShopID"].Value.ToString(); txtMedicalName.Text = Convert.ToString(dgvMedicalShop.SelectedRows[0].Cells[0].Value); cbCountry.Text = Convert.ToString(dgvMedicalShop.SelectedRows[0].Cells[1].Value); cbState.Text = Convert.ToString(dgvMedicalShop.SelectedRows[0].Cells[2].Value); cbCity.Text = Convert.ToString(dgvMedicalShop.SelectedRows[0].Cells[3].Value); txtArea.Text = Convert.ToString(dgvMedicalShop.SelectedRows[0].Cells[4].Value); txtAddress.Text = Convert.ToString(dgvMedicalShop.SelectedRows[0].Cells[5].Value); txtOwnerName.Text = Convert.ToString(dgvMedicalShop.SelectedRows[0].Cells[6].Value); txtSellerContactNo.Text = Convert.ToString(dgvMedicalShop.SelectedRows[0].Cells[7].Value); cbShopType.Text = Convert.ToString(dgvMedicalShop.SelectedRows[0].Cells[8].Value); //dgvMedicalShop.Columns["MedicalShopID"].Visible = false; string Active= Convert.ToString(dgvMedicalShop.SelectedRows[0].Cells[9].Value); txtOpningBalance.Text=Convert.ToString(dgvMedicalShop.SelectedRows[0].Cells[11].Value); txtOpningBalance.ReadOnly = true; if (Active == "Yes") { cbActive.Checked = true; } else { cbActive.Checked = false; } btnsave.Text = "Update"; } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }