Hi,
I have a basic datagrid that I wish to make editable, I want to be
able to edit,update and scroll through the records page by page. When
I click the edit button the page just reloads, can someone tell me
what I am missing from my code?
Sean - thanks in advance for your answer
!--- snippet
<script language="vb" runat="server">
Sub Page_Load(sender as Object, e as EventArgs)
BindData()
End Sub
Sub BindData()
Dim myConnection as New SqlConnection
(ConfigurationSettings.AppSettings("connectionString"))
Const strSQL as String = "SELECT listingID, formname,Listeddate
FROM tblListings ORDER BY Listeddate"
Dim myCommand as New SqlCommand(strSQL, myConnection)
Dim myAdapter as New SqlDataAdapter(myCommand)
Dim ds as New DataSet()
myAdapter.Fill(ds)
dgModifyListing.DataSource = ds
dgModifyListing.DataBind()
myConnection.Close()
End Sub
Sub dgModifyListing_Edit(sender As Object, e As
DataGridCommandEventArgs)
Dim intCustomer as Integer = e.Item.Cells(1).Text
dgModifyListing.EditItemIndex =
e.Item.ItemIndex
BindData()
End Sub
Sub dgModifyListing_Update(sender As Object, e As
DataGridCommandEventArgs)
Dim intCustomer as Integer = e.Item.Cells(1).Text
dgModifyListing.EditItemIndex =
e.Item.ItemIndex
BindData()
End Sub
Sub NewPage(sender As Object, e As DataGridPageChangedEventArgs)
dgModifyListing.CurrentPageIndex = e.NewPageIndex
BindData()
End Sub
</script>
<form runat="server">
<asp:DataGrid runat="server" id="dgModifyListing"
BackColor="#eeeeee" Width="85%"
HorizontalAlign="Center"
Font-Name="Verdana"
Font-Size="10pt"
AllowPaging="True"
OnPageIndexChanged="NewPage"
OnEditCommand="dgModifyListing_Edit"
OnUpdateCommand="dgModifyListing_Update">
<HeaderStyle BackColor="Black" ForeColor="White" Font-
Bold="True" HorizontalAlign="Center" />
<AlternatingItemStyle BackColor="White" />
<PagerStyle NextPageText="Next -->" PrevPageText="<--
Prev."
HorizontalAlign="Right" />
<columns>
<asp:EditCommandColumn EditText="Edit Info"
ButtonType="PushButton"
UpdateText="Update"/>
<asp:BoundColumn HeaderText="listingID"
DataField="listingID"/>
<asp:BoundColumn HeaderText="formname"
DataField="formname" />
<asp:BoundColumn HeaderText="formname"
DataField="listeddate" />
</columns>
</asp:datagrid>
</form>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Yahoo! Domains - Claim yours for only $14.70
http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
