Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. LINQ
  4. column order is coming wrong while binding in infragistic ultragrid vb.net

column order is coming wrong while binding in infragistic ultragrid vb.net

Scheduled Pinned Locked Moved LINQ
csharpdatabasewpfwcf
4 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • N Offline
    N Offline
    Nilish
    wrote on last edited by
    #1

    Hi, i am using infragistics ultragrid to display the record with the help of following query

    Dim query = From p In BaseClassDataContext.GetTable(Of CP_Project)() _
    Group Join crt In BaseClassDataContext.GetTable(Of CP_CLM_ClientRating)() _
    On p.RatingID Equals crt.RatingID Into ratingname = Group From c In ratingname.DefaultIfEmpty() _
    Group Join cname In BaseClassDataContext.GetTable(Of CP_CLM_Client)() _
    On cname.ClientID Equals p.ClientID Into clientname = Group From c1 In clientname.DefaultIfEmpty() _
    Group Join pstatus In BaseClassDataContext.GetTable(Of CP_PRJ_ProjectStatus)() _
    On pstatus.ProjectStatusID Equals p.ProjectStatusID Into projectstatus = Group From c2 In projectstatus.DefaultIfEmpty() _
    Group Join pjtype In BaseClassDataContext.GetTable(Of CP_PRJ_ProductType)() _
    On pjtype.ProductTypeID Equals p.ProductTypeID Into pj = Group From projecttype In pj.DefaultIfEmpty() _
    Select c.Rating, p.ProjectName, c1.ClientName, p.StartDate, p.DeliveryDate, c2.ProjectStatus, _
    p.ProjectID, c.RatingColor, projecttype.ProductType

    in vb.net window application. after binding the colown order was totally different clientname , deliverydate ,producttype , projectid , projectname , projectstatus , projectrating , colorrating , startdate this is actually not required. can u help me ?

    P 1 Reply Last reply
    0
    • N Nilish

      Hi, i am using infragistics ultragrid to display the record with the help of following query

      Dim query = From p In BaseClassDataContext.GetTable(Of CP_Project)() _
      Group Join crt In BaseClassDataContext.GetTable(Of CP_CLM_ClientRating)() _
      On p.RatingID Equals crt.RatingID Into ratingname = Group From c In ratingname.DefaultIfEmpty() _
      Group Join cname In BaseClassDataContext.GetTable(Of CP_CLM_Client)() _
      On cname.ClientID Equals p.ClientID Into clientname = Group From c1 In clientname.DefaultIfEmpty() _
      Group Join pstatus In BaseClassDataContext.GetTable(Of CP_PRJ_ProjectStatus)() _
      On pstatus.ProjectStatusID Equals p.ProjectStatusID Into projectstatus = Group From c2 In projectstatus.DefaultIfEmpty() _
      Group Join pjtype In BaseClassDataContext.GetTable(Of CP_PRJ_ProductType)() _
      On pjtype.ProductTypeID Equals p.ProductTypeID Into pj = Group From projecttype In pj.DefaultIfEmpty() _
      Select c.Rating, p.ProjectName, c1.ClientName, p.StartDate, p.DeliveryDate, c2.ProjectStatus, _
      p.ProjectID, c.RatingColor, projecttype.ProductType

      in vb.net window application. after binding the colown order was totally different clientname , deliverydate ,producttype , projectid , projectname , projectstatus , projectrating , colorrating , startdate this is actually not required. can u help me ?

      P Offline
      P Offline
      Pete OHanlon
      wrote on last edited by
      #2

      This was answered here[^]. As it's only a couple of posts below this, perhaps you might have noticed it - especially as you created the orignal post as well.

      Deja View - the feeling that you've seen this post before.

      My blog | My articles

      N 1 Reply Last reply
      0
      • P Pete OHanlon

        This was answered here[^]. As it's only a couple of posts below this, perhaps you might have noticed it - especially as you created the orignal post as well.

        Deja View - the feeling that you've seen this post before.

        My blog | My articles

        N Offline
        N Offline
        Nilish
        wrote on last edited by
        #3

        sir , i know that , but instead of making fun of the issue , May we sort out it's solution. Regards

        P 1 Reply Last reply
        0
        • N Nilish

          sir , i know that , but instead of making fun of the issue , May we sort out it's solution. Regards

          P Offline
          P Offline
          Pete OHanlon
          wrote on last edited by
          #4

          I'm not making fun of the issue. I'm telling you that the answer is there. If you have a problem with the answer, then post the followup on that thread - don't create a new one because: a. It looks like you haven't read the replies to the original post. b. Other people use these forums to find the answers to problems, so if you split your thread up it makes it almost impossible for them to find the answer. c. It looks like you're trying to bump your post to the top.

          Deja View - the feeling that you've seen this post before.

          My blog | My articles

          1 Reply Last reply
          0
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


          • Login

          • Don't have an account? Register

          • Login or register to search.
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • World
          • Users
          • Groups