Solved

Visual Studio 2010 Textbox

Posted on 2010-11-14
11
1,062 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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

We all know that functional code is the leg that any good program stands on when it comes right down to it, however, if your program lacks a good user interface your product may not have the appeal needed to keep your customers happy. This issue can…
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

914 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

21 Experts available now in Live!

Get 1:1 Help Now