Torna al Thread

Dim MyDB As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source = " & pathMDb & nameMdbAzienda) MyDB.Open() strSql = "SELECT * FROM Clienti WHERE Codice = " & Val(DatiTesta(3)) cmd = New OleDbCommand(strSql, MyDB) Dim tb_nome As OleDbDataReader = cmd.ExecuteReader() If tb_nome.Read() = True Then ' aggiorno il record della tabella TESTATA DOCUMENTO TMP Call TabClienti() Dim NomiCampi As String = "" For x = 0 To TotaleCampi - 1 If Not tb_nome(x) Is DBNull.Value Then Select Case TableMdb(x, 1) Case Is = "integer", "double", "bit" NomiCampi &= "[" & TableMdb(x, 0) & "]=" & tb_nome(x) & "," Case Is = "date" NomiCampi &= "[#" & TableMdb(x, 0) & "#]=" & tb_nome(x) & "," Case Else NomiCampi &= "[" & TableMdb(x, 0) & "]='" & tb_nome(x) & "'," End Select End If Next NomiCampi &= "[" & TableMdb(TotaleCampi, 0) & "]='" & tb_nome(TotaleCampi) & "'" strSql = "UPDATE DocuTesta SET " & NomiCampi & " WHERE TipoDoc = '" & TipoDoc & "' AND Numero =" & NumDoc cmd = New OleDbCommand(strSql, MyDBDoc) Dim RisQuery As Integer = cmd.ExecuteNonQuery() End If
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5