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

-- 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

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