How to populate more than one column using executescalar?
<p>I am new to c#.Here i am getting one column using execute scalar</p>

<pre><code> cmd.commandtext = "select rodeuser from customer_db_map";
    string rodecustomer = cmd.executescalar;
</code></pre>

<p>But i need to get more than one column like</p>

<pre><code> cmd.commandtext = "select rodeuser,username,password from customer_db_map";
</code></pre>

<p>i need to get every single column in a string like </p>

<pre><code> string rodecustomer = cmd.executescalar;
 string username= cmd.executescalar;
 string password = cmd.executescalar;
</code></pre>

<p>But it is not possible.How to get these things.any suggestion?</p>
