Reference a generated dataset

Question

How would I reference and pull data out of a generated dataset?

I have 2 projects in the same solution.

(1) MyUIProject

(2) MyDataSetProject ->MyGeneratedDataSet.xsd -->-->MyNamesTable (in the dataset)

All I want to do is reference the MyNamesTable and loop through the names in the table and put them in a list box. I'm having trouble getting the records out of the generated dataset.

I'm trying to do something like:

foreach (var name in MyDataSetProject.GeneratedDataSet.MyNamesTable)
{
    MyDropDownList.Items.Add(new ListItem(name));
}

Thanks for any thoughts.

Answer 1

First thing to do is make sure your references are correct between your projects. Right click on your MyUIProject and click Add Reference. Go to the Projects tab and add your MyDataSetProject entry. If it gives you an error about it already have been added, then it's already added.

Second, you need to access your dll project classes from your website. Let's say in your website you have a page called Default.aspx, and in your dll project you have a class called DataSetAccessor, which looks like the following:

public class DataSetAcessor
{
    public DataSet GetDataSet(<arguments>)
    {
        //populate the dataset and return it
    }
}

You can then use this class in your Default page:

//at top
using MyDataSetProject; //this may vary


//down in some method
DataSetAccessor dsa = new DataSetAccessor();
DataSet data = dsa.GetDataSet();

foreach(DataRow row in data.Tables[0].Rows)
{
    //using the values in row to populate your drop down list
}

Hopefully this help.