DataGrid Event Order

Source Code

<%@ Page Language="VB" Trace="True" %> <script runat="server"> Sub Page_Load(sender as Object, e as EventArgs) If Not Page.IsPostBack then dgArticles.DataSource = GetArticles("DateAuthored DESC") dgArticles.DataBind() End If Trace.Write("EVENT NOTIFICATION", "Page_Load has fired!") End Sub Function GetArticles(sortBy as String) As System.Data.SqlClient.SqlDataReader Dim connectionString As String = "ConnectionString" Dim sqlConnection As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(connectionString) Dim queryString As String = "SELECT TOP 5 ArticleID, [Articles].[Title], [Articles].[URL], [Articles].[dateAuthored], [Articles"& _ "].[Comments], [Articles].[ClickThroughs] FROM [Articles] ORDER BY " & sortBy Dim sqlCommand As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand(queryString, sqlConnection) sqlConnection.Open Dim dataReader As System.Data.SqlClient.SqlDataReader = sqlCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection) Return dataReader End Function Sub dgArticles_Edit(sender as Object, e as DataGridCommandEventArgs) dgArticles.EditItemIndex = e.Item.ItemIndex dgArticles.DataSource = GetArticles("DateAuthored DESC") dgArticles.DataBind() Trace.Write("EVENT NOTIFICATION", "EditCommand has fired!") End Sub Sub dgArticles_Cancel(sender as Object, e as DataGridCommandEventArgs) dgArticles.EditItemIndex = -1 dgArticles.DataSource = GetArticles("DateAuthored DESC") dgArticles.DataBind() Trace.Write("EVENT NOTIFICATION", "CancelCommand has fired!") End Sub Sub dgArticles_Update(sender as Object, e as DataGridCommandEventArgs) dgArticles.EditItemIndex = -1 dgArticles.DataSource = GetArticles("DateAuthored DESC") dgArticles.DataBind() Trace.Write("EVENT NOTIFICATION", "UpdateCommand has fired!") End Sub </script> <form runat="server"> <p> <asp:DataGrid id="dgArticles" runat="server" AutoGenerateColumns="False" Font-Size="10pt" Font-Names="Verdana" OnEditCommand="dgArticles_Edit" OnUpdateCommand="dgArticles_Update" OnCancelCommand="dgArticles_Cancel"> <HeaderStyle font-size="13pt" font-bold="True" horizontalalign="Center" forecolor="White" backcolor="#006699"></HeaderStyle> <AlternatingItemStyle backcolor="#EEEEEE"></AlternatingItemStyle> <Columns> <asp:EditCommandColumn EditText="Edit" CancelText="Cancel" UpdateText="Update" /> <asp:HyperLinkColumn DataNavigateUrlField="ArticleID" DataNavigateUrlFormatString="/Articles/Goto.aspx?ID={0}" DataTextField="Title" SortExpression="Title" HeaderText="Title"></asp:HyperLinkColumn> <asp:BoundColumn DataField="DateAuthored" SortExpression="dateAuthored DESC" HeaderText="Date Written" DataFormatString="{0:d}"></asp:BoundColumn> <asp:BoundColumn DataField="Comments" HeaderText="Comments"></asp:BoundColumn> <asp:BoundColumn DataField="ClickThroughs" SortExpression="ClickThroughs DESC" HeaderText="Views" DataFormatString="{0:d}" ItemStyle-HorizontalAlign="Center"></asp:BoundColumn> </Columns> </asp:DataGrid> </p> </form>

[Return to the FAQ...]