I got this code to get alll the notes loaded
It displays 10 latest notes for me, but I also want it to display the name from the same row as notes.Code:Private Sub Load_History() Dim myCnt As Integer Dim myStr As String Dim myDataset As New DataSet Dim i As Integer = 10 Dim e As Integer = -1 myStr = "select owner,names from orders" Dim sqldaHistory As New SqlDataAdapter(myStr, nwindconn) sqldaHistory.Fill(myDataset, "orders") myCnt = myDataset.Tables(0).Rows.Count Do While i > 0 i = i - 1 e = e + 1 pnltable.RowStyles.Add(New RowStyle(SizeType.Absolute, 100)) Dim lblName As New Label 'lblName.Text = myDataset.Tables(0).Rows(e).Item("owner") Dim listEvent As New ListBox listEvent.Size = New Size(100, 20) listEvent.Items.Add("Update") Dim lblNote As New Label lblNote.Text = myDataset.Tables(0).Rows(e).Item("notes") lblNote.Size = New Size(300, 100) pnltable.Controls.Add(lblName) pnltable.Controls.Add(listEvent) pnltable.Controls.Add(lblNote) Loop End Sub




Reply With Quote