navigation problem with using two dataset

Question

0.00/5 (No votes)

See more:

Hi all,

I'm a bit new to vb.net.

I have successfully developed a simple navigation, having buttons like first, last, previous and next with "SELECT * FROM CUSTOMERS" with bound controls.

My problem begins with following:
When use "SELECT * FROM CUSTOMERS WHERE (CUSTOMERID=?)" and pass the parameters to command it runs successfully but it shows that my table has only one record instead of 91 records, and while only 1 record is selected I can not move to next or previous record.

I know that this makes sense with sql command, only one record in selected and data is bound with "SELECT * FROM CUSTOMERS", but I have to use sql command with WHERE CLAUSE.
I cant bound 2 datasets.

Is there any way that I can use sql statement with where clause and still manage to access all the records in navigation?

The reason of using WHERE clause is that I'm also searching through CUSTOMERID with textbox and passing the parameters in to select command.

I'm using BOUND CONTROLS.

Is this possible with bound controls or I have to use UNBOUND CONTROLS to achieve this task and what would be the code for it?

Posted 26-Mar-11 20:34pm

mehdilahori

Updated 27-Mar-11 5:56am

Dalek Dave

v2

Add a Solution

Comments

Dalek Dave 27-Mar-11 11:57am

Edited for Grammar, Syntax and Readability.

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2011-03-27T05:19:00

You cannot do that. If you still want to show all customers in the grid, you have to return all customers from SQL. You cannot use the WHERE clause for that.

Now, if you want to make sure the record that the user is searching for is visible, then you're going to have to find that record and use one of several methods for getting the DGV to scroll to make that record visible. Read this[^].

OriginalGriff · Answer 2 · 2011-03-26T20:49:00

No.

When you use

SQL

SELECT * FROM Customers WHERE (CustomerId=value)

It only returns the records which have a "CustomerId" which is the same as "value". Normally, only one customer will have this value (or you wouldn't know which customer was which), so it returns a single record only.

It's a bit like bank accounts:

SQL

SELECT * FROM Accounts

Will return every account in the bank,

SQL

SELECT * FROM Accounts WHERE (AccountNumber=MyAccountNumber)

Will only return my details.

navigation problem with using two dataset

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

navigation problem with using two dataset

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us