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(SQL Statement, OleDbConnection1)
Dim ds As New DataSet
SelectCommand.Fill(ds)
Thanks
Dave
Dim SQLStatement As String = "SELECT department FROM TblUserName WHERE [UserName]='" & Me.txtUserName.Text & "'"
Dim SelectCommand As New OleDb.OleDbDataAdapter(SQL
Dim ds As New DataSet
SelectCommand.Fill(ds)
Thanks
Dave
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER
i am sorry ronald i thought i closed this straight after your answer
Dave
Dave
No problem. I'm not doing it for the points anyway :-)
ASKER
Dave