E:\web\learnaspcom\htdocs\freebook\learn\ubtoc.xml LearnAsp.com - ASP ASP.net Free Lessons
Search Search

#1 worldwide
FREE Coding Lessons

since 1996
   THE BEST WAY to learn ASP & Asp.net!
Advertise Here!
click for details
Credits Host:
DiscountASP.net
Server Admin:
The "Team"
Contact Info.
Charles M. Carroll
<Asp.net blog>
<personal site>
xxx

Utility Belt: Sproc to DataTable Demo
by Charles Carroll

The code below calls "Utility Belt" functions.

Here is the Sproc to DataTable sample:

   filename=/experiments/utilitybelt/vercurrent//ubdemo_sp_datatable.aspx

<Test Script Below>


<%@ debug="true" %>
<%@ Assembly src="utilitybelt.vb" %>
<script language="VB" runat="server">
    dim ub1 as new LearnAsp.utilitybelt()
    dim strConnect as string="learnaspsamplesfull"
Sub Page_Load(S As Object, E As EventArgs)
    ub1.Options("debug-on,xray-to-page=on")
    dim dt1 as new system.data.datatable
    ub1.spDBPopulate(strConnect,"SearchCSZ",dt1,"@city","USA")

    dim dr1 as system.data.datarow
    Page.Controls.Add(new literalcontrol("count=" & dt1.rows.count & "<br>"))
    FOR each dr1 in dt1.rows
        Page.Controls.Add(new literalcontrol(dr1("Name") & "<br>"))
    NEXT    
    
End Sub
</script>
<html><head>
<title>Utility Belt Demo</title>
</head>
<body bgcolor="#FFFFFF">
<form runat="server"></form>
</body></html>
There are many worthy charities!!. But perhaps help starving children in Africa or South America AND help Charles too. a $5 tip buys him lunch at McDonalds, a $20 tip buys his kid Hitoshi a new computer game, a $39 tip buys his daughter Michiko a few nice outfits. See our donor list.