protected void SearchToyByName(object sender, EventArgs e) { string constr = ConfigurationManager.ConnectionStrings["dbSOFT703ConnectionString"].ConnectionString; string query = "SELECT * FROM tblToy"; if (SearToyName.Text != null) { query = "SELECT * FROM tblToy WHERE type LIKE '%" + SearToyName.Text + "%'"; } try { using (SqlConnection con = new SqlConnection(constr)) { using (SqlDataAdapter sda = new SqlDataAdapter(query, con)) { using (DataTable dt = new DataTable()) { sda.Fill(dt); GridToy.DataSource = dt; GridToy.DataBind(); } } } } catch (Exception) { showMessage(); } }
private void BindGrid() { string constr = ConfigurationManager.ConnectionStrings["dbSOFT703ConnectionString"].ConnectionString; string query = "SELECT * FROM tblUser"; string querytoy = "SELECT * FROM tblToy"; try { using (SqlConnection con = new SqlConnection(constr)) { using (SqlDataAdapter sda = new SqlDataAdapter(query, con)) { using (DataTable dt = new DataTable()) { sda.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); } } using (SqlDataAdapter sda = new SqlDataAdapter(querytoy, con)) { using (DataTable dt = new DataTable()) { sda.Fill(dt); GridToy.DataSource = dt; GridToy.DataBind(); } } } } catch (Exception) { showMessage(); } }