Count

Sheikha · September 4th, 2004, 12:48 AM

i'm developing a web abased application in VB .NET. i created a count button which displays the number of records available in a table. the code is as below:

Dim sqlCount As String = "SELECT COUNT(code) from subarea"
lblCount.Text = sqlCount & " records. "
lblCount.Visible = True

i want the result of the sql to be dislayed in a lablel. How do i do that? what should i write instead of sqlCount in the below code:
lblCount.Text = sqlCount & " records. "

Thanks

mehdi62b · September 5th, 2004, 02:42 AM

Hello Sheikha,
you shouldnt do it in that way,
do these steps,
1-make a SelectCommand object
2-set it with your query and SELECT @@rowcount
3.use ExecuteScalar() method through your command object(for returning the rowcount)and convert it to String for assigning it to Text property ....
However if you are using DataView you could use it easier ...
HtH.

--------------------------------------------
Mehdi.:)

Sheikha · September 5th, 2004, 10:57 PM

Hi Mahdi:

Thanks for helping me out but i didnt really understand the steps. Could you kindly elaborate?

mehdi62b · September 6th, 2004, 06:08 AM

Have a look at this example ...

Code:

SqlConnection objConnection=new SqlConnection(strConnection);
//strSql is your select query
SqlCommand objCommand=new SqlCommand(strSql,objConnection);
objConnection.Open();
DataGrid1.DataSource=objCommand.ExecuteReader();
DataGrid1.DataBind();
objConnection.Close();
objCommand.CommandText="select @@rowcount";
objConnection.Open();
TextBox1.Text=objCommand.ExecuteScalar().ToString();
objConnection.Close();

(however you can work with Count property of DataView object but you should
consider that you work in disconnected environment)
HtH.

--------------------------------------------
Mehdi.:)

mehdi62b · September 16th, 2004, 07:39 PM

Hello again sheikha!!!
dont use this method I told you
(you will face some problems if many users hit your site)
you should use a Stored Procedure with an Output Parameter
(see here for the cause of this problem)
if you face some problems in using Stored Procedures ask me.

--------------------------------------------
Mehdi.:)