title: asp.net Database return only one value instead of whole set
body: <p>I'm trying to grab information about a particular user from my db: </p>
  
  <pre><code> public string GetUserData()
      {
          string conString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
  
          using (System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(conString))
          {
  
              SqlCommand com = new SqlCommand("SELECT lastName , phoneNo , creditCardNo , dateOfBirth  FROM UserExtendedDataSet WHERE UserId = @UserId", con);
  
              com.Parameters.Add("@UserId", SqlDbType.NVarChar).Value = getUserId();
  
              con.Open();
  
              string result = Convert.ToString(com.ExecuteScalar());
              StatusLabel.Text = result;
              return result;
          }
      }
  </code></pre>
  
  <p>The problem is that it returns only the first table data (in this case lastName), i know that I can write separate queries for each field but I assume this would not be really efficient. </p>
  
  <p>Is there anyway to get this data with one query ? </p>