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. Web Development
  3. ASP.NET
  4. how to retrive database records without using DataTable,DataReader or DataSet

how to retrive database records without using DataTable,DataReader or DataSet

Scheduled Pinned Locked Moved ASP.NET
databasedata-structurestutorial
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.
  • D Offline
    D Offline
    Dharti Gajjar
    wrote on last edited by
    #1

    Is it possible without using Datatable, dataset or datareader , retrive records from database. We can use SqlConnection. Can we retrive using System.Object array. Try read whole databas ,from table retrive one record and display or modify

    N 1 Reply Last reply
    0
    • D Dharti Gajjar

      Is it possible without using Datatable, dataset or datareader , retrive records from database. We can use SqlConnection. Can we retrive using System.Object array. Try read whole databas ,from table retrive one record and display or modify

      N Offline
      N Offline
      N a v a n e e t h
      wrote on last edited by
      #2

      Dharti Gajjar wrote:

      from table retrive one record and display or modify

      ExecuteScalar() ?

      All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia My Website | Ask smart questions

      D 1 Reply Last reply
      0
      • N N a v a n e e t h

        Dharti Gajjar wrote:

        from table retrive one record and display or modify

        ExecuteScalar() ?

        All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia My Website | Ask smart questions

        D Offline
        D Offline
        Dharti Gajjar
        wrote on last edited by
        #3

        but to retrive all records , not one row from databse,but retive table it's row from database and store into system object array

        N 1 Reply Last reply
        0
        • D Dharti Gajjar

          but to retrive all records , not one row from databse,but retive table it's row from database and store into system object array

          N Offline
          N Offline
          N a v a n e e t h
          wrote on last edited by
          #4

          Why do you want to do this ? You can feth data into any of these (Reader/Datatable), and loop through each rows and put it in an array.

          All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia My Website | Ask smart questions

          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