Solved

Statusbar Panel Problem

Posted on 2004-09-23
5
184 Views
Last Modified: 2010-04-23
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
0
Comment
Question by:daverichardson
  • 3
  • 2
5 Comments
 
LVL 25

Accepted Solution

by:
RonaldBiemans earned 50 total points
ID: 12131402
you mean like this

StatusBar1.Panels(0).Text = ds.Tables(0).Rows(0).Item("department")

don't forget to set the property showpanels of your statusbar to true and ofcourse to add a panel to the panels collection
0
 

Author Comment

by:daverichardson
ID: 12131924
Thanks Ronald that works great

Dave
0
 
LVL 25

Expert Comment

by:RonaldBiemans
ID: 12131959
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.

0
 

Author Comment

by:daverichardson
ID: 12297530
i am sorry ronald i thought i closed this straight after your answer

Dave
0
 
LVL 25

Expert Comment

by:RonaldBiemans
ID: 12297584
No problem. I'm not doing it for the points anyway :-)
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
Introduction When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now