a simple question

[Jason]

I have a simple question here,

ConnectToDB();

string queryString = "SELECT Owner,Description FROM Groups WHERE Title =
'BOSS'";

MySqlCommand myCmd = new MySqlCommand(queryString,mycon);

try
{
lblOwner.Text = (string)myCmd.ExecuteScalar();
}
finally
{
myCmd.Dispose();
mycon.Dispose();
}

it's only get one(Owner) value back, so what I need to do so I can pull both
Owner and Description from database?

Thansk in advance.

 

[Val Mazur]

Hi Jason,

ExecuteScalar method always returns only one value, not multiple values for
one row. You would need to use ExecuteReader to get an access to all the
fields in a row

 

[Laiju Skaria]

hello...

i think u can achieve the same by using datasets...ie
instead of calling....executescalar...use a dataadapter and user
dataadapter.fill(datasetname)...

ur datatable will have that row with 2 columns ...

hope this will help u.../

smiles,
Laiju

 

[Cor Ligthert]

Jason,

As an alternative to the answers from Val and Laiju,
Use two selectsstrings and two executescalars.

I hope this helps?

Cor