Hi all,
my datagrid gets its data from a dataview:
Dim catView As DataView = New DataView(ds.Tables("DMFA_A
grdSendFromFile.DataSource
The dataset / datagrid has some 2000 rows and 8 columns.
One of these columns holds a value from the database : either 1, 2 or 3
Instead of just showing 1, 2, 3 in the corresponding column in the grid, I want to 'enumerate' these values.
For example : a '1' would have "Type One" , '2' would have "Type two" and so on
Any suggestions?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
I agree with hammdan 1980. If the query returns the result in the correct format from the beginning it significantly reduces the processing required to get the results in the format you want it. A case will work fine for this.
Here is two articles to explain how they work:
http://blog.sqlauthority.c
http://www.databasejournal
The only problem with that approach comes if the field/column is bound to the datatable and editable in the datagrid. Because, in that case, when the value in the datatable is passed back to the database, it is (even though it came from the database) now of a datatype which the database will not accept. If that's the situation I think you would need to use the Binding.Format and Binding.Parse events to translate backwards and forwards between the "real" values and the "displayed" values.
You don't say what version of .NET you are on. Here's the "parse" doc relating to 1.1.
http://msdn.microsoft.com/
It includes links both to the "format" doc and to those for later versions.
Roger
If you will allow editing of data, you should create another datatable of the enumerated values. Make that column a combobox column, data bind it to your new datatable, set the DisplayMember to the description, the ValueMember to the value (ie, 1 2 or 3), and the DataPropertyName to the appropriate column in the grid's datasource.
I agree with molku. Given that this is concerned with a datagrid, which uses Complex binding rather than Simple binding, I should have said CellFormatting and CellParsing, not Binding.Format and Binding.Parse. And even then those are not available with a DataGrid (as opposed to a DataGridView).
Roger
Business Accounts
Answer for Membership
by: hammdan_1980Posted on 2008-05-22 at 00:36:15ID: 21621599
The best way to do this is from your sql query ,, for example
select type_id,
CASE type_id
WHEN 1 THEN 'First'
WHEN 2 THEN 'Second'
WHEN 3 THEN 'Third'
ELSE 'Other'
END
from
myTable
Otherwise you have to check the data when at databound event in gridview and change when rebdering ,, which will be much complicated and less performance solution ....