Web Development

You don't have a join in place. Try this:

Select A.ProjectName, B.ResourceName, B.StartDate
From Project A

INNER JOIN ResourceAllocation B ON A.ProjectID = B.ProjectID


WHERE A.Status = ?Opened?

Good requirement. This feature was a longtime requirement. Having a Join SQL statement can bring data direct from different tables from DB server. But if you already have data in 2 tables in your dataset...I'm not so sure in VS2003. But sure in VS2005. VS2005 sports with new thing called "SELECT". You can query your array, user defined data which is currently in memory. For example create a 2 dimension array with your data. You can run a standard SQL query or T-SQL on this runtime array and get result in a variable/array/structure.
That means at runtime you have a dataset with 2 tables. You can query these two tables at runtime to get one single output directed to a datagrid or so.
Good luck
RV

You have to create a new data table for containing joining records.

//Data Relation
DataTable dt = new DataTable();
DataColumn[] TransactionColumns;
DataColumn[] DetailColumns;
TransactionColumns = new DataColumn[] { ds.Tables["csrvendorsall"].Columns["vnd_cd"] };
DetailColumns = new DataColumn[] { ds.Tables["foobar"].Columns["vnd_cd"] };
DataRelation Tran_Detail = new DataRelation("VendorsCode", TransactionColumns, DetailColumns, false);
ds.Relations.Add(Tran_Detail);
DataTable tbl = new DataTable("Join");
tbl.Columns.Add("vnd_cd", typeof(string));
tbl.Columns.Add("vendorcode", typeof(string));
tbl.Columns.Add("repname", typeof(string));
tbl.Columns.Add("fac_cd", typeof(string));
tbl.Columns.Add("fee", typeof(float));
ds.Tables.Add(tbl);
foreach (DataRow parent in ds.Tables["csrvendorsall"].Rows)
{
foreach (DataRow child in parent.GetChildRows("VendorsCode"))
{
DataRow joinRow = ds.Tables["Join"].NewRow();
joinRow["vnd_cd"] = parent["vnd_cd"];
joinRow["vendorcode"] = parent["vendorcode"];
joinRow["repname"] = parent["repname"];
joinRow["fac_cd"] = child["fac_cd"];
joinRow["fee"] = child["fee"];
ds.Tables["Join"].Rows.Add(joinRow);
}
}

//bind the values to our GridView
GridView1.Caption = "<h4>Loaded the data using Sample4</h4>";
GridView1.DataSource = ds;
GridView1.DataMember = "Join";
GridView1.DataBind();