How to pass an value to the stored procedure

Monisha Aadi

5y1.1k

Hi,

I want to pass the selected gridvalues to the stored procedure using sql server. Can someone guide me.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar5y ago
Refer below C# Code to know,
static void GetSalesByCategory(string connectionString,
    string categoryName)
{
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        // Create the command and set its properties.
        SqlCommand command = new SqlCommand();
        command.Connection = connection;
        command.CommandText = "SalesByCategory";
        command.CommandType = CommandType.StoredProcedure;

        // Add the input parameter and set its properties.
        SqlParameter parameter = new SqlParameter();
        parameter.ParameterName = "@CategoryName";
        parameter.SqlDbType = SqlDbType.NVarChar;
        parameter.Direction = ParameterDirection.Input;
        parameter.Value = categoryName;

        // Add the parameter to the Parameters collection.
        command.Parameters.Add(parameter);

        // Open the connection and execute the reader.
        connection.Open();
        SqlDataReader reader = command.ExecuteReader();

        if (reader.HasRows)
        {
            while (reader.Read())
            {
                Console.WriteLine("{0}: {1:C}", reader[0], reader[1]);
            }
        }
        else
        {
            Console.WriteLine("No rows found.");
        }
        reader.Close();
    }
}
Below is the stored procedure sample:
ALTER PROCEDURE [dbo].[Test]
@USERID varchar(25)

AS
BEGIN
SET NOCOUNT ON
IF NOT EXISTS Select * from Users where USERID = @USERID)
    BEGIN
        INSERT INTO Users (USERID,HOURS) Values(@USERID, 0);
    END
Yogeshkumar Hadiya5y ago
Please refere below articles.
In this article i create store procedure for create dynamic pivot table and also execute that store procedure.
https://www.c-sharpcorner.com/article/create-dynamic-pivot-table-using-store-procedure/

In below article i create a crud operation in c# windows form application with store procedure.
https://www.yogeshhadiya.in/2020/11/Crud-operation-in-c-sharp-windows-form-using-sp.html
Asma Khalid5y ago
Look into https://bit.ly/2YqZWzO to pass values to a store procedure via ASP.NET MVC and look into https://bit.ly/2C4BGYB to pass values to a store procedure using ASP.NET Core.

Mark answer as accpted if helpful

Thanks & Regards,
Asma Khalid

For More Visit: www.asmak9.com or www.bytezaar.com
Sachin Singh5y ago
first learn to execute stored procedure with parameters from .net application then you will automatically do whatever your requirent is.
https://www.sharpencode.com/article/ADONET/stored-procedure-in-ado-net