Post
Ask Question
cozyitgirl

cozyitgirl

  • NA
  • 1
  • 0

DataBinding to a nested datagrid inside a data list

Oct 15 2003 12:53 PM
Hi All, I have a datagrid nested inside a datalist. On selection of a manager name from a dropdownlist, my datalist will display the all the team members reporting to him with the datagrid displaying all the customers the team members are working with. I am binding the data to the datagrid based on the unique value from datalist like below. But I want bi-directional sorting to work in the datagrids. And so I tried using session variables. See the code below. protected DataView GetClrEnrAttendance(string RepInit) { //log.Debug(string.Format("RepInit: {0}",RepInit)); //log.Debug(string.Format("MgrInit: {0}",MgrInit)); MgrInit = (string)Session["MgrInit"]; Getdt(); DataSet ds1 = new DataSet(); ds1 = (DataSet)Cache["ClrEnrbyMgr" + MgrInit+BeginDate+EndDate]; if (ds1 == null) { ds1 = DataAccessLayer.GetClrEnrbyMgr(BeginDate,EndDate,MgrInit,strVal); Cache.Insert("ClrEnrbyMgr" + MgrInit+BeginDate+EndDate,ds1,null,DateTime.Now.AddHours(4), TimeSpan.Zero, CacheItemPriority.Default, null); } //ds1.WriteXml("d:\\clr.xml"); //Sort the data DataView Dv = ds1.Tables[0].DefaultView; Dv.RowFilter = string.Format("lead_rep_initial = '{0}'",RepInit); SortExpression = (SortExpression == null) ? "last_first_m" : SortExpression; SDirection = (SDirection == null) ? "ASC" : SDirection; Dv.Sort = SortExpression + " " + SDirection; //log.Debug(Dv.Sort); return Dv; } public void BindDataList(Object sender, DataListItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { // Retrieve the DataGrid control in the current DataListItem. SortableGrid dGrid = (SortableGrid)e.Item.FindControl("DataGrid1"); DataRowView DrV = (DataRowView)e.Item.DataItem; dGrid.DataSourceId = DrV.Row.ItemArray[1].ToString(); if (myHT == null) myHT = new Hashtable(); //foreach(DataGrid dGrid in RepList) myHT.Add(dGrid.ClientID,dGrid.DataSourceId); } } public void SortByColumn(Object sender, DataGridSortCommandEventArgs e) { //make sure the session variables have values if (Session["SortExpression"] == null) { Session["SortExpression"] = "last_first_m"; Session["SDirection"] = "ASC"; } //change sort direction if the previous column sorted is the same as the current column sorted SortExpression = e.SortExpression; if ( SortExpression.Equals(Session["SortExpression"].ToString()) ) { SDirection = (Session["SDirection"].ToString().StartsWith("ASC")) ? "DESC" : "ASC"; } else { SDirection = "ASC"; } //set the session variables to new value Session["SortExpression"] = SortExpression; Session["SDirection"] = SDirection; Hashtable myHashTable = (Hashtable) Session["myHash"]; //Set DataView SortableGrid dGrid = (SortableGrid)sender; string RepId = myHashTable[dGrid.ClientID].ToString(); GetClrEnrAttendance(RepId); DataView Dv = (DataView)dGrid.DataSource; dGrid.DataBind(); } I am having problems binding the data again to the datagrid once the datagrid column is sorted. Does anyone have idea how I can solve this? I am totally lost. I would really appreciate if anyone can help me with this. I have been beating the bush for long time and now I have to solve this problem somehow. I would really appreciate, if you could throw some light in. Thank you so much, Cozyitgirl
<%# DataBinder.Eval(Container.DataItem, "RepName") %>  <%# DataBinder.Eval(Container.DataItem, "RepInit") %>