ASP.NET

<br />
<small>msUserName = Request.QueryString.Get("username");<br />
            <br />
LabelUserName.Text = msUserName;<br />
UserName.Value = msUserName;<br />
moMembershipUser = Membership.GetUser(msUserName);<br />
<br />
msEmailAddress = moMembershipUser.Email;<br />
            <br />
moSqlConnection = new SqlConnection();<br />
moSqlConnection.ConnectionString = ConfigurationManager.ConnectionStrings["AppSqlServer"].ConnectionString;<br />
<br />
moSqlCommand = new SqlCommand();<br />
moSqlCommand.CommandText = "SELECT * From tblUserInfo WHERE UserID = @UserID ";<br />
moSqlCommand.CommandType = CommandType.Text;<br />
moSqlCommand.Connection = moSqlConnection;<br />
            <br />
// UserID Parameter<br />
moSqlParameterUser = new SqlParameter();<br />
moSqlParameterUser.ParameterName = "@UserID";<br />
moSqlParameterUser.SqlDbType = SqlDbType.UniqueIdentifier;<br />
moSqlParameterUser.Direction = ParameterDirection.Input;<br />
moSqlParameterUser.Value = new Guid(moMembershipUser.ProviderUserKey.ToString());<br />
            <br />
moSqlCommand.Parameters.Add(moSqlParameterUser);<br />
moSqlCommand.Connection.Open();<br />
<br />
moSqlDataReader = moSqlCommand.ExecuteReader(CommandBehavior.CloseConnection);<br />
<br />
moDataTable = new DataTable();<br />
moDataTable.Load(moSqlDataReader);<br />
<br />
if (moDataTable.Rows.Count == 0){<br />
      msFirstName = "";<br />
      msLastName = "";<br />
}else{<br />
      moDataTable.PrimaryKey = new DataColumn[] { moDataTable.Columns["UserID"] };<br />
      msFirstName = moDataTable.Rows.Find("FirstName");<br />
      msLastName = moDataTable.Rows.Find("LastName");<br />
}<br />
<br />
FirstName.Text = msFirstName;<br />
LastName.Text = msLastName;<br />
EmailAddress.Text = msEmailAddress;<br />
            <br />
moDataTable.Dispose();<br />
moSqlCommand.Dispose();<br />
moSqlConnection.Dispose();</small>