public void setgrid() { int a; string s = DHome.dd.Rows[0]["Id"].ToString(); bool result = Int32.TryParse(s, out a); string st = "select Pname , Padd , Hospital from Requests where Id = " + a + ";"; doct = db.Data(st); if (doct.Rows.Count > 0) { dataGridViewdoc.DataSource = doct; DataGridViewDisableButtonColumn btn = new DataGridViewDisableButtonColumn(); btn.HeaderText = " "; btn.Name = "yesbtn"; btn.Text = "Accept"; btn.UseColumnTextForButtonValue = true; dataGridViewdoc.Columns.Add(btn); } else { dataGridViewdoc.DataSource = doct; DataGridViewDisableButtonColumn btn = new DataGridViewDisableButtonColumn(); btn.HeaderText = " "; btn.Name = "yesbtn"; btn.Text = "Accept"; btn.UseColumnTextForButtonValue = true; dataGridViewdoc.Columns.Add(btn); } }
private void dataGridView2_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 6) { //MessageBox.Show(c.ToString()); if (c == 'd') { int a; //string s = dataGridView2.Rows[e.RowIndex].Cells["Id"].ToString(); string s = dt.Rows[e.RowIndex]["Id"].ToString(); bool result = Int32.TryParse(s, out a); string st = "Delete from Doctor where Id=" + a + ";"; da.Execute(st); dataGridView2.DataSource = null; dataGridView2.Rows.Clear(); dataGridView2.Columns.Clear(); dt.Clear(); string query = "select * from Doctor"; da.readDatathroughAdapter(query, dt); dataGridView2.DataSource = dt; DataGridViewDisableButtonColumn btn = new DataGridViewDisableButtonColumn(); btn.HeaderText = ""; btn.Name = "yesbtn"; btn.Text = "Delete"; btn.UseColumnTextForButtonValue = true; dataGridView2.Columns.Add(btn); da.closeConn(); } else if (c == 'p') { int a; string s = dt.Rows[e.RowIndex]["Id"].ToString(); bool result = Int32.TryParse(s, out a); string st = "Delete from Patient where Id=" + a + ";"; da.Execute(st); dataGridView2.DataSource = null; dataGridView2.Rows.Clear(); dataGridView2.Columns.Clear(); dt.Clear(); string query = "select * from Patient"; da.readDatathroughAdapter(query, dt); dataGridView2.DataSource = dt; DataGridViewDisableButtonColumn btn = new DataGridViewDisableButtonColumn(); btn.HeaderText = ""; btn.Name = "yesbtn"; btn.Text = "Delete"; btn.UseColumnTextForButtonValue = true; dataGridView2.Columns.Add(btn); da.closeConn(); } } }
private void searchbtn_Click(object sender, EventArgs e) { string hos = null, spe = null; hos = searchhospital.Text; spe = searchspecial.Text; if (hos == "" || spe == "") { MessageBox.Show("Invalid request!!"); } else { hos = hos.Replace(' ', '_'); string st = "Select * from " + hos + " where Specialist like '%" + spe + "%'"; dt = db.Data(st); this.dataGridView1.DataSource = null; this.dataGridView1.Rows.Clear(); this.dataGridView1.Columns.Clear(); this.dataGridView1.Refresh(); if (dt.Rows.Count > 0) { dataGridView1.DataSource = dt; DataGridViewDisableButtonColumn btn = new DataGridViewDisableButtonColumn(); btn.HeaderText = ""; btn.Name = "yesbtn"; btn.Text = "Request"; btn.UseColumnTextForButtonValue = true; dataGridView1.Columns.Add(btn); hos = hos.Replace('_', ' '); st = "Select * from Requests where Pname = '" + PHome.ds.Rows[0]["Name"].ToString() + "' and Hospital = '" + hos + "';"; dr = db.Data(st); for (int i = 0; i < dr.Rows.Count; i++) { for (int j = 0; j < dataGridView1.Rows.Count; j++) { if (dr.Rows[i]["Dname"].ToString() == dataGridView1.Rows[j].Cells["Name"].Value.ToString()) { ((DataGridViewDisableButtonCell)dataGridView1.Rows[j].Cells[5]).Enabled = false; } } } dataGridView1.Refresh(); } else { MessageBox.Show("No Results found!!"); } } }
private void btnPatient_Click(object sender, EventArgs e) { c = 'p'; dataGridView2.DataSource = null; dataGridView2.Rows.Clear(); dataGridView2.Columns.Clear(); dt.Clear(); dataGridView2.Refresh(); string query = "select * from Patient"; da.readDatathroughAdapter(query, dt); dataGridView2.DataSource = dt; DataGridViewDisableButtonColumn btn = new DataGridViewDisableButtonColumn(); btn.HeaderText = ""; btn.Name = "yesbtn"; btn.Text = "Delete"; btn.UseColumnTextForButtonValue = true; dataGridView2.Columns.Add(btn); da.closeConn(); }