Datagrid

G

Guest

I have created a Master-Detail DataGrid

The detail grid is embedded inside the Mastergrid with each row.
Adding the detail grid in ItemDatabound event.



I am exporting the Grid to a Excel.

In the excel sheet only Master grid content shows up and NOT the detail grid??

Why is the detail grid not showing up in the excel??

Thanks
vinay
 
S

Scott Allen

How are you doing the expert? Using Control.Render or some other
technique? Show us some code to help find the problem.
 
G

Guest

Yes i am using the dgReport.RenderControl


Response.Clear()
Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
Dim oStringWriter As New System.IO.StringWriter
Dim oHtmlTextWriter As New System.Web.UI.HtmlTextWriter(oStringWriter)

oHtmlTextWriter.Write("<html><head>")

oHtmlTextWriter.Write("<style>")
oHtmlTextWriter.Write(".dataGridHeader{font-weight: bold;font-size:
8pt;color: black;font-family: Verdana;background-color: #ddddee;text-align:
left;}")
oHtmlTextWriter.Write(".dataGridItemStyle{font-size: 8pt;color:
black;font-family: Verdana;text-align: left;}")

oHtmlTextWriter.Write("</style>")
oHtmlTextWriter.Write("</head><body>")

oHtmlTextWriter.WriteBeginTag("form runat=server ")
oHtmlTextWriter.WriteAttribute("target", "_blank")
oHtmlTextWriter.Write(">")
dgReport.RenderControl(oHtmlTextWriter)
oHtmlTextWriter.Write("</form></body></html>")
Response.Write(oStringWriter.ToString())
Response.End()
 
S

Scott Allen

Hi Vinay:

This code looks good. Any chance you are adding the nested DataGrid
dynamically from code? Can you verify the data bound event is firing
with the debugger?
 
G

Guest

Yes i am adding the Detail DataGrid dynamically ANd the event is Firing.
I can see the master-detail page . But only when i do a Export, detail
dosent show up!!
dgReferret.DataSource = dtAssigned
dgReferret.DataBind()
e.Item.Cells(9).Controls.Add(dgReferret)
 
S

Scott Allen

If this is only happening during a postback though, the Item_DataBound
won't fire unless you have a DataBind on the outer grid. You have to
be careful what events you are using.
 
G

Guest

Scott
I got it !!!
What i did is, when i click button to export to excel.
I did a Databind to the grid, that solved it!!!!!!!!!

Thanks so much for ur idea.
"If this is only happening during a postback though, the Item_DataBound
won't fire unless you have a DataBind on the outer grid"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,780
Messages
2,569,611
Members
45,281
Latest member
Pedroaciny

Latest Threads

Top