I am trying to count the numbers of rows for the name column from a database table(Test) and display it on a page.
Can you pls help.I am also trying to link the number so that everytime,when the database gets updated the row count number automatically changes.

I am doing this in C#

Open a window into your DB (data adapter, or whatever), and use the SQL

    SELECT COUNT(NAME)
    FROM MY_TABLE

You could do something simple like this with a command object’s .ExecuteScalar() function.


To get your app to update, the resource-economical way to do this is with an OnUpdate (or AfterUpdate, whatever) trigger in the database that then "tickles" your app. If the DB can receive the address of a function, and then call that function using the address, that would be the ticket.

Outside a database environment, this would be a callback process.



A far less efficient way is to go “inspect” the DB on a timed basis.

I am looking for the code which will help me to show the total count of rows without Datagrid or Repeater. And ExecuteScalar() does not work with C#. Pls help

ExecuteScalar does works is c#...

Object obj = cmd.ExecuteScalar();
long result = Convert.ToInt64(obj);

cmd is of type command object set it with your query and connection

Thank you for your help.

No prob

I see.

:)¡¶
 Â¡Â¶Â¡Â¶ No pains, no gains.
¡¶¡¶¡¶