Ave ragazzi ho un problema con le date:data la funzione
Private Sub TabPage3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TabPage3.Click
indicev = 0
Dim areader As OleDbDataReader
Dim acommand As OleDbCommand
Dim cic As Integer
Dim objConn As New OleDbConnection _
("Provider=Microsoft.Jet.OLEDB.4.0;" & _
"User ID=Admin;" & _
"Data Source=C:\binostudio.mdb")
objConn.Open()
acommand = New OleDbCommand("select titolo,nome,cognome,residenza,domicilio,tel1,tel2, cf,datanascita from personale order by titolo,cognome ", objConn)
areader = acommand.ExecuteReader()
While (areader.Read())
v1(indicev) = (areader.GetString(0))
v2(indicev) = (areader.GetString(1))
v3(indicev) = (areader.GetString(2))
v4(indicev) = (areader.GetString(3))
v5(indicev) = (areader.GetString(4))
v6(indicev) = (areader.GetString(5))
v7(indicev) = (areader.GetString(6))
v8(indicev) = (areader.GetString(7))
RIGA CON ERRORE v9(indicev) = (areader.GetString(8))
indicev = indicev + 1
End While
objConn.Close()
End Sub
ricevo l'errore: An unhandled exception of type 'System.InvalidCastException' occurred in system.data.dll
Additional information: The data value could not be converted for reasons other than sign mismatch or data overflow. For example, the data was corrupted in the data store but the row was still retrievable.
riesco ad inserire le date in un database ma nn a prelevarle
