Unbound Data Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

harry.verstandig@gmail.com - 24 Jan 2006 01:59 GMT

I am having a problem with asp.net 2.0 that I did not have with 1.1. In
C# code behind, I want to read data via a GetData(int productID) class
to obtain several columns of data from one row of one table in a Sql
2000 database which I need to calculate some values needed to be
inserted into another table. I obtain the parameter (key field) from a
value attribute in a list box on the .aspx page but I can't figure out
what code to use in the calling method to simply pass that parameter to
the GetData() class, and have the required data returned so I can drop
the values into my vars. All the available literature seems to focus on
the new data bound controls. Any help appreciated.

Reply to this Message

Mary Chipman [MSFT] - 31 Jan 2006 02:12 GMT

Instead of attempting this in client code, have you considered
creating a stored procedure to handle the problem? You pass the PK to
the sproc, which performs the computations and inserts the data into
the other table. I'm assuming that the other table exists in the same
database or on the same server.

--Mary

>I am having a problem with asp.net 2.0 that I did not have with 1.1. In
>C# code behind, I want to read data via a GetData(int productID) class
[quoted text clipped - 6 lines]
>the values into my vars. All the available literature seems to focus on
>the new data bound controls. Any help appreciated.

Reply to this Message

Unbound Data Access

Free Magazines