Ryan Smith
asked on
Getting more than one data line while using commandtext (Visual Basic.Net)
Good Evening,
I'm trying to work through this application. I'm new to programming and need some help. I'm building a VB.net application that connects to an excel file as a database. When using the attached code... It goes into my database gets some data from one of the sheets/ Rows then shows it in message boxes (I'll do other stuff with it later). That works fine.
My problem is I want it to also grab another row of data from the same sheet and display that data also.
Please help
I'm trying to work through this application. I'm new to programming and need some help. I'm building a VB.net application that connects to an excel file as a database. When using the attached code... It goes into my database gets some data from one of the sheets/ Rows then shows it in message boxes (I'll do other stuff with it later). That works fine.
My problem is I want it to also grab another row of data from the same sheet and display that data also.
Please help
Private Sub STapply_Click(sender As Object, e As EventArgs) Handles STapply.Click
Dim Site = STsiteComboBox.Text
Dim Team1 = STteam1ComboBox.Text
Dim Team2 = STteam2ComboBox.Text
Dim NDS = STndsteamComboBox.Text
HL_site_View.Text = Site
Dim Conn As New OleDbConnection
Dim Comm As New OleDbCommand
Dim DReader_T1L As OleDbDataReader
Dim Str As String = ""
Conn.ConnectionString = CreateConnString("c:\tempTestDB.xls")
Conn.Open()
Comm.Connection = Conn
Comm.CommandText = "SELECT * FROM [TeamsTL$] where Teams= """ & Team1 & """"
DReader_T1L = Comm.ExecuteReader(CommandBehavior.CloseConnection)
Try
While (DReader_T1L.Read)
MessageBox.Show(DReader_T1L.Item(1))
MessageBox.Show(DReader_T1L.Item(2))
MessageBox.Show(DReader_T1L.Item(3))
MessageBox.Show(DReader_T1L.Item(4))
End While
Finally
DReader_T1L.Close()
End Try
End Sub
Can you post the execl file and tell us what item you need to get from the sheet as well.
ASKER
Attached
tempTestDB.xls
tempTestDB.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.