private void Searchbtn_Click(object sender, EventArgs e) { string tid = Convert.ToString(SearchBox.SelectedValue); // int tid = (SearchBox.SelectedValue); if (SearchBox.SelectedIndex != -1) { MessageBox.Show("" + SearchBox.SelectedValue); dataGridView.Show(); view1databtn.Show(); viewallbtn.Show(); SearchBox.Hide(); Searchbtn.Hide(); if (conn.State.ToString() == "Closed") { conn = DB_Connection.GetConnection(); conn.Open(); } string query = "Select * from Topic Where TopicID=" + tid; SqlDataAdapter sqlda = new SqlDataAdapter(query, conn); DataTable dt = new DataTable(); sqlda.Fill(dt); dataGridView.DataSource = dt; } else { MessageBox.Show("No Select"); } }
private void view1databtn_Click(object sender, EventArgs e) { dataGridView.Hide(); viewallbtn.Hide(); view1databtn.Hide(); Searchbtn.Show(); SearchBox.Show(); }
// Search a Property internal void SearchProperty() { //Click on Owners tab Owners.Click(); //Click Properties option Properties.Click(); Thread.Sleep(1000); Searchbox.SendKeys("Rumana"); Searchbtn.Click(); }
private AdvertisementPage Search() { Wait.MLSeconds(500); Wait.UntilClickAble(Searchbtn); Wait.UntilLoading(); Element.ScrolTo(Searchbtn); Searchbtn.Click(); Wait.AM_Loaging_ShowAndHide(); return(this); }
/* public void datas(DataTable dt) * { * this.Show(); * this.dataGridView.DataSource = dt; * * }*/ private void ViewTopic_Load(object sender, EventArgs e) { if (conn.State.ToString() == "Closed") { conn = DB_Connection.GetConnection(); conn.Open(); } string query = "Select * from Topic"; SqlDataAdapter _sqlda = new SqlDataAdapter(query, conn); DataTable dt = new DataTable(); _sqlda.Fill(dt); SearchBox.DataSource = dt; SearchBox.Hide(); Searchbtn.Hide(); SearchBox.ValueMember = "TopicID"; SearchBox.DisplayMember = "Topic"; SearchBox.SelectedIndex = -1; }