two simple questions - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

ASP.NET

two simple questions

Author

Topic

jhermiz

3564 Posts

Posted - 2004-09-27 : 14:29:11

I am creating a profile page and just reading the current users info..to fill in the text fields and drop down lists.

Two questions when I try to pull back the password and set its text property nothing shows up. IN the debugger I see the password but when I do:


        If Not IsDBNull(reader("Password")) Then
                txtPassword.Text = reader("Password")
                txtConfirmPassword.Text = reader("Password")
            End If

It sets the password but on the screen you dont see it (not even with the little * marks to hide the password.

My second question is lets say I have a ddl (Drop Down List)
and the datavaluefield is an integer say, and the text value is a string...

If I do:

Me.ddlClient.DataValueField = reader("ClientID")
Me.ddlFunctionalGroup.DataValueField = reader("FunctionalGroupID")
Me.ddlRepresentative.DataValueField = reader("Representative")

It doesnt work...it doesnt change the defaults or what not. how do I assign the values in the database back to the drop down lists?

Thanks,
Jon

MichaelP
Jedi Yak

2489 Posts

Posted - 2004-09-27 : 14:45:39

1. I don't think you can set the value of a "password" style textbox. It's how the HTML works.

2. DataValueField is looking for the name of the field in a dataset / hashtable / etc that contains the data in question.
To select a field in the drop down, here's how I do it:


'Populate User Type Drop Down
        ddEditUserType.DataSource = oUser.GetUserTypesByUser(Session("UserID"))
        ddEditUserType.DataValueField = "DashboardUserTypeID"
        ddEditUserType.DataTextField = "UserTypeName"
        ddEditUserType.DataBind()

ddEditUserType.Items.FindByValue(Row("DashboardUserTypeID")).Selected = True

Needless to say the last line is key.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>

jhermiz

3564 Posts

Posted - 2004-09-27 : 14:58:48

Thank You so much Mike,

I just got to figure out the password part otherwise they have to always reenter and confirm their passwords :(.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources