Torna al Thread

Connessione.Open() Dim numero_atto As Integer = 15536 Dim variabile_data As Date = "04/04/2009" If Connessione.State = ConnectionState.Open Then 'MessageBox.Show(numero_atto) ' mi serve per capire quanto vale la variabile Dim MioCodiceSql As String = "SELECT * FROM preg_atti WHERE numero =@numero AND data_atto =@data" Dim MioCommand As New OleDbCommand(MioCodiceSql, Connessione) MioCommand.Parameters.Add("@numero", OleDbType.Integer).Value = 15536 MioCommand.Parameters.Add("@data", OleDbType.Date).Value = "04/04/2009" Dim reader As OleDbDataReader = MioCommand.ExecuteReader() While reader.Read() MsgBox(reader(0).ToString() & " - Numero: " & reader(1).ToString() & " - Data: " & reader(2).ToString()) End While reader.Close()
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5