Error in displaying data grid

lamort · December 1st, 2006, 01:03 PM

Hi all

I am having some trouble on displaying datagrid data from my database

Below is the code sample :

<%@ Page Language="VB" Debug ="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<script language ="VBSCRIPT" runat="server">
Sub Page_Load(Src As Object, e As EventArgs)
        Dim myConnection As SqlConnection
        Dim DBCommand As SqlDataAdapter
        Dim DSPagedata As New DataSet

        myConnection = New _
        SqlConnection("server=localhost;uid=sa;pwd=;" _
        & "database=test1")

        Dim QueryString As String = "select * from User"

        DBCommand = New SqlDataAdapter(QueryString, _
        myConnection)
        DBCommand.Fill(DSPagedata, "User")---error line

        MyDataGrid.DataSource = DSPagedata.Tables("User")
        MyDataGrid.DataBind()
    End Sub
</script>

<html><body>
<h3>
Simple Select to a DataGrid Control.
</h3>
<ASP:DataGrid id="MyDataGrid" runat="server"
Width="700"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
MaintainState="false"
/>
</body></html>

The error is when calling the DBCommand . It show incorrect syntax near User. But User is the table in my server. Did i do anything wrong?
Pls advice .Thanks

Imar · December 1st, 2006, 01:14 PM

User is probably a reserved word in the database. Try wrapping it in [] characters, like this:

select * from [User]

Or better yet, rename the table.

Cheers,
Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

lamort · December 1st, 2006, 08:55 PM

Thanks for the help

Never thought that User would be a reserved word in the database

Now it works . Thank you so much.