WebServices exposing DataSet, Consumed by a datagrid

[TK]

Hi,

I need help on datagrid. I have a dataset exposed as a webservice. I do
have a web application that is supposed to consume the service on a
datagrid.

The problem is that in the datagrid only the first record is displayed in
all rows. I have gone throught the code and properties and i dont seem to
spot the problem. I have done similar thing (different webservice and
different dataset) and nothing seem to be behaving.

When I test the webservice, it returns different records, but the DG does
not! i am actually using templates for the columns.

have anyone experienced this or have a solution to this problem. below is a
part of the code.

---

managerID = Context.User.Id entity.Name;

adSearchResults .Text = "You are logged in as " + managerID +
"@domain.or g";
//fill the datagrid
//old
//sqlDataAdapter1 .Fill(dsApplied Leave1);
//bind control to the data set
leave.PreviousL eaveDays.Admini stratorFacade ws =
new leave.PreviousL eaveDays.Admini stratorFacade() ;
ws.Credentials = System.Net.Cred entialCache.Def aultCredentials ;
DataSet DSManager = new DataSet();
DSManager = ws.GetPendingLe aveStatusByMana ger(managerID);
leaveStatusByMa nager.Merge(DSM anager);
//ws.GetPendingLe aveStatusByMana ger(managerID)) ;

if (!Page.IsPostBa ck)
{
//DataGrid1.DataS ource = DSManager;
DataGrid1.DataB ind();
}

}

--

private void DataGrid1_Updat eCommand(object source,
System.Web.UI.W ebControls.Data GridCommandEven tArgs e)
{

//identify the row
string key = DataGrid1.DataK eys[e.Item.ItemInde x].ToString();
//value of the field to change
//TextBox txtEmployee = (TextBox)e.Item .Cells[1].Controls[0];
//txtEmployee.Ena bled = false;
//e.Item.Cells[3].Enabled = false;
DataGrid1.DataB ind();

string changedApproval Type,mgrComment s;

// set the value from what the mananger sets
DropDownList ddl =
(DropDownList)e .Item.FindContr ol("ddlMgrAppro valEdit");
//Label mgrLabel = (Label)e.Item.F indControl("lbl MgrCommentsEdit ");
TextBox mgrTB = (TextBox)e.Item .FindControl("t xtComments");
Label lblUserID = (Label)e.Item.F indControl("lbl EmployeeEdit");
//assign the value of combo to string
changedApproval Type = ddl.SelectedIte m.Value.ToStrin g();
//mgrComments = mgrLabel.Text;
mgrComments = mgrTB.Text;
DataSet newSet = new DataSet();

DataRow row = leaveStatusByMa nager.leaveAppl ication[e.Item.DataSetI ndex];
row[leaveStatusByMa nager.leaveAppl ication.Columns["mgrApprova l"].Caption]
= changedApproval Type;
row[leaveStatusByMa nager.leaveAppl ication.Columns["mgrComment "].Caption]
= mgrComments;

if (leaveStatusByM anager.HasChang es())
{

leave.PreviousL eaveDays.Admini stratorFacade ws =
new leave.PreviousL eaveDays.Admini stratorFacade() ;
ws.Credentials = System.Net.Cred entialCache.Def aultCredentials ;
leave.PreviousL eaveDays.LeaveS tatus diffLeaveStatus =
new leave.PreviousL eaveDays.LeaveS tatus();
diffLeaveStatus .Merge(leaveSta tusByManager.Ge tChanges());
diffLeaveStatus = ws.UpdateLeaveS tatus(diffLeave Status);
leaveStatusByMa nager.Merge(dif fLeaveStatus);
//ws.UpdateLeaveS tatus(diffLeave Status);
//leaveStatusByMa nager.Merge(dif fLeaveStatus);
}

DataGrid1.EditI temIndex = -1;
// bind the datagrid
DataGrid1.DataB ind();
//set mail addresses
string hrAddress = "my**@domain.or g";
string supAddress = managerID+"@dom ain.org";
string userAddress = lblUserID.Text+ "@domain.or g";
//notify HR of the approval or decline
notifyHR(change dApprovalType, hrAddress, supAddress, userAddress);
Response.Redire ct("approve.asp x");

}