All,

This are the first few lines of my first program to run on my home desktop running IIS 7 and SQL Server 2005.

The name of the database is datest and the table name is Tho_tho.

I get a compile error: "Compiler Error Message: BC30451: Name 'Tho_tho' is not declared" at the highlighted and underlined line.

Can someone help me with this rather silly mistake I seem to be making?

Thanks in advance.

SP

<%@ Import Namespace="System.Data.OleDb" %>

<script runat="server">
sub Page_Load
dim dbconn,sql,dbcomm,dbread

dbconn=New OleDbConnection("Server=PE-PC\MSSMLBIZ;Database=datest;Integrated Security=true")
dbconn.Open()
sql="SELECT * FROM Tho_tho"
dbcomm=New OleDbCommand(sql,dbconn)
dbread=dbcomm.ExecuteReader()
Tho_tho.DataSource=dbread
Tho_tho.DataBind()
dbread.Close()
dbconn.Close()
end sub
</script>
------------------------

spda1210:

'Tho_tho'

What is 'Tho_tho'??? You have to add it in aspx

can you please explain a bit clear

 I hope your binding data with asp.net control called "Tho_tho". you need to declare the control in aspx page.

In this line:

Tho_tho.DataSource=dbread

you are trying to bind data to a control that doesn't exist (Tho_tho). I think you might be getting a bit confused here with your table in the database? In your Toolbox, look for a control called GridView and drag it onto your page. Change it's ID to Tho_tho and try building/running the project again.

See if this works for you?

 Tho_tho.DataSource=dbread
Tho_tho.DataBind()

what is Tho_tho?is it a gridview,datagrid ? ..whch control u want to use. u have to  declare Tho_tho  as a asp.net control then u can use this control  

spda1210:

Tho_tho.DataSource=dbread Tho_tho.DataBind()

I think your trying to bind to a dataset which not declared..