Public Sub ReadOrderData(ByVal connectionString As String) Dim queryString As String = _ "SELECT OrderID, CustomerID FROM dbo.Orders where name = @Name;" Using connection As New SqlConnection(connectionString) Dim command As New SqlCommand(queryString, connection) command.Parameters.Add(new SqlParameter("Name", "toto")) connection.Open() Dim reader As SqlDataReader = command.ExecuteReader() Try While reader.Read() Console.WriteLine(String.Format("{0}, {1}", _ reader(0), reader(1))) End While Finally ' Always call Close when done reading. reader.Close() End Try End Using End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question