I am getting one column using ExecuteScalar
:
cmd.commandtext = "select rodeuser from customer_db_map";
string rodecustomer = cmd.executescalar;
But I need to get more than one column, e.g.:
cmd.commandtext = "select rodeuser,username,password from customer_db_map";
I need each column in a string:
string rodecustomer = cmd.ExecuteScalar();
string username= cmd.ExecuteScalar();
string password = cmd.ExecuteScalar();
But that is not possible. How is this achieved?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…