Torna al Thread

................ ............... con = New OleDbConnection con.connectionstring = strCon Dim prm As OleDbParameter Dim drQuery As OleDbDataReader Dim cmd As New OleDbCommand("Select * from query where (DataInizio < ?) and (DataFine > ?)", con) cmd.CommandType = Data.CommandType.Text prm = New OleDbParameter prm.Direction = Data.ParameterDirection.Input '//--> parametro di tipo Date prm.DbType = Data.DbType.Date appdataInizio = "01/12/2005" appdataFine = "31/12/2005" prm.Value = Convert.ToDateTime(appdataInizio) cmd.Parameters.Add(prm) prm = New OleDbParameter prm.Direction = Data.ParameterDirection.Input '//--> parametro di tipo Date prm.DbType = Data.DbType.Date prm.Value = Convert.ToDateTime(appdataFine) cmd.Parameters.Add(prm) cmd.Connection = con con.open() drQuery = cmd.ExecuteReader() testo = "" Do While (drQuery.Read) testo += ControlChars.CrLf + drQuery("SerialNumber").ToString + Chr(9) + drQuery("DataInizio").ToString + Chr(9) + drQuery("DataFine").ToString Loop Me.TextBox1.Text = testo drQuery.Close() con.close()
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5