How find bottom data in table

Question

0.00/5 (No votes)

See more:

i need search bottom value in the table to combo box or text box
im use this code. earlier project i do it.but this time i cant do this

um used this query

SELECT Name
FROM Diesal1
ORDER BY date DESC

it was executed correctly

then apply it to text box. after that i got this error

"The schema returned by the new query differs from the base query"
What is the wrong with this. pls help me......
im using vb.net 2008 and SQL Express

thank u...........

Posted 6-Nov-13 16:15pm

Amal anjula

Add a Solution

Comments

_Damian S_ 6-Nov-13 22:44pm

If your query is returning the correct data, then all you need to do is stash the returned value in the text box. There seems to be some information missing...

GuyThiebaut 8-Nov-13 12:00pm

Try something like:

select top 1 name
from diesal1
order by date desc

Mike Meinz 9-Nov-13 8:59am

It is very difficult to guess what you are doing to cause this error when you do not provide your VB .NET code. My guess is that you are using a TableAdapter and the columns in the TableAdapter do not match the columns in the SELECT statement that you showed in your question. Try changing the SELECT statement from
SELECT Name FROM Diesal1 ORDER BY date DESC

to

SELECT * FROM Diesal1 ORDER BY date DESC

or

SELECT TOP 1 * FROM Diesal1 ORDER BY date DESC

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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