| Protected Sub RadGrid1_NeedDataSource(ByVal source As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles RadGrid1.NeedDataSource |
| Dim mc As MembershipUserCollection |
| mc = Membership.GetAllUsers |
| RadGrid1.DataSource = mc |
| End Sub |
DataView detailDT = (DataView)detailGridView.DataSource;
string filename = String.Format("{0}.csv", "ExportDetails");
Response.Clear();
Response.AddHeader("Content-Disposition", "attachment;filename=" + filename);
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
StringWriter stringWriter = new StringWriter();
ArrayList colHeaders = new ArrayList();
ArrayList dataRow = new ArrayList();
//handle forcing Excel from treating file as an "sylk" file
stringWriter.Write(" ");
foreach (DataControlField dataCol in detailGridView.Columns)
{
colHeaders.Add(dataCol.HeaderText);
}
stringWriter.WriteLine(string.Join(",", (string[])colHeaders.ToArray(typeof(string))));
foreach (DataRow dr in detailDT.Table.Rows)
{
foreach (DataColumn dataCol in detailDT.Table.Columns)
{
dataRow.Add(dr[dataCol]);
}
stringWriter.WriteLine(string.Join(",", (string[])dataRow.ToArray(typeof(string))));
dataRow.Clear();
}
Response.Write(stringWriter.ToString());
Response.End();
Thanks
| <td> |
| <h2>Available Features</h2> |
| <telerik:RadListBox ID="RadListBox1" |
| runat="server" |
| AllowTransfer="True" |
| DataKeyField="FeatureId" |
| DataSortField="FeatureId" |
| DataSourceID="FeatureDS" |
| DataTextField="FeatureDescription" |
| DataValueField="FeatureId" |
| TransferToID="RadListBox2" |
| AllowAutomaticUpdates="True" |
| AutoPostBackOnTransfer="True" |
| EmptyMessage="There are no available features." |
| Skin="Office2007" |
| Width="250px"> |
| <ButtonSettings ShowTransferAll="False" /> |
| <EmptyMessageTemplate> |
| There are no available features. |
| </EmptyMessageTemplate> |
| </telerik:RadListBox> |
| </td> |
| <td> |
| <h2>Competitor Features</h2> |
| <telerik:RadListBox |
| runat="server" |
| ID="RadListBox2" |
| DataKeyField="FeatureId" |
| DataSortField="FeatureDescription" |
| DataSourceID="CompetitorFeatureDS" |
| DataTextField="FeatureDescription" |
| AllowAutomaticUpdates="True" |
| EmptyMessage="This competitor has no features assigned." |
| Skin="Office2007" |
| Width="250px"> |
| <ButtonSettings ShowTransferAll="False" /> |
| <EmptyMessageTemplate> |
| This competitor has no features assigned. |
| </EmptyMessageTemplate> |
| </telerik:RadListBox> |
| </td> |
| <%--**************************************************--%> |
| <%--DATA SOURCES--%> |
| <%--**************************************************--%> |
| <pp:ObjectContainerDataSource ID="CompetitorDS" |
| DataObjectTypeName="MagicMindsCRM.Modules.Competitors.BusinessEntities.Competitor" |
| OnUpdated="CompetitorDS_Updated" |
| runat="server" /> |
| <pp:ObjectContainerDataSource ID="CompetitorFeatureDS" |
| DataObjectTypeName="MagicMindsCRM.Modules.Competitors.BusinessEntities.CompetitorFeature" |
| OnDeleted="CompetitorFeatureDS_Deleted" |
| OnInserted="CompetitorFeatureDS_Inserted" |
| runat="server" /> |
| <pp:ObjectContainerDataSource ID="FeatureDS" DataObjectTypeName="MagicMindsCRM.Modules.Competitors.BusinessEntities.Feature" runat="server" |
| OnDeleted="FeatureDS_Deleted" |
| OnInserted="FeatureDS_Inserted" /> |
| <pp:ObjectContainerDataSource ID="CompetitorStatusDS" DataObjectTypeName="MagicMindsCRM.Modules.Competitors.BusinessEntities.CompetitorStatus" runat="server" /> |
'DetailTableDataBind' event it goes againg to 'RadGrid1_preRender' event and bind the nested grid again, so as a result i could not see the detail table data after i expanding the nested grid row.
Please guide me at what solution help to overcome this problem
-Thanks