#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Montreal, Canada
    Posts
    486
    Rep Power
    12

    Can someone explain me DataRow ?


    Hi,
    yeah it's me again

    I have a bif full module where they use Datarow and Dataset, and there is no Comments at all in the owl functions. and in some place it's get really confuse.

    My main problem is that I have kinda some difficult to see how do those works in .net ? It's have changed a bit and it's not clear in my mind how it's work. I have a book on VB.net from Kris Jamsa but they do not talk about those things.

    So if anyone have some explication or some tutorials it's might help me ! thank you !

    here is an exemple of the code I have
    Code:
    drDataRowVille = FindVille(cboVille.Text, frmItems.DataSetVille1)
                If Not (drDataRowVille Is Nothing) Then
                    For Each CboBoxObj In cboRue.Items
                        bTrouve = False
                        For Each drDataRowRue In frmItems.DataSetRue1.Tables("Rue").Rows
                            If CStr(drDataRowRue.Item("rue")).ToUpper = CboBoxObj.ToUpper And _
                            drDataRowRue.Item("noVille") = drDataRowVille.Item("noVille") Then
                                bTrouve = True
                                Exit For
                            End If
                        Next
                        If bTrouve = False Then
                            AjouterRue(CboBoxObj, cboVille.Text)
                        End If
                        AjouterAdresse(CboBoxObj, cboVille.Text, FindReleve(CodeProjet.Text))
                        bTrouve = False
                    Next
    I understand it, how what the guy really wanted to do but I am some problems where the For Each drDataRowRue
    that loop cause me some problems and I am not sure I understand it 100%.
    Last edited by Watever; September 17th, 2003 at 10:48 AM.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Montreal, Canada
    Posts
    486
    Rep Power
    12
    and another thing

    is it possible to add a sort of Query in a datarow or dataset.
    Cause in the program the datarow read each line, one by one to compare them and he also compare the Ville. I would like to add a restriction where the datarow would only have the Rue where the No Ville is ok.

    like select * from Rue where no_ville = X;
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Montreal, Canada
    Posts
    486
    Rep Power
    12
    forget about it ! I think I understand all that more now.

    I am still bugged cause of poor ugly script but I think I will survive.

    is there a way I can delete completely the topic ? or I need to let it there for other people ?

IMN logo majestic logo threadwatch logo seochat tools logo