stored procedure

  1. fokwabest

    How to execute stored procedure in ASP.NET Core 3.1 and assign result sets to variables

    I am new to ASP.NET Core (3.1). I have a stored procedure that takes two parameters: startDate and endDate. It returns the following result sets in one go (or execution): I want to be able to grab the result sets in 3 separate variables because I will like to...
  2. Samuel David

    Resolved How to view sql command execution with Stored Procedure ?

    Hello Everyone, I have below block of code. private TData ExecuteReturnData<TData>(string procName, Func<IDataReader, TData> translator, SqlConnection sqlCon, params SqlParameter[] parameters) { using var sqlCmd = CreateCommand(procName, sqlCon, parameters); sqlCmd.CommandTimeout=120; using...
  3. Programmable Physics

    Search Button that is using Stored Procedure is not listing a specific record

    I am using Northwind database in Sql Server. I am using Stored Procedure to connect Visual Studio with Sql Server and draw data from database. In CRUD operations, I am tring to write a SEARCH button that is using Stored Procedure. Other CRUD buttons are working okay. Search button is not...
  4. A

    Resolved Procedure or function sp_updateItems has too many arguments specified.

    I want to update the price of items in the database. I am extracting a list of items from another list( of class type having other information also). After that I am sending it(item number) one by one as a stored procedure parameter to get the price updated. But I am getting a Procedure or...
  5. A

    Resolved when null flag updated and conflict flag updated on SQL query statement?

    I work on SQL server 2012 .really I don't understand what statement below do updatedand when when NullFlag updated and when conflict flag updated can you explain to me according to sample below <code> result of query data details rows without grouping : Masked_ID DocumentID PartID NULLCount...
  6. A

    Question How to add column column unitmeasure dynamically based on Flag Allow is 1?

    How to add column column unit dynamically when Flag Allow is 1 on table #nonparametric table ? I work on SQL server 2012 I can't add column unit dynamically when Flag Allow=1 as example below I have two rows have Flag Allow=1 family 90AM will be family 90 and family unit AM on two column...
  7. S

    Question How to call a stored procedure in a method to get the result in an array list?

    I need to call a stored procedure in one method to get the data and display it in one column of html table. the rest of columns are displayed by another methods and actionresults. (it's a mvc repository application). right now I can show the result of stored procedure in grideview, each column...
Top Bottom