Storing the result of a Select Statement in a variable in Visual Studio C#

doyler442

Hi,

I am trying to store a single value result in a variable in C# from a select statement to an access database....i want to do it if possible without using datasets and data adapter etc. the code below runs but keeps returning the value 0 when it should be 1....would be great if anyone could help to see if there are any errors.....

OleDbConnection smb = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\SortmyBooks\\wineanddine.QVT;Persist Security Info=True;");

smb.Open();
OleDbCommand cmd5 = new OleDbCommand("SELECT CUS_ID From Invoices",smb);

int answer = cmd5.ExecuteNonQuery();
txtAmount.Text = answer.ToString();
smb.Close();


Thanks.

NeverSayDie

Using the ExecuteScalar() method instead of ExecuteNonQuery() should get you the behaviour you're looking for. It'll return the first column of the first row in the results from your query, I'm assuming that's what you want.
http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbcommand.executescalar.aspx

doyler442

Excellent, thats it alright....
Thanks, its been wrecking my head all day