Capturing count from an SQL query

Question

What is the simplest way in C    cs file  to get the count from the SQL command   SELECT COUNT    FROM table name   into an int variable

User · Answer

int count   0      using  new SqlConnection connection   new SqlConnection  connectionString          sqlCommand cmd   new SqlCommand  SELECT COUNT    FROM table name   connection       connection Open        count    int32 cmd ExecuteScalar

User · Answer

Use SqlCommand ExecuteScalar   and cast it to an int  cmd CommandText    quot SELECT COUNT    FROM table name quot   Int32 count    Int32  cmd ExecuteScalar

User · Answer

Complementing in C  with SQL   SqlConnection conn   new SqlConnection  ConnectionString    conn Open    SqlCommand comm   new SqlCommand  SELECT COUNT    FROM table name   conn   Int32 count   Convert ToInt32 comm ExecuteScalar     if  count  gt  0        lblCount Text   Convert ToString count ToString       For example a Label   else       lblCount Text    0     conn Close      Remember close the connection

User · Answer

You ll get converting errors with   cmd CommandText    SELECT COUNT    FROM table name   Int32 count    Int32  cmd ExecuteScalar      Use instead   string stm    SELECT COUNT    FROM table name WHERE id   id      MySqlCommand cmd   new MySqlCommand stm  conn   Int32 count   Convert ToInt32 cmd ExecuteScalar     if count  gt  0       found   true     else       found   false

User · Answer

SqlConnection conn   new SqlConnection  ConnectionString    conn Open    SqlCommand comm   new SqlCommand  SELECT COUNT    FROM table name   conn   Int32 count    Int32  comm  ExecuteScalar

[c#] Capturing count from an SQL query

Examples related to c#

Examples related to sql

Examples related to sql-server