[RESOLVED] Converting Data to UpperCase?

[blakemckenna]

I have a SQL Server Table that contains country names. I have this table bound to a ComboBox control on one of my forms. The data itself witin the talbe is in lower case.

My question is, how can I convert the data to upper case either in the table or the ComboBox?

Thanks,

[jmcilhinney]

If you don't need the original text in your app then just include the conversion to upper case in your query. I would assume that T-SQL includes a function that converts text to upper case so you should be able to find it in Books Online simply enough.

[blakemckenna]

Well, the dataset is "typed" and bound to the ComboBox. I did this in design mode so I'm not sure how I would do that.

[jmcilhinney]

How do you usually modify things in the designer? You select them with the mouse and then you either edit them in-situ (which might involve drag'n'drop or a right-click) or else you make changes in the Properties window.

[blakemckenna]

I used the Properties window to assign the Datasource to the combobox and then selected a field for the DisplayMember. I don't know what to do in order to convert the Country Name to uppercase.

[jmcilhinney]

I'm not talking about the ComboBox. I'm talking about changing your SQL code. Open your DataSet in the designer, select your TableAdapter and open the Properties window.

[blakemckenna]

jmc,

I see what your talking about. I got into the designer of the BindingSource and modified the SQL using the function "ucase" and that worked.

Thanks for your help!