从xcel读取的问题 [英] problem with reading from xcel
问题描述
请帮助我正在开发一个从不同形式的数据库收集数据的系统,并且我已经能够使用vb.net实现4(mysql,xml,....)5,现在是最后一个是从excel表获取数据,但代码不起作用..请我将不胜感激任何解决方案
这是我的代码:::
pls help am working on a system that collects data from different forms of database and i have been able to implement 4 (mysql,xml,....)out 5 using vb.net and now am on the last one which is getting data from an excel sheet but the code aint working .. please i would be grateful for any solutions
this is my code :::
Dim olecon As OleDbConnection
Dim olecomm As OleDbCommand
Try
olecon = New OleDbConnection
olecon.ConnectionString = connstring_busary
'connection_busary is a variable the stores the conection string
olecon.Open()
olecomm = New OleDbCommand(String.Format("SELECT * FROM [sheet1$]"), olecon)
Dim reading As OleDbDataReader = olecomm.ExecuteReader()
While (reading.Read)
If Not reading.IsDBNull(reading.GetOrdinal("A7")) Then
Label1.Text = reading.GetString(reading.GetOrdinal("A7"))
End If
End While
Catch ex As OleDb.OleDbException
MessageBox.Show(ex.Message)
End Try
End Sub
当我运行此代码时它只运行并且不返回任何我用来跟踪从excel文件返回任何值的标签的值...我需要帮助竖起大拇指| :thumbsup:
when ever i run this code it just runs and does not return any value to the label i used to track if any value is been returned from the excel file ... please i need help Thumbs Up | :thumbsup:
推荐答案
),olecon)
Dim reading As OleDbDataReader = olecomm.ExecuteReader()
while(reading.Read)
如果不读取.IsDBNull(reading.GetOrdinal(A7))那么
Label1.Text = reading.GetString(reading.GetOrdinal(A7) ))
结束如果
结束时
Catch ex As OleDb.OleDbException
MessageBox.Show(例如。消息)
结束尝试
结束子
"), olecon) Dim reading As OleDbDataReader = olecomm.ExecuteReader() While (reading.Read) If Not reading.IsDBNull(reading.GetOrdinal("A7")) Then Label1.Text = reading.GetString(reading.GetOrdinal("A7")) End If End While Catch ex As OleDb.OleDbException MessageBox.Show(ex.Message) End Try End Sub
当我运行这个代码它只是运行,并没有返回任何值,我用来跟踪从excel文件返回任何值...我需要帮助竖起大拇指|:thumbsup:
when ever i run this code it just runs and does not return any value to the label i used to track if any value is been returned from the excel file ... please i need help Thumbs Up | :thumbsup:
这篇关于从xcel读取的问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!