ASP.NET

<%@ Page Language="C#" AutoEventWireup="true" <br />
MasterPageFile="~/MasterPage.master"<br />
CodeFile="Register.aspx.cs"<br />
Inherits="Login_Register"<br />
Title="User Registration" %><br />
<asp:Content ID="Content1" Runat="Server" <br />
ContentPlaceHolderID="ContentPlaceHolder1" ><br />
<asp:CreateUserWizard ID="CreateUserWizard1" <br />
runat="server"<br />
ContinueDestinationPageUrl="~/Default.aspx"<br />
CreateUserButtonText="Create Account"><br />
<WizardSteps> <br />
<asp:CreateUserWizardStep<br />
ID="CreateUserWizardStep1" runat="server"><br />
</asp:CreateUserWizardStep><br />
<asp:CompleteWizardStep<br />
ID="CompleteWizardStep1" runat="server"><br />
</asp:CompleteWizardStep><br />
</WizardSteps><br />
<MailDefinition <br />
From="Admin@AcmePirate.com"<br />
Subject="Your New Acme Pirate Account"<br />
BodyFileName="~/Login/NewUser.txt" /><br />
</asp:CreateUserWizard><br />
</asp:Content>

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
     Dim conn As New Data.SqlClient.SqlConnection
     conn.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\BoultData.mdf;Integrated Security=True;User Instance=True"
     Dim cmd As New Data.SqlClient.SqlCommand
     With cmd
         .Connection = conn
         .CommandType = Data.CommandType.StoredProcedure
         .CommandText = "TaskSelect"
         .Parameters.Add(New Data.SqlClient.SqlParameter("@UserName", Data.SqlDbType.NVarChar, 50))
         .Parameters("@UserName").Value = System.Web.Security.Membership.GetUser.UserName
     End With

     conn.Open()
     cmd.ExecuteNonQuery()

ALTER PROCEDURE TaskSelect

@UserName varchar(50)


AS

Select * from Tasks
where (username = @username)