Using stored procedure and c# how will we know how many records are present in a table [Resolved]

Posted by Srinibaschampati under ASP.NET on 8/22/2013 | Points: 10 | Views : 2118 | Status : [Member] | Replies : 2
Using stored procedure and c# how will we know how many records are present in a table in asp.net




Responses

Posted by: Bandi on: 8/22/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
-- Procedure looks like below to return total number of records in a table
CREATE PROCEDURE USP_GetCount(@P_count int OUTPUT)

AS
BEGIN
SELECT @P_count = COUNT(*) FROM TableName
END


C# code to call procedure and return output value from that procedure
            string strConnString = "youConnectionString";

SqlConnection con = new SqlConnection(strConnString);
con.Open();
SqlCommand com = new SqlCommand("USP_GetCount", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add("@RowCount", SqlDbType.Int).Direction =
ParameterDirection.Output;

SqlDataReader reader = com.ExecuteReader();
reader.Close();
total_count.Text = com.Parameters["@RowCount"].Value.ToString();
con.Close();

highlighted part is for getting output parameter value from a stored procedure

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Srinibaschampati, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Kmandapalli on: 8/22/2013 [Member] Silver | Points: 25

Up
0
Down
Hi,

You can simply execute the following query:
CREATE PROC GetCount
AS
BEGIN
select count(*) from table_name
END

In the front-end ie, in your code behind file you can call the stored proc as
SqlConnection con = new SqlConnection();
con.Open();
SqlCommand cmd = new SqlCommmand("GetCount", con);
int result = cmd .ExecuteNonQuery();

Thats it...

Kindly Mark as answer if satisfied.....


Regards,
Shree M.

Kavya Shree Mandapalli

Srinibaschampati, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response