Hi Mike,
Thanks for the quick response. The method I mentioned is returning a DataSet containing 2 DataTables (see code below) (without the method signature):

**********************************************************
DataSet _dsEmployees;
// Invoke DAL object
WorkGroupStatusBoardDAO dataObject = new WorkGroupStatusBoardDAO();
_dsEmployees = dataObject.getWGSBEarnedHoursForEmployeeView(startDate, endDate);

DataRelation dc1;
DataColumn[] parentCols;
DataColumn[] childCols;

if (_dsEmployees != null && _dsEmployees.Tables.Count > 1)

{
parentCols =

new DataColumn[] {

_dsEmployees.Tables[0].Columns[

"EmployeeID"],

_dsEmployees.Tables[0].Columns[

"LogicalDayDate"] };

childCols =

new DataColumn[] {

_dsEmployees.Tables[1].Columns[

"EmployeeID"],

_dsEmployees.Tables[1].Columns[

"LogicalDayDate"] };

new DataRelation("EmployeeEarnedHoursView1",

parentCols,

false);

_dsEmployees.Relations.Add(dc1);

}

return _dsEmployees;

***************************** 

Hence the Front End code gv.Datasource = MyObject.GetAll() 

The method above calls my DAL object that in turns calls a stored procedure which returns two resultsets (two selects). The query within for the 1st resultset is using a Table variable which defines the field names (and the column name in question is the 7th field shown below)

Declare 

@EmployeeStats TABLE

int IDENTITY(1,1) PRIMARY KEY

EmployeeID varchar(20),

varchar(20),

varchar(25),

varchar(12),

float,

float,

float,

float
)

Insert into @EmployeeStats
Select field1,field2,..... from and so on

Then the result of the first DataTable are read from the the @EmployeeStats table var

-- 1st resultset Table[0]
Select FirstName, LastName,LogicalDayDate, AdjustedHours,ActualHours,EarnedHours,Efficiency from @EmployeeStats

-- select results Table[1]
select field1, 2, 3.... from .....

 **********************************************

So all things considered I am bit confused about how it's not picking up the appropriate key. In fact when I view the column in the watch window the Key value is empty.

ANy ideas?

Thanks by the way for the tip on the DataSource/Databind - came over from the "web side" of the fence and wasn't aware of the difference in WinForm apps.

THanks,
Paul

Hi,

I just wanted to know if you were able to solve your issue based on Mike's suggestions or you still need help? Just let me know.

Thank you.

Hi Hristo. Actually I went with a work-around that essentially loops through the first of the two datatables inside the dataset that I am binding to the grid to get my values and then adding them to labels above the grid.

In looking at previous responses I follow what Mike is saying, only the part about telling the grid which resultset I am binding to is not applicable in my case because the goal is to bind both datatables in the dataset (creating two bands) and use of a DataRelation to set the relational fields which is done my business object before the DataSet is returned.

Ideally though, if you guys have a good sample I can look at, that would be great in the event I have to deal these summaries on columns again. Also if the sample could include the SetDataBinding method implementation that would be helpful too.

Thanks,
Paul

Hello ,

I am glad to hear that you were able to find a solution for your issue.

If you isolate your issue in a small sample, in order to be able to reproduce it on my machine, I will try to find the exactly reason, which causes this issue and will be able to give you more specific and appropriate advices for improving of your code, if it could be improved.

I am waiting for your feedback.

Hi Hristo,

I am really not sure I undertand what you mean by isolating a small sample without sending you all of the code related to the operation that binds to the UltraGrid, save for just recommending you try the following:

1) Create DAL class and add a method that returns a DataSet - the method should call a stored procedure that consists of two select statements (select x from Products select y from ProductDetails)

2) Create Business Layer class that calls the DAL class, and method that returns the Dataset which itself returns a DataSet, but prior to returning the DataSet sets up a DataRelation object that associates the data in the first datatable inside the DataSet with the second datatable inside the same dataset, e.g.

public static DataSet getProductDetails()
{

DataSet _ds;
_ds = DAL.getProductDetails();
 
DataRelation dc = new DataRelation("ProductView",
_ds.Tables[0].Columns["ProductID"], _ds.Tables[1].Columns["ProductID"], false);
_ds.Relations.Add(dc);
return _ds;
}

Assuming your Biz Class is called Product, at the UI level do the following in code (Assumes an Ultragrid has been defined in the form) and in the event most appropriate

protected void WinForm1_Load(.....)
{
ugProducts.DataSource = Product.getProductDetails();
}

Also add an InitializeLayout event for the grid ugProducts_InitializeLayout(sender, event)

And inside the Initialize_Layout method try adding one of the 1st or 2nd band's Columns to a Watch window, and specifically looking for the "Key" value in either band's columns - or try to read out the key of a given column and when hitting that line hover over it to see the value of the Key

In all my cases the "Key" s for all my columns are empty. I am doing nothing special to the UltraGrid just simple binding the control from a class method.

Thanks,
Paul

3)

Hello, ­­­­­

I am just checking about the progress of this issue. Let me know If you need any further assistance on this  issue?

Thank you for using Infragistics Components.