How store results of SqlDataSource SELECT statement?

[VB Programmer]

I have a SqlDataSource I setup on an ASP.NET 2.0 webform.

I setup the SELECT statement and it has 1 parameter, @ProductId.

How do I, using VB.NET, store the results of that SELECT statement into a
datatable or dataview, for example?

Here's partial code...
Dim ds As New DataSet
Dim dv As New DataView

For Each i As CartItem In Profile.MyShopp ingCart.CartIte ms

' SET THE SELECT PARAMETER
Me.sdsFreeShip. SelectParameter s("ProductId"). DefaultValue =
i.ID.Trim

' ERROR HERE... TRYING TO GET RESULTS OF SELECT AND STORE IT IN
dv VAR
' (Argument not specified error)
dv = Me.sdsFreeShip. Select

If dv.Table.Rows.C ount = 0 Then
' include in total
MyTotal += i.Price * i.Quantity
End If
Next

Thanks

[Nanda Lella[MSFT]]

In the aspx page, for your DataTable or DataView you can set the
"DataSource Id" property as the name of your SqlDataSource.
--------------------

>From: "VB Programmer" <do**********@s omewhere.com>
Subject: How store results of SqlDataSource SELECT statement?
Date: Thu, 17 Aug 2006 14:29:00 -0400
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
Message-ID: <e4************ *@TK2MSFTNGP05. phx.gbl>
Newsgroups: microsoft.publi c.dotnet.framew ork.aspnet
NNTP-Posting-Host: 110.196.205.68. cfl.res.rr.com 68.205.196.110
Path: TK2MSFTNGXA01.p hx.gbl!TK2MSFTN GP01.phx.gbl!TK 2MSFTNGP05.phx. gbl
Xref: TK2MSFTNGXA01.p hx.gbl microsoft.publi c.dotnet.framew ork.aspnet:4140 55
X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.aspnet

I have a SqlDataSource I setup on an ASP.NET 2.0 webform.

I setup the SELECT statement and it has 1 parameter, @ProductId.

How do I, using VB.NET, store the results of that SELECT statement into a
datatable or dataview, for example?

Here's partial code...
Dim ds As New DataSet
Dim dv As New DataView

For Each i As CartItem In Profile.MyShopp ingCart.CartIte ms

' SET THE SELECT PARAMETER
Me.sdsFreeShip. SelectParameter s("ProductId"). DefaultValue =
i.ID.Trim

' ERROR HERE... TRYING TO GET RESULTS OF SELECT AND STORE IT

IN

>dv VAR
' (Argument not specified error)
dv = Me.sdsFreeShip. Select

If dv.Table.Rows.C ount = 0 Then
' include in total
MyTotal += i.Price * i.Quantity
End If
Next

Thanks

--

Thank You,
Nanda Lella,

This Posting is provided "AS IS" with no warranties, and confers no rights.