	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

9.3

How to loop through rows of strongly typed dataset table in VB

Asked by davidcahan in Programming for ASP.NET

below is my XSD file, my Class and the call to each from my main page. I'm stuck on how to loop through my strongly typed dataset once i have it populated with data. Meaning loop through it in such as way as to take advantage of the strongly typed

So something like below (which doesn't work at all)

For each Row in Foobar
Response.write(Row.FirstName)
NExt

View the Solution FREE for 30 Days

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:

           
           
             XSD (Foobar.xsd)
<?xml version="1.0" encoding="utf-8" ?>
<xs:schema id="FooBar"
                  targetNamespace="http://tempuri.org/FooBar.xsd"
                  elementFormDefault="qualified"
                  attributeFormDefault="qualified"
                  xmlns="http://tempuri.org/FooBar.xsd"
                  xmlns:mstns="http://tempuri.org/FooBar.xsd"
                  xmlns:xs="http://www.w3.org/2001/XMLSchema"
                  xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
  <xs:element name="FooBar" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
    <xs:complexType>
      <xs:sequence>
        <xs:element name="IndividualID" type="xs:int" />
        <xs:element name="DefaultHotel" type="xs:string" />
        <xs:element name="IndividualLevelTypeID" type="xs:int" />
        <xs:element name="IndividualLevelTypeCode" type="xs:string" />
        <xs:element name="IndividualLevelType" type="xs:string" />
        <xs:element name="ExternalID" type="xs:string" />
        <xs:element name="LanguageTypeID" type="xs:int" />
        <xs:element name="FirstName" type="xs:string" />
        <xs:element name="LastName" type="xs:string" />
        <xs:element name="Address1" type="xs:string" />
        <xs:element name="Address2" type="xs:string" />
        <xs:element name="City" type="xs:string" />
        <xs:element name="State" type="xs:string" />
        <xs:element name="PostalCode" type="xs:string" />
        <xs:element name="Country" type="xs:string" />
        <xs:element name="EmailAddress" type="xs:string" />
        <xs:element name="HomePhone" type="xs:string" />
        <xs:element name="CellPhone" type="xs:string" />
        <xs:element name="Pwd" type="xs:string" />
        <xs:element name="SpouseName" type="xs:string" />
        <xs:element name="DateAdded" type="xs:string" />
        <xs:element name="DateModified" type="xs:string" />
        <xs:element name="Language" type="xs:string" />
      </xs:sequence>
    </xs:complexType>
  </xs:element>
</xs:schema>
 
 
Individuals.vb (in the same folder as FooBar.xsd)
Imports Microsoft.VisualBasic
Imports System.Data.SqlClient
Imports System
Imports System.Data
Imports System.Web.UI.WebControls
 
Public Class Individuals
 
 
 
    Public Function SelectIndividuals(ByVal IndividualID As String, _
                                                 ByVal DateRangeStart As String, _
                                                 ByVal DateRangeEnd As String, _
                                                 ByVal PhoneNumber As String, _
                                                 ByVal LastName As String, _
                                                 ByVal ExternalID As String, _
                                                 ByVal IndividualLevelType As String, _
                                                 ByVal Active As String) As FooBar
 
        Using objConn As SqlConnection = New SqlConnection(System.Configuration.ConfigurationManager.AppSettings("strConn"))
            Using oCom As SqlCommand = New SqlCommand
                oCom.Connection = objConn
                oCom.CommandText = "SelectIndividuals"
                oCom.CommandType = CommandType.StoredProcedure
                oCom.Parameters.Add(New SqlParameter("@IndividualID", SqlDbType.VarChar)).Value = IndividualID
                oCom.Parameters.Add(New SqlParameter("@DateRangeStart", SqlDbType.VarChar)).Value = DateRangeStart
                oCom.Parameters.Add(New SqlParameter("@DateRangeEnd", SqlDbType.VarChar)).Value = DateRangeEnd
                oCom.Parameters.Add(New SqlParameter("@PhoneNumber", SqlDbType.VarChar)).Value = PhoneNumber
                oCom.Parameters.Add(New SqlParameter("@LastName", SqlDbType.VarChar)).Value = LastName
                oCom.Parameters.Add(New SqlParameter("@ExternalID", SqlDbType.VarChar)).Value = ExternalID
                oCom.Parameters.Add(New SqlParameter("@IndividualLevelType", SqlDbType.VarChar)).Value = IndividualLevelType
                oCom.Parameters.Add(New SqlParameter("@Active", SqlDbType.VarChar)).Value = Active
                objConn.Open()
                Using dA As New SqlDataAdapter
                    Using dS As New FooBar
                        dA.SelectCommand = oCom
                        dA.Fill(dS)
                        Return dS
                    End Using
                End Using
            End Using
        End Using
    End Function
 
   
End Class
 
 
MainPage.aspx.vb
    Protected Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim dsSet As New FooBar
        Dim i As New Individuals
 
        dsSet = i.SelectIndividuals("", "", "", "", "", "", "", "1")
 
 
    End Sub

           
         

How to loop through rows of strongly typed dataset table in VB

Asked by davidcahan in Programming for ASP.NET

About this solution