예제 #1
0
        protected void SearchCarteButton_Click(object sender, EventArgs e)
        {
            string        constr = ConfigurationManager.ConnectionStrings["EngineDatabase"].ConnectionString;
            SqlConnection con    = new SqlConnection(constr);
            string        comm   = "SELECT IdCarte, IdEditura, Titlu, Autor, DataPublicare, Categorie, ExemplareVandute FROM [Carte] WHERE ExemplareVandute >= @min_value AND ExemplareVandute <= @max_value";
            SqlCommand    cmd    = new SqlCommand(comm);

            try
            {
                using (SqlDataAdapter sda = new SqlDataAdapter())
                {
                    cmd.Connection    = con;
                    sda.SelectCommand = cmd;
                    sda.SelectCommand.Parameters.AddWithValue("@min_value", SearchMinValue.Text);
                    sda.SelectCommand.Parameters.AddWithValue("@max_value", SearchMaxValue.Text);

                    using (DataTable dt = new DataTable())
                    {
                        sda.Fill(dt);
                        SearchedItemsDetailsView.DataSource = dt;
                        SearchedItemsDetailsView.DataBind();
                    }
                }
            }
            catch (Exception ex)
            {
                LabelSearchStatus.Text = "Failed";
            }
        }
예제 #2
0
        private void BindDetailsView()
        {
            string        constr = ConfigurationManager.ConnectionStrings["EngineDatabase"].ConnectionString;
            SqlConnection con    = new SqlConnection(constr);
            string        comm   = "SELECT IdCarte, IdEditura, Titlu, Autor, DataPublicare, Categorie, ExemplareVandute FROM [Carte]";
            SqlCommand    cmd    = new SqlCommand(comm);

            try
            {
                using (SqlDataAdapter sda = new SqlDataAdapter())
                {
                    cmd.Connection    = con;
                    sda.SelectCommand = cmd;
                    using (DataTable dt = new DataTable())
                    {
                        sda.Fill(dt);
                        SearchedItemsDetailsView.DataSource = dt;
                        SearchedItemsDetailsView.DataBind();
                    }
                }
            }
            catch (Exception ex)
            {
            }
        }