Solved

combo box databinding problem

Posted on 2006-07-20
2
217 Views
Last Modified: 2010-04-23
Hi, everybody,

I have a winform combo box that binds to a dataset created by a sql stored proc. My question is how to make the combo box default to an empty/null value?

The combo is for users to select a Region as searching criteria. It has to be optional, meaning, it has to contain an empty entry with the regular West, East...

Do I make my stored proc returns an empty line at the top of normal data set, or add an empty entry into combo box after it was populated?

Neither seems is the right way to handle the situation.

Thanks!
0
Comment
Question by:ommer
2 Comments
 
LVL 17

Accepted Solution

by:
ZeonFlash earned 125 total points
ID: 17149883
Either way is acceptable.  

SELECT NULL, NULL
UNION
SELECT Region, RegionValue
FROM ...

--Or--

'Fill dataset

Dim dr As DataRow = ds.Tables(0).NewRow

For Each col As DataColumn In ds.Tables(0).Columns
      dr.Item(col) = DBNull.Value
Next

ds.Tables(0).Rows.InsertAt(dr, 0)

'Bind dataset to combobox here
0
 

Author Comment

by:ommer
ID: 17153837
Cool!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

895 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

15 Experts available now in Live!

Get 1:1 Help Now