急....急...CSV文件导入问题
Dim file_info As New System.IO.FileInfo(strfilepath)
'Dim strConn As String = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" + file_info.Directory.ToString() + ";Extensions=asc,csv,tab,txt;HDR=No"
Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
strConn += file_info.Directory.ToString()
strConn += ";Extended Properties=""text;HDR=No;FMT=Delimited"""
Dim objConn As New OleDb.OleDbConnection(strConn)
Dim dscsv As New DataSet
Try
'objConn.Open()
Dim strSql As String = "select * from " + file_info.Name.ToString()
Dim odbcCSVDataAdapter As New OleDb.OleDbDataAdapter(strSql, objConn)
odbcCSVDataAdapter.Fill(dscsv)
odbcCSVDataAdapter.Dispose()
objConn.Close()
Catch ex As Exception
End Try
--------------------------------------
为什么导入0034899000000
在datagridview中显示的却是3.4899E+10
还有就是当导入070321的话也会变成70321
我是想把这所有的当成字符串导入到dataset中,然后再在datagridview中显示.
请大家帮帮忙..