最好这样:
Sub page_load()
if not ispostback then
dim ds as new dataset()
dim con as sqlconnection
dim ada as sqldataadapter
con=new sqlconnection(configurationsettings.appsettings("sales"))
ada=new sqldataadapter("select companyname,address from customers",con)
ada.fill(ds,"customers")
dg.datasource=ds.tables("customers").defaultview
dg.databind()
end if
End sub
'还要注意数据库中本身是否有数据或满足条件的记录.
Sub page_load()
if not ispostback then
dim ds as new dataset()
dim con as sqlconnection
dim ada as sqldataadapter
con=new sqlconnection(configurationsettings.appsettings("sales"))
ada=new sqldataadapter("select companyname,address from customers",con)
ada.fill(ds,"customers")
dg.datasource=ds.tables("customers").defaultview
dg.databind()
end if
End sub
'还要注意数据库中本身是否有数据或满足条件的记录.
你新建两列命名,在绑定TABLE的变量中添companyname 和address
然后就可以得到数据了,不过象他们说的最好加一个NOT ISPOSTBACK
try
Catch ex As Exception
Response.Write(ex)
End Try可以看看
dim con as sqlconnection
dim ada as sqldataadapter
con=new sqlconnection(configurationsettings.appsettings("sales"))
ada=new sqldataadapter("select companyname,address from customers",con)
ada.fill(ds,"customers")
dg.datasource=ds.tables("customers").defaultview
dg.databind()Catch ex As Exception
Response.Write(ex)
End Try