SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Enthusiast
    Join Date
    Feb 2007
    Posts
    90
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Grid in asp.net with access database

    i am developing website which on asp.net n backend is microsoft access

    now i have the grid into it with show 3 colums my questions are

    if i want to add2 more colums which i want to 5 how do i do
    now i want to add records into grid rows and colums rember rows are unlimited i m programmer of vb6 i used to have recordset to map the field how do i add records what technique i used plz write code also n what is datareader etc

    so please provide code that grid is on th epage i have to show records into grid where rows are unlimited

  2. #2
    SitePoint Mentor NightStalker-DNS's Avatar
    Join Date
    Jul 2004
    Location
    Cape Town, South Africa
    Posts
    2,873
    Mentioned
    44 Post(s)
    Tagged
    0 Thread(s)
    As I said in your other thread, I would suggest using another database for web projects.

    Adding columns to a gridview would be done on the design of the page. You can use VS gui tools to help you or you can add columns in the html. You could also set it to auto generate columns.

    Then it will show all the columns that is in your data collection.

    What language are you looking at writing this in? VB.NET?

  3. #3
    SitePoint Enthusiast
    Join Date
    Feb 2007
    Posts
    90
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    vb

  4. #4
    Non-Member
    Join Date
    Sep 2009
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    dear sir you join table and insert data in grid view

  5. #5
    SitePoint Guru Chroniclemaster1's Avatar
    Join Date
    Jun 2007
    Location
    San Diego, CA
    Posts
    784
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Given your background in vb6 and access databases, I suspect it would make more sense to use more of your current skillset, then trying to wrap your head around the entire new .NET philosophy. I would set the GridView to AutoGenerateColumns and then construct your DataSet in SQL and / or with data adapter code. Then you can apply your VB knowledge in VB.NET, and once your DataSet (the .NET version of a recordset) can then just be passed to the GridView which will take care of the rest.
    Whatever you can do or dream you can, begin it.
    Boldness has genius, power and magic in it. Begin it now.

    Chroniclemaster1, Founder of Earth Chronicle
    A Growing History of our Planet, by our Planet, for our Planet.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •