Solved

Statusbar Panel Problem

Posted on 2004-09-23
5
186 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

696 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