getting the user's password in clear text... - Extend It! ( Programming in VS2003, ASP.Net 1.1 )

Forum General DotNetN... Extend It! ( Pr... getting the user's password in clear text...

3/2/2006 7:42 AM

	Rob Morrow
23 posts
www.deviant-tuning.com

getting the user's password in clear text...

i know this is a dumb question, but perhaps someone can answer it for me. i've written a stored procedure and tied the output to a datagrid, like so...


                Dim ProgramID As Integer = CType(ddlSearchPrograms.SelectedValue, Integer)
                Dim ds As DataSet = ExportUsersController.ExportUsersGetUsers(ProgramID)
                dgUserGrid.DataSource = ds
                dgUserGrid.DataBind()

the stored procedure brings back a list of users for a specific portal. what i also want to do is tap into the dnn users catalog to retrieve the password for these same users, like so...


            Dim oUsers As New UserController
            Dim oUser As UserInfo = oUsers.GetUser(portalID, userID)
            Me.Password = oUser.Membership.Password

so i'm curious as to how to tie the two datasets together so that the password matches up with the correct user in the original grid?

thanks in advance.

3/2/2006 12:30 PM

	Rob Morrow
23 posts
www.deviant-tuning.com

Re: getting the user's password in clear text...

okay, so i've tried something new...


                Dim ProgramID As Integer = CType(ddlSearchPrograms.SelectedValue, Integer)
                Dim ds As DataSet = ExportUsersController.ExportUsersGetUsers(ProgramID)
                'Dim dt As DataTable = CType(ExportUsersController.ExportUsersGetUsers(ProgramID), IDataReader)
                Dim getPassword As New ExportUsersController
                Dim strGetPassword As String = getPassword.ExportUsersGetUserPassword(ds)
                dgUserGrid.DataSource = ds
                dgUserGrid.DataBind()

so basically, it creates a dataset and then feeds that dataset over to this function...


        Public Shared Function ExportUsersGetUserPassword(ByRef ds As DataSet) As String
            For Each row As DataRow In ds.Tables(0).Rows
                
            Next
        End Function

and as much as i hate to say it, i believe i'm lost now... lol. i know that i want to take the portalid and userid from each row of the table in the dataset and pass it over to retrieve the password for that particular row (user). once it's finished, i can attach it as a new column in the dataset and finally attach that dataset to the datagrid. make sense?

any help to this would be greatly appreciated. thanks in advance.

3/2/2006 2:41 PM

	Paul Davis
615 posts
www.phdavis.com

Re: getting the user's password in clear text...

I wouldn't try to combine the two datasets in vb code. I would just write my original sproc using joins and return one dataset with all the information you need.

Paul Davis

3/3/2006 8:06 AM

	Rob Morrow
23 posts
www.deviant-tuning.com

Re: getting the user's password in clear text...

thanks for the response. i've actually found a way to get the password programatically by using a class structure (i'm really no good at explaining this stuff)...


            Dim oar As New ArrayList
            For Each row As DataRow In obDT.Rows
                Dim portalid As Integer = CInt(row("portalid"))
                Dim userid As Integer = CInt(row("UserID"))
                Dim lastname As String = CStr(row("LastName"))
                Dim firstname As String = CStr(row("FirstName"))
                Dim username As String = CStr(row("UserName"))
                Dim rolename As String = CStr(row("RoleName"))
                Dim email As String = CStr(row("Email"))
                Dim oUsers As New UserController
                Dim oUser As UserInfo = oUsers.GetUser(portalid, userid)
                Dim Password As String = oUser.Membership.Password
                Dim ostUser As New stUserPass
                ostUser.Password = Password
                ostUser.UserID = userid
                ostUser.PortalID = portalid
                ostUser.LastName = lastname
                ostUser.FirstName = firstname
                ostUser.Email = email
                ostUser.RoleName = rolename
                ostUser.Username = username
                oar.Add(ostUser)
            Next
            Return oar

now, however, i find myself in need of converting an arraylist to a dataset. if i can do that, i'd be in heaven. i appreciate the help thus far. thanks in advance.

3/3/2006 3:36 PM

	Paul Davis
615 posts
www.phdavis.com

Re: getting the user's password in clear text...

The only way I can really think of to do that off the top of my head is to just loop through the arraylist inserting into the dataset

Paul Davis

Page 1 of 2

Forum

General DotNetN...

Extend It! ( Pr...

getting the user's password in clear text...