为什么我的 e.SortExpression.ToString() 得到的总是空值？

[sra]

Dim public connectionString As String = ConfigurationSettings.AppSettings("ConnectionString")
Dim public sqlConnection As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(connectionString)
Public SortField as String

Function MyQueryMethod() As System.Data.DataSet

Dim queryString As String = "SELECT * FROM [question_and_answer]"
Dim sqlCommand As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand(queryString, sqlConnection)

Dim dataAdapter As System.Data.SqlClient.SqlDataAdapter = New System.Data.SqlClient.SqlDataAdapter(sqlCommand)
Dim dataSet As System.Data.DataSet = New System.Data.DataSet
dataAdapter.Fill(dataSet)

Return dataSet
End Function

Sub Page_Load(Source As Object, E As EventArgs)
if not isPostBack then
DataGrid1.DataBind()
If SortField="" then
SortField="qaDate"
End If
end if
response.write ("<br>SortField="&SortField)
End Sub

Sub DataGrid1_SortCommand(source As Object, e As DataGridSortCommandEventArgs)
SortField=e.SortExpression.ToString()
response.write ("<br>the Command is true!")
'DataGrid1.DataBind()
End Sub

[spring_ok]

datagrid中各对应的colomn要指定SortExpression属性。

[sra]

如何指定能？

能否举个例子先？

举完就给分！ ：）

[scent]

设置SortExpression属性

[scent]

在datagrid的属性生成器里，点左边“列”项，在右边“选定的列”项中，选择你要排序的字段，在下边有一个“排序表达式”的下拉框，写上你要排序的字段名称.

[sra]

我设置了呀！

<Columns>
<asp:BoundColumn DataField="qaID" HeaderText="ID"></asp:BoundColumn>
<asp:BoundColumn DataField="pID" HeaderText="产品类别"></asp:BoundColumn>
<asp:BoundColumn DataField="qaTechnicSort" SortExpression="abc" HeaderText="问题类别"></asp:BoundColumn>
<asp:BoundColumn DataField="qaDate" HeaderText="日期"></asp:BoundColumn>
<asp:BoundColumn DataField="cID" SortExpression="cba" HeaderText="客户名称"></asp:BoundColumn>
<asp:BoundColumn DataField="auID"></asp:BoundColumn>
<asp:BoundColumn DataField="qaState" HeaderText="状态"></asp:BoundColumn>
</Columns>

[sra]

我设置了呀！

<Columns>
<asp:BoundColumn DataField="qaID" HeaderText="ID"></asp:BoundColumn>
<asp:BoundColumn DataField="pID" HeaderText="产品类别"></asp:BoundColumn>
<asp:BoundColumn DataField="qaTechnicSort" SortExpression="abc" HeaderText="问题类别"></asp:BoundColumn>
<asp:BoundColumn DataField="qaDate" HeaderText="日期"></asp:BoundColumn>
<asp:BoundColumn DataField="cID" SortExpression="cba" HeaderText="客户名称"></asp:BoundColumn>
<asp:BoundColumn DataField="auID"></asp:BoundColumn>
<asp:BoundColumn DataField="qaState" HeaderText="状态"></asp:BoundColumn>
</Columns>

[sra]

问题解决了。

并不是空值，只不过我是在if not isPostBack里显示的，没有触发罢了