How to count columns of table in sql server 2008 using C#?

Question

question

shyam229 asked Feb 7, '13

How to count columns of table in sql server 2008 using C#?

Hi, I am writing a program in C# and I connected the table with it. I am using SQL server 2008 and I want to know, Using C# how can i count the rows in one perticular table in the database. Thank you, Shyam

sql-server-2008 c#

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2013-02-07T16:58:09Z

ThomasRushton answered Feb 7, '13

SELECT COUNT(1) FROM or (I think) SELECT rowcnt from sysindexes where id = object_id('') and indid in (0,1) or, from the C# side, look at the RecordCount (or is it RowCount) property of the recordset object? I've not done this stuff for *years*...

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton ♦♦ commented · Feb 07, 2013 at 04:58 PM

sorry, I've been stuck in conf calls all week, and my head is full of clouds...

0 ·

Answer 2 · 2014-02-17T04:00:06Z

xiaoyuandlg Suspended answered Feb 17, '14

I thought this to be a question relating to the [C# grid column][1], you may get some insights since you do the reading of the thing. [1]: http://www.kettic.com/winforms_ui/csharp_guide/gridview_column.shtml

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question