如何在datagridview列中输入等效数据? [英] How to input equivalent data in datagridview column?

问题描述

我有一个C#Windows应用程序，该应用程序具有一个连接到SQL Server数据库的datagridview.我想在一列中用整数的字符串等效数据替换数据.我不知道该怎么做.
例如，在一列中，我们有:
0
1
1
0
2

我想将0替换为passed，将1替换为return，将2替换为waiting

谢谢

I have a c# windows application, that has a datagridview connected to SQL server database. I want to replace data with string equivalent data of integer of that in one column. I don''t know, how to do this.
for example in a column we have:
0
1
1
0
2

I want to replace 0 with passed, 1 with returned, 2 with waiting

Thank you

推荐答案

例如，最简单的方法可能是更改查询以在选择时使用 CASE 语句:

Probably the easiest way is to change your query to use a CASE statement when selecting, for example:

SELECT CASE columnValue WHEN 0 THEN 'passed' WHEN 1 THEN 'returned' WHEN 2 THEN 'waiting' ELSE 'invalid code' END AS ReadableStatus FROM tableName

否则，您可能需要创建一个TypeConverter以便在该列的

Otherwise, you will probably need to create a TypeConverter to use in the column''s CellTemplate[^]

这篇关于如何在datagridview列中输入等效数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！