Re: VbNet and ListBox or DataGridView Formatting
- From: Jamal Mazrui <empower@xxxxxxxxx>
- To: programmingblind@xxxxxxxxxxxxx
- Date: Sun, 6 Jan 2008 08:48:32 -0500 (EST)
a ListBox has a DisplayMember property that can be set to any ColumnName
in a bound DataTable, including a Column based on a calculated expression.
Such an expression can concatonate two or more Column values.
BindingSource has a Sort property that can be set to an SQL-like SORT
clause -- basically a comma seperated list of Columns.
Hope this helps. Let us know if you have further questions.
Jamal
On Sat, 5 Jan
2008, Richard Thomas wrote:
> Date: Sat, 5 Jan 2008 06:14:48 -0500
> From: Richard Thomas <rthomas@xxxxxxxxxxx>
> Reply-To: programmingblind@xxxxxxxxxxxxx
> To: programmingblind@xxxxxxxxxxxxx
> Subject: VbNet and ListBox or DataGridView Formatting
>
> Hi Guys:
> I have a ListBox. In it I want to display a Stock Market Ticker Symbol for
> each
> entry, ok, working as BindingSource linked to a Sql server DataBase Table
> Column
> for TickerSymbols.
> Now, in my Web Version and my Liberty Basic version of the window I added a
> second Table column to the Ticker Symbol so the ListBox displayed the
> TickerSymbol and the Dividend, for example, on each line.
> So I would hear:
> MSFT 1%
> Or something like that.
> Then when I clicked a sort item in a DropDown Menu list, for example
> Sort On Dividend
> Sort On Total Return
> Sort On P/E Ratio
> I would ReLoad the ListBox displaying the TickerSymbol followed by the
> appropriate Sort Column value
> For Example:
> MSFT 10% ' for the tot ret perhaps
> MSFT 15 for the P/E ratio etc...
> In the VWD Version I used Templates and Events to modify and format data
> before
> it was shown. In Liberty Basic I used a loop to reload the text string loaded
> into the ListBox.
> In Winforms vb.net I can not figure out how to do this if I use the
> BindingSource
> Control.
> I have looked at messing with a DataGridView but nothing pops up googling that
> sounds like what I want to do either.
> Anyone have an idea or do I need to completely ReWrite my application and not
> use
> a BindingSource?
> That would mean redesigning all the table and other currency and child User
> Control interfaces, sorting methodologies and basically a complete program
> rewrite.
> That would really suck!
> I'm not sure whether vb.net is really this bad or whether it is just the
> documentation is really this bad, sigh, oh well it is what it is.
> Any ideas besides pretty much a complete ReWrite or using another language?
> Thanks:
> Rick Farmington Mich. USA
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
Other related posts:
