Loading

How to limit my database table row? the row i want to make is until 5 rows only

Black Diamond

Hi everyone, i want help for my project, i want to limit my database table row until 5 rows only using csharp code, please help me for my project...thanks everyone.

4 Replies

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

Vulpes15y ago
Accepted answer
If you mean that you only want a query to return a maximum of 5 rows, then you can use the 'SELECT TOP 5 * FROM table' syntax.
0
Black Diamond15y ago
hi! suthish nair, thank you form the response...
0
Black Diamond15y ago
Hi! vulpes, Thank you for the response ... your code works!...
0
Suthish Nair15y ago
Just check for row counts. select COUNT(1) from table1.
0