My datagrid sorting feature isn't working. The titles in my datagrid are not underlined for sorting. What am I doing wrong??
Here is my code
<HEAD>
<title>Lets give it a try</title>
<script runat="server">
Public Sub Page_Load(Source as Object, E As EventArgs)
if Not Page.IsPostBack Then
BindData( "Name" )
End If
End Sub
Public Sub BindData( strSortField As String)
Dim myDataSet as New DataSet
Dim mySqlDataAdapter as SqlDataAdapter
mySqlDataAdapter = New SqlDataAdapter( _
"SELECT * FROM Person order by " & strSortField, _
"server=AM1ST_FS1;database=HRINFO;uid=sa;"
mySqlDataAdapter.Fill(myDataSet, "Person"
PersonInfo.DataSource = myDataSet.Tables("Person"
PersonInfo.DataBind()
End Sub
public Sub DataGrid_Sort(Source As Object, E As DataGridSortCommandEventArgs)
BindData( E.SortExpression )
End Sub
Public Sub DataGrid_Edit(Source As Object, E As DataGridCommandEventArgs)
personInfo.EditItemIndex= E.Item.ItemIndex
BindData( "Name" )
End Sub
Public Sub DataGrid_Cancel(Source As Object, E As DataGridCommandEventArgs)
personInfo.EditItemIndex = -1
BindData( "Name" )
End Sub
Public Sub DataGrid_Update(Source As Object, E As DataGridCommandEventArgs)
Dim myConnection As SqlConnection
Dim myCommand As SqlCommand
Dim txtName As Textbox = E.Item.Cells(2).Controls(0)
Dim txtAddress As Textbox = E.Item.Cells(3).Controls(0)
Dim strUpdateStmt As String
strUpdateStmt = "UPDATE Person SET Name = '" & txtName.Text & "', Address = '" & txtAddress.Text & "' WHERE ID = " & E.Item.Cells(1).Text
myConnection = New SqlConnection("server=AM1ST_FS1;database=HRINFO;uid=sa"
myCommand = new SqlCommand(strUpdateStmt, myConnection)
myConnection.open()
myCommand.ExecuteNonQuery()
personInfo.EditItemIndex = -1
BindData( "Name" )
End Sub
</script>
</HEAD>
<body>
<form id="Form1" method="post" runat="server">
<h3>Editing Records in The DataGrid</h3>
<aspataGrid id="PersonInfo" Runat="server"
AllowSorting="True"
AlternatingItemStyle-BackColor="#A6F4FD"
AutoGeneratecolumns="false"
onEditCommand="DataGrid_Edit"
onCancelCommand="DataGrid_Cancel"
onUpdateCommand="DataGrid_Update"
onSortCommand="DataGrid_Sort">
<columns>
<asp:editcommandcolumn
ButtonType="LinkButton"
CancelText="Cancel"
editText="Edit"
UpdateText="Update" />
<asp:boundcolumn
DataField="ID"
HeaderText="ID"
ReadOnly="true" />
<asp:boundcolumn
DataField="Name"
HeaderText="Name" />
<asp:boundcolumn
DataField="Address"
HeaderText="Address" />
</columns>
</aspataGrid>
</form>
</body>
</HTML>
Here is my code
<HEAD>
<title>Lets give it a try</title>
<script runat="server">
Public Sub Page_Load(Source as Object, E As EventArgs)
if Not Page.IsPostBack Then
BindData( "Name" )
End If
End Sub
Public Sub BindData( strSortField As String)
Dim myDataSet as New DataSet
Dim mySqlDataAdapter as SqlDataAdapter
mySqlDataAdapter = New SqlDataAdapter( _
"SELECT * FROM Person order by " & strSortField, _
"server=AM1ST_FS1;database=HRINFO;uid=sa;"
mySqlDataAdapter.Fill(myDataSet, "Person"
PersonInfo.DataSource = myDataSet.Tables("Person"
PersonInfo.DataBind()
End Sub
public Sub DataGrid_Sort(Source As Object, E As DataGridSortCommandEventArgs)
BindData( E.SortExpression )
End Sub
Public Sub DataGrid_Edit(Source As Object, E As DataGridCommandEventArgs)
personInfo.EditItemIndex= E.Item.ItemIndex
BindData( "Name" )
End Sub
Public Sub DataGrid_Cancel(Source As Object, E As DataGridCommandEventArgs)
personInfo.EditItemIndex = -1
BindData( "Name" )
End Sub
Public Sub DataGrid_Update(Source As Object, E As DataGridCommandEventArgs)
Dim myConnection As SqlConnection
Dim myCommand As SqlCommand
Dim txtName As Textbox = E.Item.Cells(2).Controls(0)
Dim txtAddress As Textbox = E.Item.Cells(3).Controls(0)
Dim strUpdateStmt As String
strUpdateStmt = "UPDATE Person SET Name = '" & txtName.Text & "', Address = '" & txtAddress.Text & "' WHERE ID = " & E.Item.Cells(1).Text
myConnection = New SqlConnection("server=AM1ST_FS1;database=HRINFO;uid=sa"
myCommand = new SqlCommand(strUpdateStmt, myConnection)
myConnection.open()
myCommand.ExecuteNonQuery()
personInfo.EditItemIndex = -1
BindData( "Name" )
End Sub
</script>
</HEAD>
<body>
<form id="Form1" method="post" runat="server">
<h3>Editing Records in The DataGrid</h3>
<asp
ataGrid id="PersonInfo" Runat="server"AllowSorting="True"
AlternatingItemStyle-BackColor="#A6F4FD"
AutoGeneratecolumns="false"
onEditCommand="DataGrid_Edit"
onCancelCommand="DataGrid_Cancel"
onUpdateCommand="DataGrid_Update"
onSortCommand="DataGrid_Sort">
<columns>
<asp:editcommandcolumn
ButtonType="LinkButton"
CancelText="Cancel"
editText="Edit"
UpdateText="Update" />
<asp:boundcolumn
DataField="ID"
HeaderText="ID"
ReadOnly="true" />
<asp:boundcolumn
DataField="Name"
HeaderText="Name" />
<asp:boundcolumn
DataField="Address"
HeaderText="Address" />
</columns>
</asp
ataGrid></form>
</body>
</HTML>
