I'm using the clubsite starter on a remote host, and I'd like to expand on the amount of information that is saved to the table. I've used the scripts to create the tables, and everything works great.
I'm curious as to how I can add another step or two to the registration process. I was going to try to manipulate the XSD, but in order to do that I need access to the db, and they don't allow remote access.
Wondering where to go from here. Thinking of installing sql express on my local machine, point to it, make all the changes, then change the connection string back to the remote one and upload everything.
Could someone please point me in the right direction. I'd like to just add a few things to a page for a member to put in additional info. Thought of changing Member_Details.aspx.
I am also interested in doing this. I have thought about adding an additional table with a similar structure to the members info table, that way I wouldn't have to "disturb" the delivered table.....
I welcome any other ideas if someone has actually done this.
I did add a few registration details, but I didn't add any steps in the CreateUserWizard. It did require modifying the MemberInfo table and modifying the DataSet.xsd files to update the SELECT statements, etc. I am able to access my remote SQL Server by using
SQL Server Management Studio Express.
I also wanted to update the member info table. With the assistance of Jeff - I did it in about 45 min and I am real new at this stuff.
As U progress, U should see some errors pop up, but these should start to go away as U update each page.
Here is what I did – I did NOT use the wizard, but manually changed the code..
Open memberinfo table in SQL Server Management Studio Express and added a field called "UnitNo"
In DataSet.xsd
I looked all through this for the field named "Phone".
Duplicated the fields or lines and changed "phone" to "UnitNo"
In the MemberDetails.vb
added the following at the end (copy from another above): Private m_UnitNo AsString
PublicReadOnlyProperty UnitNo()
AsString
Get
Return m_UnitNo EndGet
EndProperty
In the PrivateSubNew(ByVal user
As MembershipUser, ByVal member
As DataSet.MemberInfoRow)
Added
m_UnitNo = member.UnitNo below m_Phone = member.phone
In the Member_Register.aspx add unitno to the line
da.Insert(CType(user.ProviderUserKey, Guid), Addr.Text, Phone.Text, fname.Text, lname.Text, UnitNo.text)
In the wizard, look for <tr>
<tdclass="formlabel">
<labelfor="Phone"> Phone:</label>
</td>
<tdclass="formvalue">
<asp:TextBoxrunat="server"
ID="Phone"CssClass="txtfield"/>
</td>
</tr>
Add the following right after:
<tr>
<tdclass="formlabel">
<labelfor="UnitNo"> UnitNo:</label>
</td>
<tdclass="formvalue">
<asp:TextBoxrunat="server"
ID="UnitNo"CssClass="txtfield"/>
</td>
</tr>
In Member_Details.aspx
Added UnitNo in the line
da.Update(CType(user.ProviderUserKey, Guid), Addr.Text, Phone.Text, fname.Text, lname.Text, UnitNo.Text, CType(user.ProviderUserKey, Guid))
in Sub InitPageData()
added UnitNo.Text = mr.UnitNo
Added a label and text box below lastname (anywhere)
<tr>
<tdclass="formlabel">
<labelfor="UnitNo">
Unit Number:</label>
</td>
<td>
Yes, but did not include this as was keeping thread for expanding User Info
My site is a little different, limited users, so by default users are NOT authorized.
I force new users to register, the registration process sends WebHost an email, I approve (manually at the moment), process will email back user when they are approved for access to site.
Only specific users (owners) can join
To do this, I had to make some changes in web.config and member_register.aspx
member_register.aspx (replace YOURDOMAIN with your info)
For the message body, I have it in a file called ApplicationComplete.txt
Add the following near the very bottom of the code
<MailDefinition
CC=Webhost@YOURDOMAIN.com
From=Webhost@YOURDOMAIN.com
Priority="High"
Subject="New Owner - Require Activation"
IsBodyHtml =
True
BodyFileName="Files/ApplicationComplete.txt">
</MailDefinition>
ravensensei
Member
294 Points
115 Posts
expanding add member section
Sep 04, 2006 05:28 PM|LINK
I'm using the clubsite starter on a remote host, and I'd like to expand on the amount of information that is saved to the table. I've used the scripts to create the tables, and everything works great.
I'm curious as to how I can add another step or two to the registration process. I was going to try to manipulate the XSD, but in order to do that I need access to the db, and they don't allow remote access.
Wondering where to go from here. Thinking of installing sql express on my local machine, point to it, make all the changes, then change the connection string back to the remote one and upload everything.
Is there an easier way to do it?
thx,
M@
ravensensei
Member
294 Points
115 Posts
Re: expanding add member section
Sep 06, 2006 03:01 AM|LINK
dhconsult
Member
100 Points
20 Posts
Re: expanding add member section
Sep 07, 2006 01:13 AM|LINK
I am also interested in doing this. I have thought about adding an additional table with a similar structure to the members info table, that way I wouldn't have to "disturb" the delivered table.....
I welcome any other ideas if someone has actually done this.
Thanks,
-Doug
Jeff2005
Member
65 Points
13 Posts
Re: expanding add member section
Sep 28, 2006 01:30 PM|LINK
ken240
Member
125 Points
25 Posts
Re: expanding add member section
Sep 28, 2006 09:28 PM|LINK
Hi all
I also wanted to update the member info table. With the assistance of Jeff - I did it in about 45 min and I am real new at this stuff.
As U progress, U should see some errors pop up, but these should start to go away as U update each page.
Here is what I did – I did NOT use the wizard, but manually changed the code..
Open memberinfo table in SQL Server Management Studio Express and added a field called "UnitNo"
In DataSet.xsd
I looked all through this for the field named "Phone".
Duplicated the fields or lines and changed "phone" to "UnitNo"
In the MemberDetails.vb
added the following at the end (copy from another above):
Private m_UnitNo As String
Public ReadOnly Property UnitNo() As String
Get
Return m_UnitNo
End Get
End Property
In the Private Sub New(ByVal user As MembershipUser, ByVal member As DataSet.MemberInfoRow)
Added
m_UnitNo = member.UnitNo below m_Phone = member.phone
In the Member_Register.aspx
add unitno to the line
da.Insert(CType(user.ProviderUserKey, Guid), Addr.Text, Phone.Text, fname.Text, lname.Text, UnitNo.text)
In the wizard, look for
<tr>
<td class="formlabel">
<label for="Phone">
Phone:</label>
</td>
<td class="formvalue">
<asp:TextBox runat="server" ID="Phone" CssClass="txtfield" />
</td>
</tr>
Add the following right after:
<tr>
<td class="formlabel">
<label for="UnitNo">
UnitNo:</label>
</td>
<td class="formvalue">
<asp:TextBox runat="server" ID="UnitNo" CssClass="txtfield" />
</td>
</tr>
In Member_Details.aspx
Added UnitNo in the line
da.Update(CType(user.ProviderUserKey, Guid), Addr.Text, Phone.Text, fname.Text, lname.Text, UnitNo.Text, CType(user.ProviderUserKey, Guid))
in Sub InitPageData()
added UnitNo.Text = mr.UnitNo
Added a label and text box below lastname (anywhere)
<tr>
<td class="formlabel">
<label for="UnitNo">
Unit Number:</label>
</td>
<td>
<asp:TextBox runat="server" ID="UnitNo" CssClass="txtfield" />
</td>
</tr>
Hope I have NOT missed anything
papalolo22
Member
119 Points
37 Posts
Re: expanding add member section
Sep 29, 2006 02:51 AM|LINK
Did you add the MailDefination element in the CreateUserWizerd to automatically
email new registered members, their Login credentials after creating new accounts?
ken240
Member
125 Points
25 Posts
Re: expanding add member section
Sep 29, 2006 03:12 AM|LINK
Yes, but did not include this as was keeping thread for expanding User Info
My site is a little different, limited users, so by default users are NOT authorized.
I force new users to register, the registration process sends WebHost an email, I approve (manually at the moment), process will email back user when they are approved for access to site.
Only specific users (owners) can join
To do this, I had to make some changes in web.config and member_register.aspx
member_register.aspx (replace YOURDOMAIN with your info)
For the message body, I have it in a file called ApplicationComplete.txt
Add the following near the very bottom of the code
<MailDefinition
CC=Webhost@YOURDOMAIN.com
From=Webhost@YOURDOMAIN.com
Priority="High"
Subject="New Owner - Require Activation"
IsBodyHtml = True
BodyFileName="Files/ApplicationComplete.txt">
</MailDefinition>
web.config
<system.net>
<mailSettings>
<smtp from=webhost@YOURDOMAIN.com>
<network host="mail.YOURDOMAIN.com" password="your PW" userName=webhost@YOURDOMAIN.com />
</smtp>
</mailSettings>
</system.net>
Heads UP
Looks like I messed up something
The members_list.aspx is not working now :(
Looking into the issue now.
ken240
Member
125 Points
25 Posts
Re: expanding add member section
Sep 29, 2006 05:24 AM|LINK
The problem with my membership_list.aspx was null data in the tables.
Fixed that and it is fine.