using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient;
using System.Web.Configuration;
 
  public partial class myCVSummary : System.Web.UI.Page
  {
      DataTable dtResult;
      MembershipUser currentUser;
      Guid myID = new Guid();
 
      protected void Page_Load(object sender, EventArgs e)             
      { 
          currentUser = Membership.GetUser(myID); 
 
          if (!IsPostBack)
          {   
              //I’m having difficulty with statement:             
              dtResult = GetmyInfo(this.Request["id"].ToString());
 
              if (dtResult.Rows.Count > 0)
 
              {
 
                  //Basic Information
                  mTitle.InnerText = dtResult.Rows[0]["SALUTATION"].ToString();
                  mFirstName.InnerText = dtResult.Rows[0]["FIRST_NAME"].ToString();
                  mLastName.InnerText = dtResult.Rows[0]["LAST_NAME"].ToString();
                  mSuffix.InnerText = dtResult.Rows[0]["DESIGNATION"].ToString();
                  mGender.InnerText = dtResult.Rows[0]["GENDER"].ToString();
                  mCitizenship.InnerText = dtResult.Rows[0]["CITIZENSHIP"].ToString();
 
 
              }                            
          }
      }
 
      private DataTable GetmyInfo(string myInfoId)
      {
          SqlConnection sqlConn;
          SqlCommand sqlCmd;
          SqlDataAdapter sqlDA;
          DataTable dtResult = new DataTable("Result");
          string cmdText = String.Empty;
          cmdText = " SELECT *  FROM myDatabaseTable WHERE (P_USERID = '" + myInfoId + "')";
          try
          {
              ConnectionStringSettings connString = WebConfigurationManager.ConnectionStrings["myConnectionString"];
              if (null != connString)
              {
                  using (sqlConn = new SqlConnection(connString.ConnectionString))
                  {
                      sqlCmd = new SqlCommand(cmdText, sqlConn);
                      sqlDA = new SqlDataAdapter(sqlCmd);
                      sqlDA.Fill(dtResult);
                  }
              }
          }
          catch (Exception ex)
          {
              throw ex;
          }
          return dtResult;
      }
  }