예제 #1
0
    public void DoBasicSearch()
    {
        try
        {
            DataSet incidentData = new DataSet();
            incidentData = sqlqueryBasic();
            GridView1.AutoGenerateColumns = true;
            GridView1.DataSource          = incidentData;

            IncidentTable = incidentData.Tables[0]; //check incomming data in table format

            GridView1.DataSource = IncidentTable;

            GridView1.DataBind();

            GridView1.UseAccessibleHeader    = true;
            GridView1.HeaderRow.TableSection = TableRowSection.TableHeader;

            lblResults.Visible   = true;
            lblResults.ForeColor = Color.Green;
            lblResults.Text      = "Your search has returned " +
                                   incidentData.Tables[0].Select("'Incident Number' IS NOT NULL").Length.ToString() +
                                   " records.";
            AdvResults.Update();
        }
        catch (Exception exec)
        { Console.WriteLine(exec); }
    }
예제 #2
0
    public void BindResultsToGrid()
    {
        IncidentData = QueryBuilder();

        try
        {
            //Bind dataset to the gridview
            AdvSearchResults.AutoGenerateColumns = false;
            IncidentTable = IncidentData.Tables[0];


            AdvSearchResults.DataSource = IncidentTable; //can be changed to a dataset incidentTable might be used for sorting later


            AdvSearchResults.DataBind();

            AdvSearchResults.UseAccessibleHeader    = true;
            AdvSearchResults.HeaderRow.TableSection = TableRowSection.TableHeader;


            lblResults.Visible   = true;
            lblResults.ForeColor = Color.Green;
            lblResults.Text      = "Your search has returned " + IncidentData.Tables[0].Select("'Incident Number' IS NOT NULL").Length + " records.";

            AdvResults.Update();
        }

        catch (Exception err)
        {
            lblResults.Visible   = true;
            lblResults.ForeColor = Color.Red;
            lblResults.Text      = "An error has occurred loading data into the table view. ";
            lblResults.Text     += err.Message;

            Console.WriteLine(err.ToString());
        }
    }
예제 #3
0
 protected void DD_area_SelectedIndexChanged(object sender, EventArgs e)
 {
     AdvResults.Update();
 }