*Assuming your database is MS SQL Sevrer*
Have a look at the
LTRIM and
RTRIM SQL functions.
Then you could do something like this to remove the whitespace:
SELECT
LTRIM(RTRIM(ppo_no)) AS ppo_no
FROM
[bill entry]
*Assuming it's Oracle*
Have a look at the
TRIM SQL function.
*Since you stated its VB.NET*
Something like:
txtTextBox.Text = DataTable.Rows(iRowNumber).ItemArray(iColumnNumber).ToString().Trim()
or
txtTextBox.Text = DataTable.Rows(0)("ppo_no").ToString().Trim()
Hope it helps.