Chapter 16, Page 579, Get âUser.Identity.Nameâ

jjjane · March 29th, 2012, 11:17 AM

Hello,

I worked through the chapter 16, page 578 Try It Out. Everything worked fine.

However, I want to use SQLDataSource, not LinqDataSource. If I change to SqlDataSource, I cannot get myPhotoAlbum.UserName which set up as User.Identity.Name.

Would you please help me and let me know how to get “User.Identity.Name when use SqlDataSource?

Thanks a lot.

The NewPhotoAlbum.asps.vb is as below:

Code:

 
Partial Class NewPhotoAlbum
    Inherits BasePage

   

    Protected Sub SqlDataSource1_Inserting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceCommandEventArgs) Handles SqlDataSource1.Inserting

        Dim myPhotoAlbum As PhotoAlbum = CType(e.NewObject, PhotoAlbum)
        myPhotoAlbum.UserName = User.Identity.Name

    End Sub
End Class

The error message is as below:

Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC30456: 'NewObject' is not a member of 'System.Web.UI.WebControls.SqlDataSourceCommandEve ntArgs'.

Source Error:

Line 9:
Line 10: Protected Sub SqlDataSource1_Inserting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceCommandEven tArgs) Handles SqlDataSource1.Inserting
Line 11: Dim myPhotoAlbum As PhotoAlbum = CType(e.NewObject, PhotoAlbum)
Line 12: myPhotoAlbum.UserName = User.Identity.Name
Line 13:

Source File: C:\AttendanceDatebase\Site\NewPhotoAlbum.aspx.vb Line: 11

Imar · March 29th, 2012, 11:22 AM

Hi there,

Take a look at Chapter 12, Page 409 and fiurther. The examples show you how to access the e.Values property inside the Inserting event of the data control (e.g. a DetailsView for example).

An SqlDataSource control is not strongly typed and thus doesn't provide access to something like the UserName property.

What's the reason you don't want to use a LinqDataSource?

Cheers,

Imar

jjjane · March 29th, 2012, 11:35 AM

Hi, Imar,

I am surprised that you answer my question so quick. Thanks you so much.

I feel I am more comfortable with SQL data source. Can I create the Try IT Out at Chaper 12, Page 410 for âAddEditReview.aspxâ with LinqDataSource?

If I can, I do want to try to use LinqDataSource.

Thanks again.

Imar · March 29th, 2012, 11:38 AM

Yes you can; most of the concepts are the same, although the implementation will be slightly different. I'd say: give it a try, and post follow up messages with relevant source code here if you get stuck.

You'll find lots of useful examples in the chapter on LINQ.

Cheers,

Imar

jjjane · March 29th, 2012, 02:43 PM

Imar,

Thanks you so much!

I used e.values, and got user name.