(19-11-17, 03:36 AM)a.ahmed كتب :

PHP كود :

Private Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click

    Dim sql As String =
        "SELECT *                                           " & _
        "FROM   ( Select * From [ERC_Long_Aged]             " & _
        "         UNION ALL                                 " & _
        "         SELECT * FROM [HUA_Long_Aged]             " & _
        "         UNION ALL                                 " & _
        "         SELECT * FROM [NSN_Long_Aged]             " & _
        "       ) T                                         " & _
        "WHERE  Operational_Categorization_Tier2 = 'Access' "

    Using da As New SqlDataAdapter(sql, connSQLServer)
        Dim dt As New DataTable
        TextBox1.Text = da.Fill(dt)
        Me.DataGridView1.DataSource = dt
    End Using

End Sub