Get SQL count into variable

  • Thread starter Thread starter Luke Davis
  • Start date Start date
L

Luke Davis

What is the quickest way to get the count of rows in a table into an int
variable?

for example how would I make this happen?


int remaining = SELECT Count(*) FROM states.dbo.cities
 
ADO.NET's .ExecuteScalar() method is designed for returning a single value.

-HTH
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Application.DoEvents and Throwing Dice 3
Applying ++ and += to properties 17
Adding a filter functionality to my database form. What's wrong withthat code? 1
Increment a count 5
Resume Exception After Handling Exception in C# 9
Simple Reflection example give Exception 2
Send struct between a C# DLL and a C# application 3
Converting a IEnumberable sequence into an array - an example here 2

Back
Top