How to pass an value to the stored procedure

Question

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

Sachin Singh · Answer

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

Rajanikant Hawaldar · Answer

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 Hadiya · Answer

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 Khalid · Answer

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

How to pass an value to the stored procedure

Answers (4)