记录未添加到数据库中 [英] Records Not Getting added to the DB

问题描述

你好，



下面的代码运行良好，也进入了代码，似乎工作正常，一切都完成后就不想添加了记录到DB，有人可以告诉我这里是否有任何问题，下面是代码供参考。

Hi There,

The Code below works good and stepped into the code also and seems to be working ok and once everything is done it does not want to add the records to the DB, can someone let me know if there is any problem here, below is the code for reference.

Private Sub BtnSendToGP_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnSendToGP.Click
        Dim VarItemNumber As String
        Dim VarItemDescription As String
        Dim VarUnitOfMeasure As String
        Dim VarItemClass As String
        Dim VarCurrentCost As String
        Dim Conn As SqlConnection

        Conn = New SqlConnection("Server = db02; Initial Catalog=PRD; User=xx; Password=xxxxx" & "Data Source=Dynamics;Integrated Security=SSPI;")
        'Dim myCommand As SqlCommand = New SqlCommand("dbo.taUpdateCreateItemRcd", Conn)
        'If Conn.State = ConnectionState.Open Then Conn.Close()
        'Conn.Open()

        Try
            For cn As Integer = 0 To DtGridView.RowCount - 1
                VarItemNumber = DtGridView(0, cn).Value.ToString()
                VarItemDescription = DtGridView(3, cn).Value.ToString()
                VarUnitOfMeasure = DtGridView(4, cn).Value.ToString()
                VarItemClass = DtGridView(5, cn).Value.ToString()
                VarCurrentCost = DtGridView(6, cn).Value.ToString()

                Dim myCommand As SqlCommand = New SqlCommand("dbo.taUpdateCreateItemRcd", Conn)
                If Conn.State = ConnectionState.Open Then Conn.Close()
                Conn.Open()
                myCommand.CommandType = Data.CommandType.StoredProcedure
                myCommand.Parameters.AddWithValue("@I_vITEMNMBR", VarItemNumber)
                myCommand.Parameters.AddWithValue("@I_vITEMTYPE", 1)
                myCommand.Parameters.AddWithValue("@I_vVCTNMTHD", 1)
                myCommand.Parameters.AddWithValue("@I_vTAXOPTNS", 2)
                myCommand.Parameters.AddWithValue("@I_vDECPLQTY", 1)
                myCommand.Parameters.AddWithValue("@I_vDECPLCUR", 3)
                myCommand.Parameters.AddWithValue("@I_vPurchase_Tax_Options", 2)
                myCommand.Parameters.AddWithValue("@I_vKPCALHST", 1)
                myCommand.Parameters.AddWithValue("@I_vKPERHIST", 1)
                myCommand.Parameters.AddWithValue("@I_vKPTRXHST", 1)
                myCommand.Parameters.AddWithValue("@I_vKPDSTHST", 1)
                myCommand.Parameters.AddWithValue("@I_vPRICMTHD", 1)
                myCommand.Parameters.AddWithValue("@I_vUseItemClass", 1)
                'myCommand.Parameters.AddWithValue("@VarVendor", VarVendor)
                myCommand.Parameters.AddWithValue("@I_vITEMDESC", VarItemDescription)
                myCommand.Parameters.AddWithValue("@I_vUOMSCHDL", VarUnitOfMeasure)
                myCommand.Parameters.AddWithValue("@I_vITMCLSCD", VarItemClass)
                myCommand.Parameters.AddWithValue("@I_vCURRCOST", VarCurrentCost)
                myCommand.Parameters.AddWithValue("@O_iErrorState", 0)
                myCommand.Parameters.AddWithValue("@oErrString", 0)
                myCommand.ExecuteNonQuery()
            Next
        Catch ex As Exception
            MsgBox(ex.ToString)
        Finally
            If Conn.State = ConnectionState.Open Then
                Conn.Close()
            End If
        End Try
        MsgBox("All The Records Added To GP Successfully...", MsgBoxStyle.Information)
    End Sub

下面是我用来在数据库中插入记录的存储过程，让我知道是否有任何想法为什么它没有将记录插入数据库。得到高度赞赏。

Below is the Stored Procedure that I am using to insert the records in the db, let me know if any ideas there as to why it is not inserting records into the db. Answer highly appreciated.

GO
/****** Object:  StoredProcedure [dbo].[taUpdateCreateItemRcd]    Script Date: 05/02/2013 15:44:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
 ALTER procedure [dbo].[taUpdateCreateItemRcd]  @I_vITEMNMBR char(30),    @I_vITEMDESC char(100),    @I_vITMSHNAM char(15),          @I_vITMGEDSC char(10),    @I_vITMCLSCD char(10),    @I_vITEMTYPE smallint,     @I_vVCTNMTHD smallint,    @I_vTAXOPTNS smallint,    @I_vITMTSHID char(15),    @I_vUOMSCHDL char(10),    @I_vITEMSHWT numeric(8,2),   @I_vTCC char(30),     @I_vCNTRYORGN char(6),    @I_vDECPLQTY smallint,    @I_vDECPLCUR smallint,    @I_vPurchase_Tax_Options smallint, @I_vPurchase_Item_Tax_Schedu char(15), @I_vSTNDCOST numeric(19,5),   @I_vCURRCOST numeric(19,5),   @I_vLISTPRCE numeric(19,5),   @I_vNOTETEXT varchar(8000),   @I_vALTITEM1 char(30),    @I_vALTITEM2 char(30),    @I_vITMTRKOP smallint,    @I_vLOTTYPE char(10),    @I_vLOTEXPWARN tinyint,    @I_vLOTEXPWARNDAYS smallint,  @I_vINCLUDEINDP tinyint,   @I_vMINSHELF1 smallint,    @I_vMINSHELF2 smallint,    @I_vALWBKORD tinyint,    @I_vWRNTYDYS smallint,    @I_vABCCODE smallint,    @I_vUSCATVLS_1 char(10),   @I_vUSCATVLS_2 char(10),   @I_vUSCATVLS_3 char(10),   @I_vUSCATVLS_4 char(10),   @I_vUSCATVLS_5 char(10),   @I_vUSCATVLS_6 char(10),   @I_vKPCALHST tinyint,    @I_vKPERHIST tinyint,    @I_vKPTRXHST tinyint,    @I_vKPDSTHST tinyint,    @I_vIVIVACTNUMST varchar(75),  @I_vIVIVOFACTNUMST varchar(75),  @I_vIVCOGSACTNUMST varchar(75),  @I_vIVSLSACTNUMST varchar(75),  @I_vIVSLDSACTNUMST varchar(75),  @I_vIVSLRNACTNUMST varchar(75),  @I_vIVINUSACTNUMST varchar(75),  @I_vIVINSVACTNUMST varchar(75),  @I_vIVDMGACTNUMST varchar(75),  @I_vIVVARACTNUMST varchar(75),  @I_vDPSHPACTNUMST varchar(75),  @I_vPURPVACTNUMST varchar(75),  @I_vUPPVACTNUMST varchar(75),  @I_vIVRETACTNUMST varchar(75),  @I_vASMVRACTNUMST varchar(75),  @I_vKTACCTSR smallint,    @I_vPRCHSUOM char(8),    @I_vRevalue_Inventory tinyint,  @I_vTolerance_Percentage numeric(19,2),  @I_vLOCNCODE char(10),    @I_vPRICMTHD smallint,    @I_vPriceGroup char(10),   @I_vUseItemClass tinyint,   @I_vUpdateIfExists tinyint,   @I_vRequesterTrx smallint,   @I_vUSRDEFND1 char(50),       @I_vUSRDEFND2 char(50),       @I_vUSRDEFND3 char(50),       @I_vUSRDEFND4 varchar(8000),  @I_vUSRDEFND5 varchar(8000),  @O_iErrorState int output, @oErrString varchar(255) output  as  set nocount on  select @O_iErrorState = 0  return (@O_iErrorState)

推荐答案

你的存储过程会接受一堆参数，但实际上并没有对它们做任何事......你需要一个在那里插入或更新语句!!

Your stored procedure takes in a bunch of parameters, but doesn''t actually do anything with them... you need an insert or update statement in there!!

这篇关于记录未添加到数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！