更改数据绑定字段的显示类型. [英] Change the displayed type of a data bound field.

问题描述

我有一个交叉表查询，我正在将其用作asp.gridview控件的数据源.我得到了我想要的信息，但是信息以数字方式显示，我希望将其显示为字符串.例如:
交叉表运行的表具有针对注册参加不同班级的学生的记录.每个注册记录都有一个学生ID和一个班级ID，以及一个布尔字段(出勤)，如果他们参加该课程，则会设置该布尔字段.
我生成的交叉表会给我每行的学生列表和一个每个班级，出席人数的总和作为值字段.如果我运行此查询并将其设置为网格视图的数据源，则会得到几乎正是我想要的结果:

Student  Student  Student  Student   Student  Student  Student  Student  Student  Student  Student  Student  第1类Class2 Class3等等...
s1          -1       -1         0
s2           0                  -1      
s3           0       -1        -1

其中 空白表示他们从未注册过该课程(空)， -1表示他们注册并参加了(true)，和0表示他们已注册但未参加.

在绑定数据后，我无法更改数据列的类型，只需遍历该表即可将0和-1替换为已注册并已出席，但这就是我要实现的目标.任何人都可以想出一种快速简便的方法来达到此最终结果的方法.只要可行，我就会努力解决.

I have a crosstab query that I am using as the datasoure for an asp gridview control.  I gets me the information I want, but the information is displayed numerically and I would like it to be displayed as strings. For example:
The table the cross tab runs on has records for students that are registered to attend different classes.  Each registration record has a studentID and a classID along with a boolean field (attendance) which is set if they attended the class.
The crosstab I generate gives me a list of students in each row and a column for each class, with the sum of attendance as the value field. if I run this query and set it as the datasorce of my grid view I get this which is almost exactly what I want:

Student   Class1  Class2  Class3  etc...
s1           -1        -1          0
s2            0                    -1       
s3            0        -1         -1

where  a blank means they never registered for the class (null),  -1 means they registered and attended (true),  and 0 means they registered but did not attended.

I can't change the type of the datacolumns after the data is bound and just iterate over the table replacing the 0's and -1's with registered and attended, but that is what I would like to achieve.  Can anyone come up with a quick and easy way to achieve this end result.  I'll settle for long and difficult as long as it works.

推荐答案

感谢您的信息！我建议在( Windows开发人员中心 > http://social.msdn.microsoft.com/Forums/en-US/winformsdatacontrols/threads ).

Thank you for your post!  I would suggest creating a new thread for your question in the (Windows Developer Center > Windows Forms Forums > Windows Forms Data Controls and Databinding ) forum located here:  (http://social.msdn.microsoft.com/Forums/en-US/winformsdatacontrols/threads).

希望会有所帮助.

祝您度过愉快的一天！

感谢&问候，

这篇关于更改数据绑定字段的显示类型.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！