Solved

Visual Studio 2010 Textbox

Posted on 2010-11-14
11
1,052 Views
Last Modified: 2013-12-17
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
0
Comment
Question by:garymcgowan
  • 6
  • 4
11 Comments
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 34131963
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

0
 

Author Comment

by:garymcgowan
ID: 34132074
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
0
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 34132141
How are you doing the binding?
0
 

Author Comment

by:garymcgowan
ID: 34132259
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
0
 
LVL 52

Accepted Solution

by:
Carl Tawn earned 0 total points
ID: 34132597
Ok, if you want to use formatting then you are going to have to add the Binding manually.

The code would be something like:

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

Open in new window

0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

Author Comment

by:garymcgowan
ID: 34132819
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
0
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 34134294
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.
0
 

Author Comment

by:garymcgowan
ID: 34141570
Why wasn't the 500 points awarded to Carl Tawn?  Please correct this and give him the points.

Thanks,

Gary
0
 

Author Comment

by:garymcgowan
ID: 34141619
Moderator,

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

Thanks for your help,

Gary
0
 

Author Closing Comment

by:garymcgowan
ID: 34179124
Carl,

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

Gary
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

705 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

20 Experts available now in Live!

Get 1:1 Help Now