Re: Reducing Number of Columns When Changing Query

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 09/25/04 

Date: Fri, 24 Sep 2004 18:49:32 -0700

Clear the DataSet before reusing it. 

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"dormy" <dormy@dormys.house.com> wrote in message 
news:4154797b$1_2@127.0.0.1...
>I have a DataGrid that is bound to a .mdb using a DataAdapter and DataSet. 
>When
> I first start the program the grid is filled with data properly.
>
> I then change the select command and refill the DataSet. The change to the
> query is to remove one column that is returned. For example:
> before
> SELECT a, b, c, d FROM x
> after
> SELECT a, b, c FROM x
>
> The proper rows are displayed but I still get a column labeled d. The 
> column d
> has empty data.
>
> How to I get the grid to stop displaying column d, short of manually 
> removing
> the column. There will be instances where the query is typed in by the 
> user and
> can be sonewhat freeform.
>
> Thanks
>

Relevant Pages

  • Reducing Number of Columns When Changing Query
    ... I have a DataGrid that is bound to a .mdb using a DataAdapter and DataSet. ... I first start the program the grid is filled with data properly. ... query is to remove one column that is returned. ... How to I get the grid to stop displaying column d, ...
    (microsoft.public.data.ado)
  • Re: update query: still having problems
    ... bring the workstatus field in the grid and, at the criteria line, write: ... UPDATE Department INNER JOIN Sheet1 ON Department.employeeID = ... What I want to do is press a button that will run the query and update the ...
    (microsoft.public.access.queries)
  • Re: Sequence numbering labels
    ... The upper pane of the query design window contains the tables. ... lower pane is the output grid. ... table field to the query output grid' ...that I did not understand, ... and put that count field into the label via label wizard. ...
    (microsoft.public.access.modulesdaovba)
  • Re: VB.NET - How do I return an AutoNumber from an Insert Statement using the DataGridView
    ... > Thanks for that Bart, ... > the values from my Grid to the TableAdapters Insert method. ... >> choose add query, then choose insert query, use a query like below, ... >>> stored in the SQL Database but a VB generated (or disconected dataset ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Using queries in a table adaptor?
    ... using the query wizard I have added several queries ... FROM [Drive Package] ... Not there is no Join here these are just simple Queries on a simple table. ... I am use the flex grid because of some unique features ...
    (microsoft.public.dotnet.framework.adonet)