动态绑定datagrid,点击列头进行排序显示一片空白,大家帮帮忙啊!!!!!!!!!!!
绑定datagrid的代码
col = New BoundColumn
col.DataField = "order_date"
col.HeaderText = "订货日期"
col.SortExpression = "order_date"
col.ItemStyle.HorizontalAlign = HorizontalAlign.Right
DataGrid1.Columns.Add(col)
排序代码
Private Sub MySort()
Dim thisSortField, thisMode As String
Dim conn As New SqlClient.SqlConnection(sysConfig.ConStr)
Dim myDataAdapter As New SqlClient.SqlDataAdapter
thisSortField = Me.DataGrid1.Attributes("SortExpression")
thisMode = Me.DataGrid1.Attributes("SortDirection")
Dim dv As New DataView
Dim ds As New DataSet
strsql="select * from 表"
myDataAdapter = New SqlClient.SqlDataAdapter(strsql, conn)
myDataAdapter.Fill(ds)
dv = ds.Tables(0).DefaultView
dv.Sort = thisSortField + " " + thisMode
Me.DataGrid1.DataSource = dv
Me.DataGrid1.DataBind()
End Sub
DataGrid1_SortCommand事件的代码
Dim SortField As String
SortField = e.SortExpression.ToString
Me.DataGrid1.Attributes("SortExpression") = SortField
If Me.DataGrid1.Attributes("SortDirection") = "ASC" Then
Me.DataGrid1.Attributes("SortDirection") = "DESC"
Else
Me.DataGrid1.Attributes("SortDirection") = "ASC"
End If
MySort()
我点击完列头根本就不触发DataGrid1_SortCommand事件,怎么回事呀???????????在线等