title: how do i get column value from sql server 2008?
body: <p>i have table where have 5 columns :</p>
  
  <p>i wrote the code like this :</p>
  
  <pre><code>String SQLQuery = "SELECT count(*) FROM aspnet_Users where Username=@uname AND Password = @pwd";
      using(SqlConnection sqlConnection = new SqlConnection(strConnection))
      using(SqlCommand command = new SqlCommand(SQLQuery, sqlConnection))
      {
          sqlConnection.Open();
          command.Parameters.AddWithValue("@uname", Username);
          command.Parameters.AddWithValue("@pwd", Password);
          int result = Convert.ToInt32(command.ExecuteScalar());
          boolReturnValue = (result &gt; 0);
      }
  </code></pre>
  
  <p>here few more extra information i needed,if  above Username and password is correct, 
  what i need is : <strong>userid, and role</strong> column data</p>