Пример #1
0
    public void BindGrid()
    {
        string sDataSource = string.Empty;

        if (Request.Cookies["Company"] != null)
        {
            sDataSource = System.Configuration.ConfigurationManager.ConnectionStrings[Request.Cookies["Company"].Value].ToString();
        }
        else
        {
            Response.Redirect("~/Login.aspx");
        }


        DataSet       ds = new DataSet();
        BusinessLogic bl = new BusinessLogic(sDataSource);

        ds = bl.ListComplaints(sDataSource, txtSearch.Text, ddCriteria.SelectedValue, chkActive.Checked);

        if (ds != null)
        {
            GrdViewComplaint.DataSource = ds.Tables[0].DefaultView;
            GrdViewComplaint.DataBind();
        }
        else
        {
            GrdViewComplaint.DataSource = null;
            GrdViewComplaint.DataBind();
        }
    }
Пример #2
0
    protected void cmdSearch_Click(object sender, EventArgs e)
    {
        try
        {
            string sDataSource = string.Empty;

            if (Request.Cookies["Company"] != null)
            {
                sDataSource = System.Configuration.ConfigurationManager.ConnectionStrings[Request.Cookies["Company"].Value].ToString();
            }
            else
            {
                Response.Redirect("~/frm_Login.aspx");
            }


            DataSet       ds = new DataSet();
            BusinessLogic bl = new BusinessLogic(sDataSource);
            ds = bl.ListComplaints(sDataSource, txtSearch.Text, ddCriteria.SelectedValue, chkActive.Checked);

            if (ds != null)
            {
                GrdViewComplaint.DataSource = ds.Tables[0].DefaultView;
                GrdViewComplaint.DataBind();
            }
            else
            {
                GrdViewComplaint.EmptyDataText = "No Complaints found";
                GrdViewComplaint.DataSource    = null;
                GrdViewComplaint.DataBind();
            }
        }
        catch (Exception ex)
        {
            TroyLiteExceptionManager.HandleException(ex);
        }
    }