Hi I have a problem.
I read data from a SQL database.. in this database I have some values..
like
date, time, batchnumber, quantiy, comment
and before the batchnumber could contain a Letter. The letter T then the batchnumber.
ex. T123456
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.
'Create SQLQuery
sqlquery = "SELECT * FROM TEST WHERE Batch_nr =" & "" & comment & ""
' Create a DataAdapter
da = New SqlDataAdapter(sqlquery, MyConnection)
Try
' Fill the DataAdapter
da.Fill(ds)
Catch ex As Exception
MessageBox.Show( ex.Message )
End Try
so I woul dlike to replace the T or remove it just before I do the
da.Fill(ds)
tips help..
I read my data in a .net application and get the data from a MSSQL 2008 database...