DataAdapter - select problem

[Agnes]

My tables got over 10,000 records,
As I drag & drop the adapter into my form, it's select command must show all
the record.
question1) Now,i only want to select the data in this current period (e.g
200406), in next month (e.g200407)
How can I set this condition programmically ??
question2) Even I show the data in this current period, I must let the user
to 'search other period' , (e.g 200312, as the user search 200312 data, USER
can use left arrow or right arrow ' to move the record position.
Under these condition, How can i design my flow ??
Thanks in advance.

From Agnes

 

[Marina]

Don't use the drag and drop wizard. Write the code yourself, and in the
process it will obvious how to set a WHERE clause.

 

[Agnes]

So, can i drag &drop it , and then copy the select command statment and
paste into my code instead ???
as my table got over 50 fields.

Thanks

 

[Marina]

My point was to not to use the drag and drop wizards, and do everything by
hand.

If you need every single field in your table, then you can do a SELECT *, to
not have to type them all out.