I really hope I ask this question right. I’m, working on a vb.net application that uses excel as a database. I have dropdown box that selects a person’s name. The name is an exact match to a column in the excel database. I have the database connection setup and its working great.
The trouble I’m having is trying to get the data for that person into the textboxes in my application. All the data for the person is on the same row as the person’s name… example. The person Halle Berry name is on A2 in the excel spread sheet and all her data is on B2, C2, D2 and E2.
Private Function CreateConnString(ByVal Str As String) As String
Return "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Str + ";Extended Properties=""Excel 8.0;HDR=YES;User ID=user01;Password=ThePassword;"""
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim Conn As New OleDbConnection
Dim Comm As New OleDbCommand
Dim DReader As OleDbDataReader
Dim Str As String = ""
Dim Ename = EmpName.Text
Conn.ConnectionString = CreateConnString("c:\data\TimeData.xls")
Comm.Connection = Conn
Comm.CommandText = "Select" + Ename + "From [Einfo$]"""
In my code above I have it going to the Einfo sheet and selecting the employee name (Ename). How do i tell it to read the data on it's row and put it in the textboxes?