Check if SQLServer table is empty

Question

In my WPF-application, I want to start a window only to be shown, if there a no data in the table "Betrieb". So, I know that I can check this with "select count from Betrieb". My problem is, how to get the count into my application.

int i = cmd.ExecuteNonQuery();

is wrong and does not work.

Does anybody have advice?

Eugen · Accepted Answer · 2011-11-09 18:42:37Z

4

use

Convert.ToInt32(cmd.ExecuteScalar())

answered Nov 9, 2011 at 18:42

Eugen

3,0203 gold badges30 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mggSoft · Accepted Answer · 2011-11-09 18:41:48Z

2

Object i = cmd.ExecuteScalar();

This method returns an object value with the count and you can cast the object type you want.

answered Nov 9, 2011 at 18:41

mggSoft

1,0522 gold badges24 silver badges37 bronze badges

Comments

Adam Rackis · Accepted Answer · 2011-11-09 21:31:04Z

1

By the way if your query is like this you must get an error. Change your query like this:

select count(**Column_Name**) from Betrieb

edited Nov 9, 2011 at 21:31

Adam Rackis

83.5k57 gold badges281 silver badges402 bronze badges

answered Nov 9, 2011 at 18:46

Safak Serdar Kapci

567 bronze badges

Collectives™ on Stack Overflow

Check if SQLServer table is empty

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related