Results 1 to 5 of 5

Thread: [RESOLVED] Extract data from SQLDataSource

  1. #1

    Thread Starter
    Frenzied Member the182guy's Avatar
    Join Date
    Nov 2005
    Location
    Cheshire, UK
    Posts
    1,473

    Resolved [RESOLVED] Extract data from SQLDataSource

    I have created a SQLDataSource web server control, and i made a repeater and bound the source to the repeater. It works great.

    I was wondering how you would go about extracting data from the SQLDataSource control using VB code. Without binding it to an object.

    Example... say the DataSource control is getting all rows from a table. How would you access the data without binding it to a control?

    Is there a control specifically for this purpose?

    Cheers
    Chris

  2. #2
    Fanatic Member
    Join Date
    May 2005
    Posts
    608

    Re: Extract data from SQLDataSource

    I don't think you can extract it directly from the DataSource object itself.

    The usual ways are filling DataSets or DataReaders.

    Here's the msdn description of the Sql DataSource class: http://msdn2.microsoft.com/en-us/lib...atasource.aspx

    HoraShadow
    Last edited by HoraShadow; Mar 18th, 2007 at 09:51 PM.
    I do like the reward system. If you find that my post was useful, rate it.

  3. #3

    Thread Starter
    Frenzied Member the182guy's Avatar
    Join Date
    Nov 2005
    Location
    Cheshire, UK
    Posts
    1,473

    Re: Extract data from SQLDataSource

    yea didn't think so, I've done it using an SQLClient.

    Cheers
    Chris

  4. #4
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170

    Re: [RESOLVED] Extract data from SQLDataSource

    SqlClient is the namespace. Namespaces don't actually do anything.

    What class did you use within it?

  5. #5
    Fanatic Member
    Join Date
    Apr 2008
    Posts
    778

    Re: [RESOLVED] Extract data from SQLDataSource

    so how is it resolved ? =/

Posting Permissions

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



Click Here to Expand Forum to Full Width