strange datagrid issue

Vedder · 26 Mar 2007 at 11:14

Is there any reason why having a more than one datagrid on a page cause weird results? I have a simple page which lists employees in three departments. I have department 1 as userid 1-20 then department 2 as userid 21-30 and have the queries in sql. My code is set out like this:

Code:

void Page_Load()
    {
        GetCommercialServices();
        GetPrivateServices();
    }
   
   
   
    void GetCommercialServices()
    {
       

            OdbcConnection DataConnection = new OdbcConnection(ConnectionString);
            QueryString = "SELECT (([SOLICITOR].[SolicitorID] >= 12) AND ([SOLICITOR].[SolicitorID] <= 22))";

            DataConnection.Open();
            DataCommand.CommandText = QueryString;
            DataCommand.Connection = DataConnection;        

            DataAdapter.SelectCommand = DataCommand;
            DataAdapter.Fill(dataSet);

            GetCommercialClient.DataSource = dataSet;
            GetCommercialClient.DataBind();
           
       
    }

    void GetPrivateServices()
    {
       

            OdbcConnection DataConnection = new OdbcConnection(ConnectionString);
            QueryString = "(([SOLICITOR].[SolicitorID] >= 23) AND ([SOLICITOR].[SolicitorID] <= 25))";


            DataConnection.Open();
            DataCommand.CommandText = QueryString;
            DataCommand.Connection = DataConnection;


            DataAdapter.SelectCommand = DataCommand;
            DataAdapter.Fill(dataSet);

            GetPrivateClient.DataSource = dataSet;
            GetPrivateClient.DataBind();
      
    }

If I just invoke department 1 I get a correct output like so:

Dave Smith
John Smith

If I just invoke department 2 I get a correct output like so:

Kevin Taylor
Steven Taylor

If I invoke both methods I get the first datagrid ok, but the second one is the two datagrids combined. Is there any explanation for this madness?

Note: I have made the sql statments shorter.

Visage · 26 Mar 2007 at 11:33

Vedder said:
Is there any reason why having a more than one datagrid on a page cause weird results? I have a simple page which lists employees in three departments. I have department 1 as userid 1-20 then department 2 as userid 21-30 and have the queries in sql. My code is set out like this:

Code:

void Page_Load() { GetCommercialServices(); GetPrivateServices(); } void GetCommercialServices() { OdbcConnection DataConnection = new OdbcConnection(ConnectionString); QueryString = "SELECT (([SOLICITOR].[SolicitorID] >= 12) AND ([SOLICITOR].[SolicitorID] <= 22))"; DataConnection.Open(); DataCommand.CommandText = QueryString; DataCommand.Connection = DataConnection; DataAdapter.SelectCommand = DataCommand; DataAdapter.Fill(dataSet); GetCommercialClient.DataSource = dataSet; GetCommercialClient.DataBind(); } void GetPrivateServices() { OdbcConnection DataConnection = new OdbcConnection(ConnectionString); QueryString = "(([SOLICITOR].[SolicitorID] >= 23) AND ([SOLICITOR].[SolicitorID] <= 25))"; DataConnection.Open(); DataCommand.CommandText = QueryString; DataCommand.Connection = DataConnection; DataAdapter.SelectCommand = DataCommand; DataAdapter.Fill(dataSet); GetPrivateClient.DataSource = dataSet; GetPrivateClient.DataBind(); }

If I just invoke department 1 I get a correct output like so:

Dave Smith
John Smith

If I just invoke department 2 I get a correct output like so:

Kevin Taylor
Steven Taylor

If I invoke both methods I get the first datagrid ok, but the second one is the two datagrids combined. Is there any explanation for this madness?

Note: I have made the sql statments shorter.

Hard to say to be sure, but if the dataSet object is global then arent you filling it with the first set of data and then filling it with the second set of data?

Dont you need two distinct dataSets?

Vedder · 26 Mar 2007 at 11:48

Yes, you are right. Bit of a "doh" moment I am afraid. Thanks a lot.

strange datagrid issue

Vedder

Vedder

Visage

Visage

Vedder

Vedder