Strumenti utilizzati:
visual basic 2008(express edition)
sql server(express edition)
Mando in debug e va in errore nel ciclo:
io vorrei semplicemente stampare su una msgbox il risultato della query..l'errore riscontrato è:codice:Do While myReader.Read() results = results & myReader.GetString(0) & vbTab & _ myReader.GetString(1) & vbLf
Indice oltre i limiti della matrice.
qualcuno ha idea di come risolvere??? Non ha senso.. perchè altre istruzioni come l'insert funzionano..
codice:Imports System.Data.SqlClient Public Class Form1 Inherits System.Windows.Forms.Form 'Create ADO.NET objects. Private myConn As SqlConnection Private myCmd As SqlCommand Private myReader As SqlDataReader Private results As String Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load myConn = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Programmi\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DB_FINANCE.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True") myCmd = myConn.CreateCommand myCmd.CommandText = "SELECT * FROM PROVA" 'Open the connection. myConn.Open() myReader = myCmd.ExecuteReader() Do While myReader.Read() results = results & myReader.GetString(0) & vbTab & _ myReader.GetString(1) & vbLf Loop 'Display results. MsgBox(results) myReader.Close() myConn.Close() End Sub End Class

Rispondi quotando