{"id":202842,"date":"2024-12-24T10:12:03","date_gmt":"2024-12-24T10:12:03","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/how-to-get-return-value-from-stored-procedure-in-c\/"},"modified":"2024-12-24T10:12:03","modified_gmt":"2024-12-24T10:12:03","slug":"how-to-get-return-value-from-stored-procedure-in-c","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-get-return-value-from-stored-procedure-in-c\/","title":{"rendered":"How to get return value from stored procedure in C#?"},"content":{"rendered":"

To get the return value from a stored procedure in C#, you can use the `ExecuteScalar` method of the `SqlCommand` class. The return value of a stored procedure can be set using the `RETURN` statement in SQL Server. Here is an example of how you can get the return value from a stored procedure in C#:<\/p>\n

“`csharp
\nusing System;
\nusing System.Data;
\nusing System.Data.SqlClient;<\/p>\n

class Program
\n{
\n static void Main()
\n {
\n string connString = “Data Source=(local);Initial Catalog=YourDatabase;Integrated Security=True”;
\n using (SqlConnection conn = new SqlConnection(connString))
\n {
\n conn.Open();
\n using (SqlCommand cmd = new SqlCommand(“YourStoredProcedureName”, conn))
\n {
\n cmd.CommandType = CommandType.StoredProcedure;<\/p>\n

\/\/ Add parameters if needed
\n cmd.Parameters.AddWithValue(“@param1”, value1);<\/p>\n

\/\/ Get the return value
\n SqlParameter returnValue = new SqlParameter();
\n returnValue.Direction = ParameterDirection.ReturnValue;
\n cmd.Parameters.Add(returnValue);<\/p>\n

cmd.ExecuteScalar();<\/p>\n

\/\/ Get the return value from the stored procedure
\n int returnVal = Convert.ToInt32(cmd.Parameters[“@returnValue”].Value);
\n Console.WriteLine(“Return value from stored procedure: ” + returnVal);
\n }
\n }
\n }
\n}
\n“`<\/p>\n

In this example, we first create a `SqlCommand` object with the name of the stored procedure. We then add any necessary parameters to the command and create a `SqlParameter` object to capture the return value. Finally, we execute the command and retrieve the return value using `Convert.ToInt32`.<\/p>\n

<\/p>\n

\n
\n

Table of Contents<\/p>\nToggle<\/span><\/path><\/svg><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n