How to Search Latest added record in textbox if serach value is duplicate

Question

0.00/5 (No votes)

See more:

Hi,
I have created table on SQL server with field 1. DIR(11 digit number), 2.DIR Version (2 digit number following the DIR) 3. status(status of DIR) and 4.Entry datetime (auto update).
I am trying to create a searchform, search value would be DIR(11 digit number)and trying to get the DIR and version.

Here 11 digit DIR number would be repeated in DB
E.g

DIR number | version | Status | Creation Date
10000000001 | 01 | Started |05.01.2016 10:10
10000000001 | 01 | In process|06.01.2016 10.10
10000000001 | 01 | Completed |07.01.2016 10:10

I want to search only latest entry based on DIR number.

TextBox1(Search value) = DIR number
TextBox2(Result Value) = DIR number
TextBox3(Result Value) = Version.
TextBox3(Result Value) = Status.

Can anybody help me on this?

Posted 10-Jan-16 19:17pm

Member 12256084

Updated 10-Jan-16 19:21pm

v2

Add a Solution

1 solution

Add a Solution

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)

DamithSL · Accepted Answer · 2016-01-10T19:28:00

Solution 1

you can use sql statement to get details by top 1 and order by

SQL

select top 1 dirnumber,version,status from TableName where dirnumber =@dirnumber order by creationdate desc

set the DIR number parameter from user input

Posted 10-Jan-16 19:28pm

DamithSL