Cannot Find An Item In A Big Table

Hello people,

I have a table of 30,000 records on my handheld which runs windows 4.2 and sql me. When the item I am searching for is at the top of the table, the search finds it easily. When the item is in the middle or lower, it doesnt find it. I am not running out of memory and my database is on the local memory. Here is my code:



String query = "SELECT * FROM Products WHERE Barcode = " + TheReaderData.Text;

DataSet ds = GetDescription(query);

label2.Text = TheReaderData.Text;

label1.Text = "No description";

if (ds.Tables[0].Rows.Count != 0)

{

label2.Text = (ds.Tables[0].Rows[0].ItemArray[0]).ToString();

label1.Text = (ds.Tables[0].Rows[0].ItemArray[1]).ToString();

}



---------------------------------------------------------------------------------------

private DataSet GetDescription(string str)

{

DataSet ds = new DataSet();

try

{

System.Data.SqlServerCe.SqlCeEngine theEngine = new SqlCeEngine(CONN_STRING);



if (!System.IO.File.Exists(DBFILE))

{

theEngine.CreateDatabase();

}



SqlCeDataAdapter da = new SqlCeDataAdapter(str, localDB);

da.SelectCommand.CommandTimeout = 6000;

da.SelectCommand.CommandType = CommandType.Text;



da.Fill(ds);

}

catch (Exception exce)

{

string total = exce.ToString();

}

return ds;

}



I hope there is some way to find the item in the object. Any ideas?

Thanks in advance, John.