C# count statement

Question

0.00/5 (No votes)

See more:

i write C# code and use Access database,
if i use count statement ,how can i use the result of that statement and give it integer variable.
#in other words the result of count statement was 5
int x= result of count statement.

Posted 2-Jul-13 8:31am

loai_maane

Add a Solution

3 solutions

Solution 1

In Access you would issue a SELECT Statement:

SQL

SELECT COUNT(*) FROM MyTable

You can then retrieve this value in your C# code either via a DataReader / DataAdapter like any other data or directly as the result of an ExecuteNonQuery statement.

Posted 2-Jul-13 8:50am

OriginalGriff

Comments

Matt T Heffron 2-Jul-13 14:53pm

Is there a LINQ adapter for Access?

OriginalGriff 2-Jul-13 14:58pm

Try here:
http://www.codeproject.com/Articles/23599/LinqToSQL-Comprehensive-Support-for-SQLite-Microso

Solution 2

If I understood your problem right, you want to execute your MS-Access DB query which returns count in your C# code.

Connect to your MS-Access database using OleDB.
http://msdn.microsoft.com/en-us/library/5ybdbtte(v=vs.71).aspx

Then fetch result of your query using ExecuteScalar. Refer below link.
http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbcommand.executescalar.aspx

Posted 2-Jul-13 8:58am

RaisKazi

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2013-07-02T09:04:00

Solution 3

See one example - Counting data in ACCESS database?[^]

Posted 2-Jul-13 9:04am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)