vb.net dataset replace "T"
Posted on 2011-03-01
Hi I have a problem.
I read data from a SQL database.. in this database I have some values..
date, time, batchnumber, quantiy, comment
and before the batchnumber could contain a Letter. The letter T then the batchnumber.
No this T is not in used longer but I can´t delete the old data that contains T.
So I wounder can I in some simple way replace the T in my dataadpater before I filll my dataset?
Plese look at my code below.
sqlquery = "SELECT * FROM TEST WHERE Batch_nr =" & "" & comment & ""
' Create a DataAdapter
da = New SqlDataAdapter(sqlquery, MyConnection)
' Fill the DataAdapter
Catch ex As Exception
MessageBox.Show( ex.Message )
so I woul dlike to replace the T or remove it just before I do the
I read my data in a .net application and get the data from a MSSQL 2008 database...