sql-insert

  1. T

    Resolved Stored Procedure doesn't appear to be returning the Returned value to C#

    So I have a StoredProcedure that either Updates or Inserts a record. The SP is as follows: USE [FPY] GO /****** Object: StoredProcedure [dbo].[insupd_tblMRBHistory_AB] Script Date: 2025-01-10 8:02:00 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE...
  2. D

    System.FormatException : 'Input string was not in a correct format.'

    Good evening, I get an error on this line : command.Parameters.AddWithValue("@chambreCat", Convert.ToInt32(cbAdminCat.Text)); I want to be able to convert my character string to INT otherwise I could not insert the value into the database if it is not an integer. Here is the code for my...
  3. S

    Bulk-Insert to SQL LocalDB not working with Dapper Plus

    0 I am trying to populate my database column with name "StockInTable" using Dapper Plus nugget package. My stockin file is as below. class Stockin { [Key] public int ID { get; set; } public DateTime Date { get; set; } public string Sup_ID { get; set; } public string Sup_Name...
Back
Top Bottom