asked on

Visual Studio 2010 Textbox

Hello,

I have recently switched from Microsoft Access to VS C#. Needless to say there is a learning curve but well worth the effort.

I have been stuck on two things for several days and hope someone can help me.

Problem 1: How can I get a currency textbox to display the $ sign with the amount? I was able to figure out how to do it on a currency cell in a grid but can't for the life of me figure how to do it for a single textbox?

Problem 2: I have a combo box bound to a table that uses two fields, ItemID and ItemDescription. ItemDescription is displayed. You select an Item and it will filter the data and show just that one Item. After the selected record is displayed I would like to set the displaymember to null or blank..

Thanks and any help greatly appreciated.

Gary

Carl Tawn

Assuming your regional settings are en-US:

    decimal price = 10.50M;
    YourTextBox.Text = price.ToString("C");

Open in new window

For the second you can just reset the index to zero (assuming you have an empty item at the top of your list):

    YourComboBox.SelectedIndex = 0;

Open in new window

garymcgowan

ASKER

Thanks for your prompt reply. Your solution for the textbox works. How do I get it to work with a bound textbox? Sorry I didn't state that in my original question. Yes, my regional settings are en-US.

Thanks,

Gary

Carl Tawn

How are you doing the binding?

garymcgowan

ASKER

I used the Data Source Configuration Wizard connected to a SQL 2008 database. From the Data Sources pane I drag and dropped the table that contains several fields, one of which is the one in question. The name of the field is AdvancedDisposalFee and the control is advancedDisposalFeeTextBox.

I hope I explained this correctly.

Thanks,

Gary

ASKER CERTIFIED SOLUTION

Carl Tawn

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

garymcgowan

ASKER

Carl,

The following snipit is the final code and it compiles error free but throws a runtime error.

advancedDisposalFeeTextBox.DataBindings.Add
(new Binding("Text", system1Dat_2003_SQLDataSet.tblItem, "AdvancedDisposalFee", true,
DataSourceUpdateMode.OnPropertyChanged, null, "C"));

The error is:

This causes two bindings in the collection to bind to the same property.

I assume this is because the code generated by VS has to be replaced with the code you gave me. I will work on finding the VS code. This will be good training for me digging through the code.

Thanks for your help.

Gary

Carl Tawn

It should be a binding against the textbox. Select the TextBox in the designer then, in the Properties pane, go down to the DataBindings setting. If you expand that you should find an entry against the Text property; just remove that.

garymcgowan

ASKER

Why wasn't the 500 points awarded to Carl Tawn? Please correct this and give him the points.

Thanks,

Gary

garymcgowan

ASKER

Moderator,

This was my mistake and I want Carl Tawn to be awarded the 500 points.

Thanks for your help,

Gary

garymcgowan

ASKER

Carl,

Thanks! This works great and taught me something I will use many times in the future.

Gary