Link to home
Start Free TrialLog in
Avatar of daverichardson
daverichardson

asked on

Statusbar Panel Problem

I need it add data from a dataset to a status bar panel but I just can’t figure it out, can anyone help. Below is the code I am using to fill the dataset

Dim SQLStatement As String = "SELECT department FROM TblUserName WHERE [UserName]='" & Me.txtUserName.Text & "'"
        Dim SelectCommand As New OleDb.OleDbDataAdapter(SQLStatement, OleDbConnection1)
        Dim ds As New DataSet
        SelectCommand.Fill(ds)

Thanks

Dave
ASKER CERTIFIED SOLUTION
Avatar of RonaldBiemans
RonaldBiemans

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of daverichardson
daverichardson

ASKER

Thanks Ronald that works great

Dave
Glad I could help,

But if you are using your above code just for filling the panel with the department, then there are better and faster ways to do that.

i am sorry ronald i thought i closed this straight after your answer

Dave
No problem. I'm not doing it for the points anyway :-)