=========== load data into listview
'strQ = "SELECT * FROM tbCar ORDER BY [Model]"
'======> load_data(strQ)
Sub load_data(sqlQuery As String)
Try
If (con.State = ConnectionState.Open) Then
con.Close()
End If
con.Open()
cmd = New SqlClient.SqlCommand(sqlQuery, con)
da = New SqlClient.SqlDataAdapter(cmd)
ds = New DataSet
da.Fill(ds, "Table")
Dim itemcoll(100) As String
Dim i As Integer = 0
Dim j As Integer = 0
ListView1.Items.Clear()
ListView1.Columns.Clear()
For i = 0 To ds.Tables(0).Columns.Count - 1
Me.ListView1.Columns.Add(ds.Tables(0).Columns(i).ColumnName.ToString())
Next
For i = 0 To ds.Tables(0).Rows.Count - 1
For j = 0 To ds.Tables(0).Columns.Count - 1
itemcoll(j) = ds.Tables(0).Rows(i)(j).ToString()
Next
Dim lvi As New ListViewItem(itemcoll)
Me.ListView1.Items.Add(lvi)
Next
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub
========================
No comments:
Post a Comment