ItemInserting or ItemInserted?

rmanapul · August 29th, 2012, 04:41 AM

what will i do to make the dropdownlist values change after i insert a new data in a details view? ItemInserting or ItemInserted?

Code:

Imports AlumniTblModel
Partial Class Management_Sample
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load
        Using myEntities As New AlumniTblEntities

            Dim allProvinces = From province In myEntities.ProvinceTbls
                               Order By province.Province
                               Select province.Province




            ProvinceGrid.DataSource = allProvinces
            ProvinceGrid.DataBind()
            ProvinceGrid.HeaderRow.Cells(0).Text = "Provinces"

        End Using
    End Sub

    Protected Sub DetailsView1_ItemInserted(sender As Object, e As System.Web.UI.WebControls.DetailsViewInsertedEventArgs) Handles DetailsView1.ItemInserted

        Using myEntities As New AlumniTblEntities

            Dim allProvinces = From province In myEntities.ProvinceTbls
                               Order By province.Province
                               Select province.Province



            If Not IsPostBack Then
                With ProvinceDdl
                    .DataValueField = "Province"
                    .DataTextField = "Province"
                    .DataSource = allProvinces
                End With
                DataBind()

            End If

        End Using

    End Sub

End Class

I used both ItemInserting and ItemInserted but the DropDownList Control values does not update unless you close the browser and re-run the application again.

Imar · August 29th, 2012, 05:28 AM

I have no idea what you're asking. Sorry.

Also, since this is not directly related to my book, please post questions like these in a general ASP.NET catergory from this list: http://p2p.wrox.com/asp-net-4-539/

heers,

Imnar

rmanapul · August 30th, 2012, 02:58 AM

yes it is related on your book sir. Im using the things i learned from chapter 13 page 459 under the title Using DetailsView to Insert and Update Data.

Imar · August 30th, 2012, 03:17 AM

But I still don't understand the question.... ;-)

Maybe it's the check for IsPostBack? That returns true in the ItemInserted event.

Also, consider moving code like this to a sub or function. The stuff in Load and ItemIsnerted is almost the same, forcing you to code and maintain similar code in multiple locations.

Cheers,

Imar

rmanapul · August 30th, 2012, 03:37 AM

what i mean is this. if i entered a data in the detailsview, the dropdownlist control which display the data inserted using the detailsview should be updated after i insert the data. but it seems not it. i have to close the browser, and re run the application again to see if the data is added in the drop down list

Imar · August 30th, 2012, 03:40 AM

Hence my remark: Maybe it's the check for IsPostBack? That returns true in the ItemInserted event. You're not rebinding the drop down list in ItemInserted.

Debug your page and break into ItemInserted to see what I mean....

Imar

rmanapul · August 30th, 2012, 04:03 AM

can you suggest some things how to do rebinding in the dropdownlist after a data has been inserted? i don't know about the load function. and is there a refresh function for dropdownlist?

Imar · August 30th, 2012, 04:05 AM

You're doing the right thing; you just need to remove the check for IsPostback. With Load, I was referring to Page_Load.

FWIIW: all of this is taken care off if you use the data-source controls. I still haven't seen a compelling reason to do all of this in code. More work, more maintenance, while, IMO, it doesn't add much value here.

Cheers,

Imar

rmanapul · August 30th, 2012, 04:15 AM

yeah im doing this all in hard coding LINQ to Entities for me to learn more of it in coding practice.

rmanapul · August 30th, 2012, 04:42 AM

thanks i found a solution by using this code:

Code:

Imports AlumniTblModel
Partial Class Management_Sample
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load
        Using myEntities As New AlumniTblEntities

            Dim allProvinces = From province In myEntities.ProvinceTbls
                               Order By province.Province
                               Select New With {province.Province}




            ProvinceGrid.DataSource = allProvinces
            ProvinceGrid.DataBind()
            ProvinceGrid.HeaderRow.Cells(0).Text = "Provinces"

            ProvinceDdl.DataSource = allProvinces
            ProvinceDdl.DataValueField = "Province"
            ProvinceDdl.DataTextField = "Province"
            ProvinceDdl.DataBind()



        End Using
    End Sub

    Protected Sub DetailsView1_ItemInserted(sender As Object, e As System.Web.UI.WebControls.DetailsViewInsertedEventArgs) Handles DetailsView1.ItemInserted
        Using myEntities As New AlumniTblEntities

            Dim allProvinces = From province In myEntities.ProvinceTbls
                               Order By province.Province
                               Select New With {province.Province}




            ProvinceGrid.DataSource = allProvinces
            ProvinceGrid.DataBind()
            ProvinceGrid.HeaderRow.Cells(0).Text = "Provinces"

            ProvinceDdl.DataSource = allProvinces
            ProvinceDdl.DataValueField = "Province"
            ProvinceDdl.DataTextField = "Province"
            ProvinceDdl.DataBind()



        End Using
    End Sub
End Class

it works perfectly now :)