Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Populate Datalist on Web User Control

Posted on 2003-12-11
13
341 Views
Last Modified: 2007-12-19
I have a web form(page1.aspx) that requests 4 different recordsets from an sql 2000 server. In the page1 codebehind I bind the first 3 recordsets to 3 different datalists. I would like to bind the 4th recordset to a Datalist that is contained in a user control. I am an intermediate level programmer so details would be great. Thanks in advance
0
Comment
Question by:CUTTHEMUSIC
  • 7
  • 6
13 Comments
 
LVL 8

Expert Comment

by:Dranizz
ID: 9922231
Forget about recordser, think ADO.NET with Datasets and DataTable
0
 
LVL 2

Author Comment

by:CUTTHEMUSIC
ID: 9922244
Dranizz I'm not sure what you mean. Maybe I am using the wrong terms.
0
 
LVL 8

Expert Comment

by:Dranizz
ID: 9922294
Well, in VB.NET we don't use recordset anymore, we use Datasets.
They are real representation of your data in the database, and it's disconnected.

http://visualbasic.about.com/library/weekly/aa041203a.htm

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatadatasetclasstopic.asp
0
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 
LVL 2

Author Comment

by:CUTTHEMUSIC
ID: 9922348
Here is the code that I have

Private Sub getDataAndFill()
        Dim myDataSet As New DataSet
        Dim MyDataAdapter As SqlDataAdapter
        Dim ConString As String = ""
        'CONNECT TO DATABASE
        ConString = ConfigurationSettings.AppSettings("readDbConnString")
        MyDataAdapter = New SqlDataAdapter("Stored_HomePage", ConString)
        MyDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure
        'FILL DATALISTS
        MyDataAdapter.Fill(myDataSet)
        'BLOG ARCHIVE

        DLBlogArchive.DataSource = myDataSet
        DLBlogArchive.DataMember = "Table"
        'BLOG
        DLBlog.DataSource = myDataSet
        DLBlog.DataMember = "Table1"
        'PHOTOS
        DLPopularPhotos.DataSource = myDataSet
        DLPopularPhotos.DataMember = "Table2"
        'LINKS
        DLPopularLinks.DataSource = myDataSet
        DLPopularLinks.DataMember = "Table3"
       
        'BIND
        DLBlogArchive.DataBind()

        DLBlog.DataBind()
        DLPopularPhotos.DataBind()
        DLPopularLinks.DataBind()

    End Sub


the DLBlogArchive is the datalist that I want to put on the web control since many pages will use it.
0
 
LVL 8

Expert Comment

by:Dranizz
ID: 9922404
by the way datalist is the control, Dataset is what you fill, it's a class
what is the problem exactly?
0
 
LVL 2

Author Comment

by:CUTTHEMUSIC
ID: 9922430
I may be using the wrong terms.
I want to store the datalist in blogArchiveList.ascx  and then fill the list from the page1.aspx code behind/
0
 
LVL 8

Expert Comment

by:Dranizz
ID: 9922500
use a session
save it on a session like this

On load

Session("Data")=myDataSet

and to get it back

dim data as Dataset

data=Session("Data")
0
 
LVL 2

Author Comment

by:CUTTHEMUSIC
ID: 9922515
I can't use sessions.
0
 
LVL 8

Expert Comment

by:Dranizz
ID: 9922561
hum...
then use the transfer method

Set to public attributes for your 2 strings in the Page1 class

like

Public Dataset Data;


server.Transfer("Page2.aspx",true);

And at page2 load you'll do this

System.Collections.Specialized.NameValueCollection ColForm;
'Get the data from the source form
colForm=Request.Form

and gets the value from the source form

dim ds as Dataset
ds=  colForm["Data"]
0
 
LVL 2

Author Comment

by:CUTTHEMUSIC
ID: 9922664
can you use server.transfer for a ASCX
0
 
LVL 8

Expert Comment

by:Dranizz
ID: 9922759
no...
You got yourself into something hard...
0
 
LVL 2

Author Comment

by:CUTTHEMUSIC
ID: 9922776
maybe there is a better way then. The reason I am using a ascx page is because the blog archive is something that I want to use on almost every page. In old ASP I would use an include file.
0
 
LVL 8

Accepted Solution

by:
Dranizz earned 250 total points
ID: 9922839
but if you use your ascx in a form and save the dataset in that form, then use the transfer, it could work

That's what I would do.

Use a property in the ascx to indicate the dataset to use or to save
0

Featured Post

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Flash (http://en.wikipedia.org/wiki/Adobe_Flash) has evolved over the years to where it has become a masterful tool for displaying content screen.  It has excellent layout placement, UI precision as well as rendering capabilities. This, along with t…
In my previous two articles we discussed Binary Serialization (http://www.experts-exchange.com/A_4362.html) and XML Serialization (http://www.experts-exchange.com/A_4425.html). In this article we will try to know more about SOAP (Simple Object Acces…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question