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
3  1353 
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" <ag***@dynamictech.com.hk> wrote in message
news:uE**************@TK2MSFTNGP09.phx.gbl... 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
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" <so*****@nospam.com> ¦b¶l¥ó
news:%2****************@TK2MSFTNGP10.phx.gbl ¤¤¼¶¼g... 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" <ag***@dynamictech.com.hk> wrote in message
news:uE**************@TK2MSFTNGP09.phx.gbl... 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
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.
"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:%2****************@tk2msftngp13.phx.gbl... 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" <so*****@nospam.com> ¦b¶l¥ó
news:%2****************@TK2MSFTNGP10.phx.gbl ¤¤¼¶¼g... 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" <ag***@dynamictech.com.hk> wrote in message
news:uE**************@TK2MSFTNGP09.phx.gbl... 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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: randy |
last post by:
Hello all,
I have a DataTable which I am building column by column and adding rows
after each new column. The DataTable columns match the columns in my
database table. I'm building the...
|
by: hch |
last post by:
dataAdapter.Update(data, "TableName") won’t work!
I was about to deploy my first website on the Internet only to discover that
the dataAdapter.Update() throws the Server Error in the third...
|
by: Harry V |
last post by:
I'm wondering if there is a limit of a single select, delete and insert statement (command) to each dataadapter? On a form, I have a dataconnection that is shared by 3 dataadapters, one for each of...
|
by: TJ Doherty |
last post by:
Need help understanding the following please:
When I am creating a project and code my connection using Dim connectString
As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data...
|
by: Jack |
last post by:
I have the following:
* An OLEDBCommand with command text "SELECT CAMPAIGN,
DAY_OUT WHERE (CAMPAIGN LIKE '@campaign')"
* A DataAdapter that point the select to the above command
* A data grid...
| | |
by: Siv |
last post by:
Hi,
I seem to be having a problem with a DataAdapter against an Access database.
My app deletes 3 records runs a da.update(dt) where dt is a data.Datatable.
I then proceed to update a list to...
|
by: Zorpiedoman |
last post by:
I keep getting a concurrency exception the second time I make a change and
attempt to update a dataadapter. It appears this is by design, so there must
be something I can do to avoid it.
...
|
by: Franklin M. Gauer III |
last post by:
I create a simple DATAADAPTER in a webservice project. It creates the
UPDATE, INSERT, DELETE commands for me - no problem.
In vS2005 it creates these commands as RESOURCES in the RESX file (i.e....
|
by: Rich |
last post by:
Dim da As New SqlDataAdapter("Select * from tbl1", conn)
dim tblx As New DataTable
da.Fill(tblx) '--works OK up to this point
da.UpdateCommand = New SqlCommand
da.UpdateCommand.Connection =...
|
by: Rich |
last post by:
What is the diffeence bewtween a dataAdapter.InsertCommand and
dataAdapter.SelectCommand (and dataAdapter.UpdateCommand for that matter)?
Dim da As SqlDataAdapter
conn.Open
da.SelectCommand =...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
