ASP.NET

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)