Sunday, 26 April 2015

Fetch 3 Tier in VB

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