asked on

SQL Invalid Column name

Hi Guys
Can you find anything wrong with this query, it says invalid column name on all the columns, I am tryinf to display the result in a gridview

Public Sub showPlaceholder()
        Dim pagesGrid As New GridView
        Using myConn As New SqlConnection(connStr)
            Dim sql As String = "SELECT [Pages.pageTitle], [Pages.pageContent], [MenuItems.MenuItemText] from " & _
                                "[Pages], [MenuItems] where [pages.siteID] = [menuitems.siteID] and " & _
                                "[menuitems.siteID] = 3"
            Dim mycommand As New SqlCommand(sql, myConn)
            Dim mydataset As New DataSet
            Dim myadapter As New SqlDataAdapter(mycommand)
            myadapter.Fill(mydataset)
            pagesGrid.DataSource = mydataset
            Dim myPlaceholder As PlaceHolder = Me.UpdatePanel3.FindControl("PlaceHolder1")
            myPlaceholder.Controls.Add(pagesGrid)
        End Using

Open in new window