I cant Figure out what is wrong with my code when I run my program i get this error ..INVALID COLUMN NAME
Imports System.Data
Imports System.Data.SqlClient
Partial Class Information
Inherits System.Web.UI.Page
Protected Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load
End Sub
Protected Sub txtlocationid_TextChanged(sender As Object, e As System.EventArgs) Handles txtlocationid.TextChanged
GETPAGEINFO()
End Sub
Public Sub GETPAGEINFO()
SQLInfo.SelectCommand = "SELECT LOCATIONID, LOCWNAME, LOCNM , ADDR1, ADDR2, ADDR3, CITY, ZIP, COUNTRY, PHN, LOCNM2, PHNEXT, FAX, STRTDT, PGNAME, MADDR1, MADDR2, MADDR3, MCITY, MZIP, CTNM, CEMAIL, WEBSITE, LOCHMRWEB, MDIR, HMRHMCT, APHN, APHNEXT, HMREMAIL" & _
"FROM LOCATIONS WHERE LOCATIONID='" & txtlocationid.Text & "'"
Dim dv As DataView ...
Go to the complete details ...