小弟初学VS2003
不知如何将绑定于DataGrid里的学生成绩排序？
考虑先排序好再传到DataGrid里，但视图不支持ORDER BY（因为DataGrid里的数据列来自不同表，所以临时创建视图）
请求高手解答如何排序，另外如何在DataGrid首列加一个名次列？
------解决方案--------------------------------------------------------
数据库的视图不可排序,但内存的dataview是可排序的.如:DataView dv = dt.DefaultView;dv.Sort = "字段 "this.DataGrid1.DataSoruce = dv;
------解决方案--------------------------------------------------------
mysql = "select id as 编号,Name as 姓名,sex as 性别, address as 地址,tel as 电话,Email from student "
'排序
Select Case viewstate( "Sort ")
Case "编号 "
mysql = mysql & " order by ID "
Case "姓名 "
mysql = mysql & " order by Name "
Case "性别 "
mysql = mysql & " order by sex "
Case "地址 "
mysql = mysql & " order by address "
Case "电话 "
mysql = mysql & " order by tel "
Case "Email "
mysql = mysql & " order by Email "
End Select
mysql = mysql & viewstate( "OrderBy ")
-------------
用SQL比较简单