How to get count of a particular item in mysql table using c#

Question

I am tried to get count of a particular item from mysql table using c#.but i got nothing

My code

string Batch = textBox8.Text;
string batchnumber = ("SELECT COUNT [Batch_No] FROM Orders where Batch_No='" + Batch + "'");

orders is my table and batch_no is the column and i want to get the count of particular batch number in the table.How can i do this?

"SELECT COUNT (*) FROM Orders where Batch_No='" + Batch + "'" — Kami, Jan 05 '16 at 13:37
Then use SUM function on the Batch_No column. There is a post that might help you. http://stackoverflow.com/questions/4586040/mysql-sum-elements-of-a-column — Kami, Jan 05 '16 at 13:46
Count only gives you a count of records whereas SUM will give you a sum of the selected column (numerical of course). — Kami, Jan 05 '16 at 13:53

score 0 · Answer 1 · edited Jan 05 '16 at 16:03

0

Change COUNT [Batch_No] to COUNT(Batch_No). It will work.

Try this:

string Batch = textBox8.Text;
string batchnumber = ("SELECT COUNT(Batch_No) FROM Orders WHERE Batch_No='" + Batch + "'");

edited Jan 05 '16 at 16:03

Anirudha Gupta

answered Jan 05 '16 at 13:41

Saharsh Shah

1 Answers1