Basic N-Tiered structure in VB

[Paul]

I have an xsd file called zTest.xsd. In it, I have a DataTable called
CategoryCountByStore, a TableAdapter that is generated automatically called
CategoryCountByStoreTableAdapter, and a GetMethod name
etCategoryCount )which gets the value from a Stored Procedure). Using
Visual Studio 2005 and testing by Preview Data" it works fine, returning an
integer reflecting a SQL Count. (e.g. running the
preview...Results:CategoryCountByStore = 4, for some StoreID that is filled
in in the value column.)

I have a file under the folder App_Code called Stores.vb. In it, I have the
statement:

Public Function CategoryCountByStore(ByVal StoreID As Integer)
Dim CountCategoriesByStore As New
zTestTableAdapters.CategoryCountByStoreTableAdapte r
Return CountCategoriesByStore.GetCategoryCount(StoreID)
End Function

I get no error messages (I know that means little).

Now, I would like to get that value displayed on a WebPage, so I tried, in
the page's code-behind: (The Label2 is in the html section)

Dim myCategoryCount As New Stores
Dim StoreID As Integer = 2
Label2.Text = myCategoryCount.CategoryCountByStore(StoreID).ToSt ring.

But I do not get the value I expected (I get the label saying
CategoryCountByStore).

Could you please go over how to get a value from a DataSet, as Visual Studio
makes easy now, to a Class (object?) and then to the page?

TIA,

Paul

[Jorge Bustos]

Cast "myCategoryCount.CategoryCountByStore(StoreID) " to the appropriate
numeric type before calling to ToString()
"Paul" <Pa***********@TheCornerStore.com> wrote in message
news:Rk*************@fe09.lga...

I have an xsd file called zTest.xsd. In it, I have a DataTable called
CategoryCountByStore, a TableAdapter that is generated automatically called CategoryCountByStoreTableAdapter, and a GetMethod name
etCategoryCount )which gets the value from a Stored Procedure). Using
Visual Studio 2005 and testing by Preview Data" it works fine, returning an integer reflecting a SQL Count. (e.g. running the
preview...Results:CategoryCountByStore = 4, for some StoreID that is filled in in the value column.)

I have a file under the folder App_Code called Stores.vb. In it, I have the statement:

Public Function CategoryCountByStore(ByVal StoreID As Integer)
Dim CountCategoriesByStore As New
zTestTableAdapters.CategoryCountByStoreTableAdapte r
Return CountCategoriesByStore.GetCategoryCount(StoreID)
End Function

I get no error messages (I know that means little).

Now, I would like to get that value displayed on a WebPage, so I tried, in
the page's code-behind: (The Label2 is in the html section)

Dim myCategoryCount As New Stores
Dim StoreID As Integer = 2
Label2.Text = myCategoryCount.CategoryCountByStore(StoreID).ToSt ring.

But I do not get the value I expected (I get the label saying
CategoryCountByStore).

Could you please go over how to get a value from a DataSet, as Visual Studio makes easy now, to a Class (object?) and then to the page?

TIA,

Paul

[Paul]

Thanks. Where would I cast?
"Jorge Bustos" <jb*****@teleline.es> wrote in message
news:eC**************@TK2MSFTNGP03.phx.gbl...

Cast "myCategoryCount.CategoryCountByStore(StoreID) " to the appropriate
numeric type before calling to ToString()
"Paul" <Pa***********@TheCornerStore.com> wrote in message
news:Rk*************@fe09.lga...

I have an xsd file called zTest.xsd. In it, I have a DataTable called
CategoryCountByStore, a TableAdapter that is generated automatically

called

CategoryCountByStoreTableAdapter, and a GetMethod name
etCategoryCount )which gets the value from a Stored Procedure). Using
Visual Studio 2005 and testing by Preview Data" it works fine, returning

an

integer reflecting a SQL Count. (e.g. running the
preview...Results:CategoryCountByStore = 4, for some StoreID that is

filled

in in the value column.)

I have a file under the folder App_Code called Stores.vb. In it, I have

the

statement:

Public Function CategoryCountByStore(ByVal StoreID As Integer)
Dim CountCategoriesByStore As New
zTestTableAdapters.CategoryCountByStoreTableAdapte r
Return CountCategoriesByStore.GetCategoryCount(StoreID)
End Function

I get no error messages (I know that means little).

Now, I would like to get that value displayed on a WebPage, so I tried,
in
the page's code-behind: (The Label2 is in the html section)

Dim myCategoryCount As New Stores
Dim StoreID As Integer = 2
Label2.Text = myCategoryCount.CategoryCountByStore(StoreID).ToSt ring.

But I do not get the value I expected (I get the label saying
CategoryCountByStore).

Could you please go over how to get a value from a DataSet, as Visual

Studio

makes easy now, to a Class (object?) and then to the page?

TIA,

Paul

[Jorge Bustos]

You should so something like this (I don't use VB, but C#, anyway I think
this is VB's way to do it):

myCategoryCount.CategoryCountByStore(StoreID)
returns a generic object.

CType(int, myCategoryCount.CategoryCountByStore(StoreID))
-> This converts the generic object to a int (You should choose the
appropriate type)

CType(int, myCategoryCount.CategoryCountByStore(StoreID)).ToS tring()
-> this hopefully will return just what you want

Let me know if this solves your problem.

Jorge
"Paul" <Pa***********@TheCornerStore.com> wrote in message
news:Lc***********@fe08.lga...

Thanks. Where would I cast?
"Jorge Bustos" <jb*****@teleline.es> wrote in message
news:eC**************@TK2MSFTNGP03.phx.gbl...

Cast "myCategoryCount.CategoryCountByStore(StoreID) " to the appropriate
numeric type before calling to ToString()
"Paul" <Pa***********@TheCornerStore.com> wrote in message
news:Rk*************@fe09.lga...

I have an xsd file called zTest.xsd. In it, I have a DataTable called
CategoryCountByStore, a TableAdapter that is generated automatically

called

CategoryCountByStoreTableAdapter, and a GetMethod name
etCategoryCount )which gets the value from a Stored Procedure). Using
Visual Studio 2005 and testing by Preview Data" it works fine,

returning an

integer reflecting a SQL Count. (e.g. running the
preview...Results:CategoryCountByStore = 4, for some StoreID that is

filled

in in the value column.)

I have a file under the folder App_Code called Stores.vb. In it, I

have the

statement:

Public Function CategoryCountByStore(ByVal StoreID As Integer)
Dim CountCategoriesByStore As New
zTestTableAdapters.CategoryCountByStoreTableAdapte r
Return CountCategoriesByStore.GetCategoryCount(StoreID)
End Function

I get no error messages (I know that means little).

Now, I would like to get that value displayed on a WebPage, so I tried,
in
the page's code-behind: (The Label2 is in the html section)

Dim myCategoryCount As New Stores
Dim StoreID As Integer = 2
Label2.Text = myCategoryCount.CategoryCountByStore(StoreID).ToSt ring.

But I do not get the value I expected (I get the label saying
CategoryCountByStore).

Could you please go over how to get a value from a DataSet, as Visual

Studio

makes easy now, to a Class (object?) and then to the page?

TIA,

Paul