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. is it good to use : SqlDataSource

is it good to use : SqlDataSource

Scheduled Pinned Locked Moved ASP.NET
question
3 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.
  • A Offline
    A Offline
    Amit Kumar G
    wrote on last edited by
    #1

    Is it better to use SqlDataSource in 2.0 ? Wht is ur view.... Because the power of sqldatasource is very impressive. I don't need to write any data datareader code, it can return dataset/data reader in form of dataview.... I am confuse, should i use this or not in my DAL layer. pl share your experience... Thx Amit Thx

    G 1 Reply Last reply
    0
    • A Amit Kumar G

      Is it better to use SqlDataSource in 2.0 ? Wht is ur view.... Because the power of sqldatasource is very impressive. I don't need to write any data datareader code, it can return dataset/data reader in form of dataview.... I am confuse, should i use this or not in my DAL layer. pl share your experience... Thx Amit Thx

      G Offline
      G Offline
      goradaranaresh
      wrote on last edited by
      #2

      Yaa of cource you can use the SqlDataSource 2.0. New development is for more userfriendliness. And in the SqlDataSource 2.0 we have to do little to work. You should't use the SqlDataReader in any simple condition. naresh patel

      A 1 Reply Last reply
      0
      • G goradaranaresh

        Yaa of cource you can use the SqlDataSource 2.0. New development is for more userfriendliness. And in the SqlDataSource 2.0 we have to do little to work. You should't use the SqlDataReader in any simple condition. naresh patel

        A Offline
        A Offline
        Amit Kumar G
        wrote on last edited by
        #3

        Thanks Naresh...Could you help me with the below query also.. Hi All I am working with SQL Datasource thru program logic. I am fine till the time my stored procedure returns single result set. I can read the dataview and the return values also. But how i can read values, if my SP return multiple result set? For exmaple Select Name from table Select webage from Table1 Any help, Amit

        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