Read String from DataSet

[egodette]

I read a CSV into a DataSet that contains digits that should be stored as String.
Example..
adus,088606108,12.00
When I read the data back using the following code
strMsg = ds.Tables(0).Rows(1)(1)
It drops the leading 0 and becomes 88606108
Reading this line
adus,05545e209,12.00 becomes 5.545E+212

How do I keep the data as a string?

 

[ZmrAbdulla]

It reads as Numeric value.
Try to get it as string value

ds.Tables(0).Rows(1).Item(1).ToString

Zameer Abdulla

 

[egodette]

That did not work. Im wondering if the data is being brought into the dataset as numberic. This is what I'm doing to load the data into the dataset. Is there another way that will type the data as String?

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=P:\Administrator\scripts\IDC_Pricing\;Extended Properties='text;HDR=No;FMT=Delimited'"
CommandText = "select * from idcinput.txt"

conn = New System.Data.OleDb.OleDbConnection(ConnectionString)
Command = New System.Data.OleDb.OleDbCommand(CommandText, conn)

conn.Open()

Dim da As OleDbDataAdapter = New OleDbDataAdapter(CommandText, conn)
Dim ds As DataSet = New DataSet
' fill dataset
da.Fill(ds, "PriceTable")

 

[egodette]

I fixed it. I created a schema.ini and typed all the columns as Char.

Thanks for all your help.

 

[ZmrAbdulla]

Glad you fixed it.



Zameer Abdulla