Show me the very last number by ORDER

Question

Hi! I have a small table with three column: ID Name and number Then in the number column there is numbers that its not in order (for example: 12753 etc.) When I make my search I wish that this filter should be do in order. For instance if the column Name = 'shana' then show me ONLY the very last number of shana into my textbox. With these codes its works but its show me the first number (or other anynumber) of the person I need. But my concern is to show the last number in order. This is the error message: Erro of sintaxe in expression of query 'number where name='Shana''.

Cefora Kaja · Answer

Excuse me to send my code in piece. I could not send the whole once. The site doesnt allow mw to send the whole. I dont know what happen.

Cefora Kaja · Answer

string commandString = select * from company ORDER BY where name=' + textBox1.Text + '; OleDbCommand sqlCmd = new OleDbCommand(commandString sqlCon); OleDbDataReader read = sqlCmd.ExecuteReader();

Cefora Kaja · Answer

Lets see my codes: string connectionString = @Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\hello\App_Data	est.mdb;Persist Security Info=False; OleDbConnection sqlCon = new OleDbConnection(connectionString); sqlCon.Open();