用vb.net查询出是乱码
我是用vb.net2005开发的,在窗体上有一个DataGridView1控件,和按钮,按钮执行语句如下:
Dim dbConnStr As String
dbConnStr = ""
dbConnStr = "Driver={Microsoft Paradox Driver (*.db )}; DriverID=538; Fil=Paradox 7.X; DefaultDir=C:\Program Files\航天信息\防伪开票\DATABASE\DEFAULT\WORK; Dbq=C:\Program Files\航天信息\防伪开票\DATABASE\DEFAULT\WORK;PWD=1FFKEC123Q4C26G; "
Dim strSelect As String
strSelect = "select * from 销项发票"
Dim odbcConn As OdbcConnection
odbcConn = New OdbcConnection(dbConnStr)
odbcConn.Open()
Dim odbcAdapter As OdbcDataAdapter
odbcAdapter = New OdbcDataAdapter(strSelect, odbcConn)
Dim m_dsSrc As DataSet
m_dsSrc = New DataSet()
odbcAdapter.Fill(m_dsSrc, "PadaboxDB")
DataGridView1.DataSource = m_dsSrc.Tables(0)
odbcConn.Close()
这样查询出来是乱码,但用别的工具查询没有事,都是中文的,不知道哪里有问题,需要怎么进行转换一下