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"); } }
/* 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; }