Torna al Thread

Dim strSql As String = "INSERT INTO Scadenziario (TipoDoc, Numero, Anno, DatScad, ImpScad) VALUES (@TipoDoc, @Numero, @Anno, @DatScad, @ImpScad)" Dim cmd = New OleDbCommand(strSql, MyDB) cmd.Parameters.Add("@TipoDoc", OleDbType.VarChar, 5) cmd.Parameters.Add("@Numero", OleDbType.BigInt) cmd.Parameters.Add("@Anno", OleDbType.VarChar, 4) cmd.Parameters.Add("@DatScad", OleDbType.Date) cmd.Parameters.Add("@ImpScad", OleDbType.Double) cmd.Parameters.AddWithValue("@TipoDoc", Scadenze(1)) cmd.Parameters.AddWithValue("@Numero", Val(Scadenze(2))) cmd.Parameters.AddWithValue("@Anno", Year(DataScad)) cmd.Parameters.AddWithValue("@DatScad", DataScad) cmd.Parameters.AddWithValue("@ImpScad", ImpRata + DiffImporti) cmd.ExecuteNonQuery()
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5