Displaying ONLY the latest number...

Israel

Hi!

I wrote these codes I would like to know how can I show the latest number on my textbox by order's number after doing my search.

I need to inform that these codes work well but the only thing I am asking is to show me how can I display on my textbox ONLY the latest number concerning my search by order's number.

Here is my codes:

string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\LunaVisa\Visa\Visa\App_Data\visa.mdb;Persist Security Info=False";

OleDbConnection sqlCon = new OleDbConnection(connectionString);

sqlCon.Open();

string commandString = "select * from company where name='" + txtName.Text + "'";

OleDbCommand sqlCmd = new OleDbCommand(commandString, sqlCon);

OleDbDataReader read = sqlCmd.ExecuteReader();

if (read.HasRows)

{

while (read.Read())

{

txtShowLastNumber.Text = read["Number"].ToString();

}

else

{

MessageBox.Show("The last number" + txtName.Text + " wasnt be found");

}

read.Close();

sqlCon.Close();

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shubham Kumar10y ago
Accepted answer
just change your query to
select top(1) * from company where name='" + txtName.Text + "' order by number desc";
Israel10y ago
@Shubham
Thank you.
Shubham Kumar10y ago
Israle i just give you the idea for your problem if you got the ans so my effort is successful and this query is running in mssql successfully if you are using other db so some syntx going to be changed nothing else
Israel10y ago
@Shubham

Thanx to rectify my codes. But I realize that you did forgot something.

select top(1) * from company where name='" + txtName.Text + "' order by number desc"; //just take off the brackets
select top 1 * from company where name='" + txtName.Text + "' order by number desc"; //correct now its works

Thank you!