showing count(*) in a C# windows application.
Posted on 2007-03-23
I am writing a sample windows application in C# to learn the language, etc.
Essentially, what I want to do is display the number of records in a particular table when the application loads. So, in my form I have two text labels like this:
lbl1_txt.text = "The number of rows in your table is ..."
lbl2_result.text = "36" (this 36 is theoretically the amount of entries in the table).
I have a database that I connected to this application. It gets the connection string and all that has been established. But being a newbie I only know how to display data via grid view and don't know the code to substitute "36" with the result of "SELECT COUNT(*) FROM my_table"
Any help would be much appreciated