DataTable has now rows in it after fill

[Andre]

I am ruinning this in the global.asa VIA Visual Studio VB .NET (framework 1.1)

I have a access database with a table called tblCounters with a feild called
Counters
with on row of data in it with a number. When I run the following code

Imports System.Data
Imports System.Data.Ole Db

Sub Session_Start.. ....
Dim dbconn As OleDbConnection
Dim dbasp As OleDbDataAdapte r
Dim dbcmd As OleDbCommandBui lder
Dim dbdsn As New Dataset("tblCou nters")
Dim dbtab As New DataTable("Coun ters")
Dim strcon As String
Dim strsql As String
Dim count As Double

Application.Loc k()
strcon = "PROVIDER=Micro soft.Jet.4.0; DATA Source=C:\Folde r\db1.mdb; User
id=admin;passwo rd=;"
strsql = "Select * From tblCounter"
dsconn = New OleDbConnection (strcon)
dbadp = New OleDbDataAdapte r(strsql, dbconn)
dbcmd = New OleDbCommandBui lder(dbadp)
dbadp.Fill(dbds n, "Counters")

At this point I should have filled the dataset dbdsn with a table called
"Counters" with one row of data, right? When I try and run this code

cnt = dbdsn.Rows(0).I tem("Counters")

I get an error that my table has no rows.
When I look in the locals window under dbtab, the rows say 0 also?

Any suggestions?

Thanks

[Marina Levit [MVP]]

You are instnating a connection called 'dsconn', but you are using a
connection called 'dbconn', which from the looks of it, never gets
instantiated. I don't know where 'dsconn' is declared, not in the block you
pasted.

Also, there is no way you could say 'dbdsn.Rows...' , because a dataset does
not have a Rows property.

I would confirm that you are connection to the database you think you are
connecting to, and that this table does indeed have rows in the database.

"Andre" <An***@discussi ons.microsoft.c om> wrote in message
news:5A******** *************** ***********@mic rosoft.com...

I am ruinning this in the global.asa VIA Visual Studio VB .NET (framework
1.1)

I have a access database with a table called tblCounters with a feild
called
Counters
with on row of data in it with a number. When I run the following code

Imports System.Data
Imports System.Data.Ole Db

Sub Session_Start.. ....
Dim dbconn As OleDbConnection
Dim dbasp As OleDbDataAdapte r
Dim dbcmd As OleDbCommandBui lder
Dim dbdsn As New Dataset("tblCou nters")
Dim dbtab As New DataTable("Coun ters")
Dim strcon As String
Dim strsql As String
Dim count As Double

Application.Loc k()
strcon = "PROVIDER=Micro soft.Jet.4.0; DATA Source=C:\Folde r\db1.mdb; User
id=admin;passwo rd=;"
strsql = "Select * From tblCounter"
dsconn = New OleDbConnection (strcon)
dbadp = New OleDbDataAdapte r(strsql, dbconn)
dbcmd = New OleDbCommandBui lder(dbadp)
dbadp.Fill(dbds n, "Counters")

At this point I should have filled the dataset dbdsn with a table called
"Counters" with one row of data, right? When I try and run this code

cnt = dbdsn.Rows(0).I tem("Counters")

I get an error that my table has no rows.
When I look in the locals window under dbtab, the rows say 0 also?

Any suggestions?

Thanks

[Andre]

I did not cut and past, I typed this code so
dsconn should be dbconn
Dim dbasp As OleDbDataAdapte r should be Dim dbadp As OleDbDataAdapte r
cnt = dbtab.Rows(0).I tem("Counters")

Do I have to name the table somewhere when I read it?
"Marina Levit [MVP]" wrote:

You are instnating a connection called 'dsconn', but you are using a
connection called 'dbconn', which from the looks of it, never gets
instantiated. I don't know where 'dsconn' is declared, not in the block you
pasted.

Also, there is no way you could say 'dbdsn.Rows...' , because a dataset does
not have a Rows property.

I would confirm that you are connection to the database you think you are
connecting to, and that this table does indeed have rows in the database.

"Andre" <An***@discussi ons.microsoft.c om> wrote in message
news:5A******** *************** ***********@mic rosoft.com...

I am ruinning this in the global.asa VIA Visual Studio VB .NET (framework
1.1)

I have a access database with a table called tblCounters with a feild
called
Counters
with on row of data in it with a number. When I run the following code

Imports System.Data
Imports System.Data.Ole Db

Sub Session_Start.. ....
Dim dbconn As OleDbConnection
Dim dbasp As OleDbDataAdapte r
Dim dbcmd As OleDbCommandBui lder
Dim dbdsn As New Dataset("tblCou nters")
Dim dbtab As New DataTable("Coun ters")
Dim strcon As String
Dim strsql As String
Dim count As Double

Application.Loc k()
strcon = "PROVIDER=Micro soft.Jet.4.0; DATA Source=C:\Folde r\db1.mdb; User
id=admin;passwo rd=;"
strsql = "Select * From tblCounter"
dsconn = New OleDbConnection (strcon)
dbadp = New OleDbDataAdapte r(strsql, dbconn)
dbcmd = New OleDbCommandBui lder(dbadp)
dbadp.Fill(dbds n, "Counters")

At this point I should have filled the dataset dbdsn with a table called
"Counters" with one row of data, right? When I try and run this code

cnt = dbdsn.Rows(0).I tem("Counters")

I get an error that my table has no rows.
When I look in the locals window under dbtab, the rows say 0 also?

Any suggestions?

Thanks

[Marina Levit [MVP]]

Well, you are filling a dataset called 'dbdsn'. But trying to get data out
of a datatable called 'dbtab'? It's one or the other. Either you fill the
dataset and look in the dataset after for data, or you fill the datatable
and look for your data in the datatable. But you are putting data in one
object, but expecting it to appear in the other?

I think you need to show your actual code, because you have several mistakes
already, and it's hard to help you if we can't even tell what the actual
code is.

"Andre" <An***@discussi ons.microsoft.c om> wrote in message
news:85******** *************** ***********@mic rosoft.com...

I did not cut and past, I typed this code so
dsconn should be dbconn
Dim dbasp As OleDbDataAdapte r should be Dim dbadp As OleDbDataAdapte r
cnt = dbtab.Rows(0).I tem("Counters")

Do I have to name the table somewhere when I read it?
"Marina Levit [MVP]" wrote:

You are instnating a connection called 'dsconn', but you are using a
connection called 'dbconn', which from the looks of it, never gets
instantiated. I don't know where 'dsconn' is declared, not in the block
you
pasted.

Also, there is no way you could say 'dbdsn.Rows...' , because a dataset
does
not have a Rows property.

I would confirm that you are connection to the database you think you are
connecting to, and that this table does indeed have rows in the database.

"Andre" <An***@discussi ons.microsoft.c om> wrote in message
news:5A******** *************** ***********@mic rosoft.com...

>I am ruinning this in the global.asa VIA Visual Studio VB .NET
>(framework
>1.1)
>
> I have a access database with a table called tblCounters with a feild
> called
> Counters
> with on row of data in it with a number. When I run the following code
>
> Imports System.Data
> Imports System.Data.Ole Db
>
> Sub Session_Start.. ....
> Dim dbconn As OleDbConnection
> Dim dbasp As OleDbDataAdapte r
> Dim dbcmd As OleDbCommandBui lder
> Dim dbdsn As New Dataset("tblCou nters")
> Dim dbtab As New DataTable("Coun ters")
> Dim strcon As String
> Dim strsql As String
> Dim count As Double
>
> Application.Loc k()
> strcon = "PROVIDER=Micro soft.Jet.4.0; DATA Source=C:\Folde r\db1.mdb;
> User
> id=admin;passwo rd=;"
> strsql = "Select * From tblCounter"
> dsconn = New OleDbConnection (strcon)
> dbadp = New OleDbDataAdapte r(strsql, dbconn)
> dbcmd = New OleDbCommandBui lder(dbadp)
> dbadp.Fill(dbds n, "Counters")
>
> At this point I should have filled the dataset dbdsn with a table
> called
> "Counters" with one row of data, right? When I try and run this code
>
> cnt = dbdsn.Rows(0).I tem("Counters")
>
> I get an error that my table has no rows.
> When I look in the locals window under dbtab, the rows say 0 also?
>
> Any suggestions?
>
> Thanks
>

[Andre]

found it, I needed to add

dbtab = dbdsn.tables("C ounters")

Thanks.

Sometimes you cant see the trees because of the forest!

"Marina Levit [MVP]" wrote:

You are instnating a connection called 'dsconn', but you are using a
connection called 'dbconn', which from the looks of it, never gets
instantiated. I don't know where 'dsconn' is declared, not in the block you
pasted.

Also, there is no way you could say 'dbdsn.Rows...' , because a dataset does
not have a Rows property.

I would confirm that you are connection to the database you think you are
connecting to, and that this table does indeed have rows in the database.

"Andre" <An***@discussi ons.microsoft.c om> wrote in message
news:5A******** *************** ***********@mic rosoft.com...

I am ruinning this in the global.asa VIA Visual Studio VB .NET (framework
1.1)

I have a access database with a table called tblCounters with a feild
called
Counters
with on row of data in it with a number. When I run the following code

Imports System.Data
Imports System.Data.Ole Db

Sub Session_Start.. ....
Dim dbconn As OleDbConnection
Dim dbasp As OleDbDataAdapte r
Dim dbcmd As OleDbCommandBui lder
Dim dbdsn As New Dataset("tblCou nters")
Dim dbtab As New DataTable("Coun ters")
Dim strcon As String
Dim strsql As String
Dim count As Double

Application.Loc k()
strcon = "PROVIDER=Micro soft.Jet.4.0; DATA Source=C:\Folde r\db1.mdb; User
id=admin;passwo rd=;"
strsql = "Select * From tblCounter"
dsconn = New OleDbConnection (strcon)
dbadp = New OleDbDataAdapte r(strsql, dbconn)
dbcmd = New OleDbCommandBui lder(dbadp)
dbadp.Fill(dbds n, "Counters")

At this point I should have filled the dataset dbdsn with a table called
"Counters" with one row of data, right? When I try and run this code

cnt = dbdsn.Rows(0).I tem("Counters")

I get an error that my table has no rows.
When I look in the locals window under dbtab, the rows say 0 also?

Any suggestions?

Thanks