Esempio n. 1
0
        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();
            }
        }
Esempio n. 2
0
        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();
            }
        }