FETCH
dal:
Imports System.Data
Imports System.Data.SqlClient
Public Class fetchdl
Dim obj As New connectiondal
Dim cmd As New SqlCommand
Dim ada As New SqlDataAdapter
Public Function fetchdetails() As
DataTable
Dim dt As New DataTable
cmd = New
SqlCommand("stp_selectall",
obj.Connection)
Try
ada = New
SqlDataAdapter(cmd)
ada.Fill(dt)
Return
dt
Catch
ex As Exception
Throw
ex
End Try
End Function
End Class
bal:
Imports System.Data
Imports System.Data.SqlClient
Public Class fetchbal
Dim obj As New fetchdl
Public Function fetchdetails() As
DataTable
Return
obj.fetchdetails()
End Function
End Class
PL:
Public Sub fetch()
Dim dt As New DataTable
Dim lst
As New
ListViewItem
dt = OBJf.fetchdetails()
ListView1.Items.Clear()
If
(dt.Rows.Count > 0) Then
For
Each r As
DataRow In dt.Rows
lst = New
ListViewItem(r("id").ToString())
lst.SubItems.Add(r("name").ToString())
lst.SubItems.Add(r("age").ToString())
lst.SubItems.Add(r("dob").ToString())
ListView1.Items.Add(lst)
Next
End If
End Sub
No comments:
Post a Comment