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.
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")
Comm.Connection = Conn
Comm.CommandText = "SELECT * FROM [TeamsTL$] where Teams= """ & Team1 & """"
DReader_T1L = Comm.ExecuteReader(CommandBehavior.CloseConnection)