예제 #1
0
        protected void DrugListGridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            DrugListGridView.PageIndex = e.NewPageIndex;
            string        mainconn = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
            SqlConnection sqlconn  = new SqlConnection(mainconn);

            sqlconn.Open();
            SqlCommand sqlcomm  = new SqlCommand();
            string     sqlquery = "Select *" +
                                  "From[UzimaDrug]";

            sqlcomm.Parameters.AddWithValue("DrugName", DrugListSearch.Text);
            sqlcomm.CommandText = sqlquery;
            sqlcomm.Connection  = sqlconn;
            DataTable      dt  = new DataTable();
            SqlDataAdapter sda = new SqlDataAdapter(sqlcomm);

            sda.Fill(dt);
            DrugListGridView.DataSource = dt;
            DrugListGridView.DataBind();
        }
예제 #2
0
        protected void InventorySearchBtn_Click(object sender, EventArgs e)
        {
            DrugListGridView.Visible = true;

            string        mainconn = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
            SqlConnection sqlconn  = new SqlConnection(mainconn);

            sqlconn.Open();
            SqlCommand sqlcomm  = new SqlCommand();
            string     sqlquery = "Select *" +
                                  "From[UzimaDrug]" +
                                  "Where [DrugName] like '%'+@DrugName+'%'";

            sqlcomm.Parameters.AddWithValue("DrugName", DrugListSearch.Text);
            sqlcomm.CommandText = sqlquery;
            sqlcomm.Connection  = sqlconn;
            DataTable      dt  = new DataTable();
            SqlDataAdapter sda = new SqlDataAdapter(sqlcomm);

            sda.Fill(dt);
            DrugListGridView.DataSource = dt;
            DrugListGridView.DataBind();
        }
예제 #3
0
 protected void OnPaging(object sender, GridViewPageEventArgs e)
 {
     DrugListGridView.PageIndex = e.NewPageIndex;
     DrugListGridView.DataBind();
 }