• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 793
  • Last Modified:

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

0
Mayank_Agarwal
Asked:
Mayank_Agarwal
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
Make sure that the columns pageTitle, pageContent ,siteID exists on "page' table also MenuItemText and SiteID in MenuItems table
0
 
Mayank_AgarwalAuthor Commented:
Yes they all exist, and spelling is corrrect as well.
0
 
gnoonCommented:
Isn't it [Pages].[pageTitle]?
0
 
HuyBDCommented:
you should add more brackets
e.g
[Pages.pageTitle] change to [Pages].[pageTitle]

hope this help
0
 
Mayank_AgarwalAuthor Commented:
Exactly mate, thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now