expanding add member section

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,

Re: expanding add member section

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.

Re: expanding add member section

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

Re: expanding add member section

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.

Re: expanding add member section

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

Re: expanding add member section

Did you add the MailDefination element in the CreateUserWizerd to automatically

email new registered members, their Login credentials after creating new accounts?

Re: expanding add member section

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.

Re: expanding add member section

The problem with my membership_list.aspx was null data in the tables.
Fixed that and it is fine.