コード例 #1
0
ファイル: Doctor.cs プロジェクト: Anshul0305/lotas
        private void Usp_BindDoctorGrid()
        {
            try
            {
                DataTable dt = new DataTable();
                BLDoctor objBL = new BLDoctor();
                dt = objBL.BindFullGrid();
                if (dt.Rows.Count > 0)
                {
                    dgvDoctor.DataSource = dt;
                }
                else
                {
                    dgvDoctor.DataSource = null;
                }
                dgvDoctor.Refresh();
                dgvDoctor.Show();
                {
                    dgvDoctor.DataSource = dt;
                    dgvDoctor.Columns[0].HeaderCell.Value = "Dr. Name";
                    dgvDoctor.Columns[1].HeaderCell.Value = "DOB";
                    dgvDoctor.Columns[2].HeaderCell.Value = "Country";
                    dgvDoctor.Columns[3].HeaderCell.Value = "State";
                    dgvDoctor.Columns[4].HeaderCell.Value = "City";
                    dgvDoctor.Columns[5].HeaderCell.Value = "Area";
                    dgvDoctor.Columns[6].HeaderCell.Value = "Address";
                    dgvDoctor.Columns[7].HeaderCell.Value = "Specialization";
                    dgvDoctor.Columns[8].HeaderCell.Value = "Mobile Number";
                    dgvDoctor.Columns[9].HeaderCell.Value = "IsActive";
                    dgvDoctor.Columns[9].Visible = false;
                    dgvDoctor.Columns[10].HeaderCell.Value = "IsDelete";
                    dgvDoctor.Columns[10].Visible = false;
                    dgvDoctor.Columns[11].HeaderCell.Value = "DoctorID";
                    dgvDoctor.Columns[11].Visible = false;
                    dgvDoctor.AllowUserToAddRows = false;
                    dgvDoctor.AllowUserToDeleteRows = false;
                    //dgvDoctor.Columns[12].HeaderCell.Value = "OpeningBalance";

                    dgvDoctor.Refresh();
                    dgvDoctor.Show();

                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());
            }
        }
コード例 #2
0
ファイル: Doctor.cs プロジェクト: Anshul0305/lotas
        private void dgvDoctor_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            try
            {
                if (dgvDoctor.SelectedRows.Count > 0)
                {
                    txtDrName.Text = Convert.ToString(dgvDoctor.SelectedRows[0].Cells[0].Value);
                    string DrName = txtDrName.Text;
                    BLDoctor objDoctor = new BLDoctor();
                    DataTable dt = objDoctor.GetID(DrName);
                    if (dt.Rows.Count != 0)
                    {
                        lblid.Text = dt.Rows[0]["DoctorID"].ToString();
                    }

                    lblhidden.Text = dgvDoctor.SelectedRows[0].Cells["DoctorID"].Value.ToString();
                    txtDrName.Text = Convert.ToString(dgvDoctor.SelectedRows[0].Cells["DrName"].Value);
                    dtpDOB.Text = Convert.ToString(dgvDoctor.SelectedRows[0].Cells["DOB"].Value);
                    cbcountry.Text = Convert.ToString(dgvDoctor.SelectedRows[0].Cells["CountryName"].Value);
                    cbstate.Text = Convert.ToString(dgvDoctor.SelectedRows[0].Cells["StateName"].Value);
                    cbcity.Text = Convert.ToString(dgvDoctor.SelectedRows[0].Cells["CityName"].Value);
                    txtArea.Text = Convert.ToString(dgvDoctor.SelectedRows[0].Cells["Area"].Value);
                    txtAddress.Text = Convert.ToString(dgvDoctor.SelectedRows[0].Cells["Address"].Value);
                    txtspecialization.Text = Convert.ToString(dgvDoctor.SelectedRows[0].Cells["Specialization"].Value);
                    //lbProductList.Text = Convert.ToString(dgvDoctor.SelectedRows[0].Cells["ProductList"].Value);
                    //txtAddress.Text = Convert.ToString(dgvDoctor.SelectedRows[0].Cells[8].Value);
                    dgvDoctor.Columns["DoctorID"].Visible = false;
                    txtmobileno.Text = Convert.ToString(dgvDoctor.SelectedRows[0].Cells["MobileNo"].Value);
                    //txtgifts.Text = Convert.ToString(dgvDoctor.SelectedRows[0].Cells[9].Value);
                    txtmobileno.Text = Convert.ToString(dgvDoctor.SelectedRows[0].Cells["MobileNo"].Value);
                    txtOpeningBal.Text = Convert.ToString(dgvDoctor.SelectedRows[0].Cells["OpeningBalance"].Value);
                    txtOpeningBal.ReadOnly = true;
                    string status = Convert.ToString(dgvDoctor.SelectedRows[0].Cells["IsActive"].Value);
                    if (status == "Yes")
                    {
                        cbActive.Checked = true;
                    }
                    btnsave.Text = "Update";
                    //lbProductList.Enabled = true;
                    BindProductList();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());
            }
        }