Loading

How to count the data in sql server using csharp code?

Black Diamond

Hi!,

how to Count my data in sql server using csharp?

for example i have a column Name and Votes, i want that if my button which handle the column name by pressing it and stored it into the Column Name and it automatically Count and store to the coulumn Votes on how many times the user pressed that button.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Amit Choudhary15y ago
You may want to use Aggregation GroupBy and Count() function in SQL to count the no. of votes by per user.

For e.g., Query for Total number of orders placed by Every customer
SELECT
CustomerId
,COUNT(OrderId) as 'Total Orders'
FROM [NShop].[dbo].[Orders] Group by CustomerId

Hope this would help you.
0