473,414 Members | 1,738 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,414 software developers and data experts.

Datagrid

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
Nov 18 '05 #1
7 3200
How are you doing the expert? Using Control.Render or some other
technique? Show us some code to help find the problem.

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Mon, 18 Oct 2004 16:29:03 -0700, "vinay"
<vi***@discussions.microsoft.com> wrote:
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


Nov 18 '05 #2
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()

"Scott Allen" wrote:
How are you doing the expert? Using Control.Render or some other
technique? Show us some code to help find the problem.

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Mon, 18 Oct 2004 16:29:03 -0700, "vinay"
<vi***@discussions.microsoft.com> wrote:
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


Nov 18 '05 #3
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?

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Tue, 19 Oct 2004 08:07:04 -0700, "vinay"
<vi***@discussions.microsoft.com> wrote:
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()

"Scott Allen" wrote:
How are you doing the expert? Using Control.Render or some other
technique? Show us some code to help find the problem.

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Mon, 18 Oct 2004 16:29:03 -0700, "vinay"
<vi***@discussions.microsoft.com> wrote:
>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



Nov 18 '05 #4
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)

"Scott Allen" wrote:
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?

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Tue, 19 Oct 2004 08:07:04 -0700, "vinay"
<vi***@discussions.microsoft.com> wrote:
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()

"Scott Allen" wrote:
How are you doing the expert? Using Control.Render or some other
technique? Show us some code to help find the problem.

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Mon, 18 Oct 2004 16:29:03 -0700, "vinay"
<vi***@discussions.microsoft.com> wrote:

>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


Nov 18 '05 #5
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.

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Tue, 19 Oct 2004 09:29:15 -0700, "vinay"
<vi***@discussions.microsoft.com> wrote:
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)

"Scott Allen" wrote:
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?

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Tue, 19 Oct 2004 08:07:04 -0700, "vinay"
<vi***@discussions.microsoft.com> wrote:
>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()
>
>
>
>
>
>"Scott Allen" wrote:
>
>> How are you doing the expert? Using Control.Render or some other
>> technique? Show us some code to help find the problem.
>>
>> --
>> Scott
>> http://www.OdeToCode.com/blogs/scott/
>>
>> On Mon, 18 Oct 2004 16:29:03 -0700, "vinay"
>> <vi***@discussions.microsoft.com> wrote:
>>
>> >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
>>
>>



Nov 18 '05 #6
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"

"Scott Allen" wrote:
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.

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Tue, 19 Oct 2004 09:29:15 -0700, "vinay"
<vi***@discussions.microsoft.com> wrote:
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)

"Scott Allen" wrote:
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?

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Tue, 19 Oct 2004 08:07:04 -0700, "vinay"
<vi***@discussions.microsoft.com> wrote:

>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()
>
>
>
>
>
>"Scott Allen" wrote:
>
>> How are you doing the expert? Using Control.Render or some other
>> technique? Show us some code to help find the problem.
>>
>> --
>> Scott
>> http://www.OdeToCode.com/blogs/scott/
>>
>> On Mon, 18 Oct 2004 16:29:03 -0700, "vinay"
>> <vi***@discussions.microsoft.com> wrote:
>>
>> >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
>>
>>


Nov 18 '05 #7
That's great, Vinay. Glad I could offer some help.

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Tue, 19 Oct 2004 12:19:10 -0700, "vinay"
<vi***@discussions.microsoft.com> wrote:
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"

"Scott Allen" wrote:


Nov 18 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Ashish Shridharan | last post by:
Hi All I have been trying to add a control to the header cell of a datagrid on my ASP.NET page. These controls are defined in the HTML as ASP.NET web controls. They are being added into the...
3
by: Bill C. | last post by:
Hello, I know this has been discussed a lot already because I've been searching around for information the last few weeks. I'm trying to implement a DataGridComboBoxColumn class. I've found...
5
by: BBFrost | last post by:
Win2000 ..Net 1.1 SP1 c# using Visual Studio Ok, I'm currently in a "knock down - drag out" tussle with the .Net 1.1 datagrid. I've come to realize that a 'block' of rows highlighted within...
2
by: pei_world | last post by:
I want to implement a key hit with enter to dropdown a combobox that is in the datagrid. in this case I need to override its original behaviours. I found some codes from the web. Does anyone know...
1
by: Rick | last post by:
Hello all, I hope all is well with you. I am having a seriously difficult time with this problem. Allow me to set up the problem. I have a System.Web.UI.Page with the following controls...
3
by: CVerma | last post by:
Hi, I have an embedded datagrid within a datalist. I am not able to perfrom paging in the datagrid. Any ideas? Here is my code: Here is my Simplegrid.cs file: using System; using...
2
by: CSL | last post by:
I am using the DataGrid in a Windows Application, how can I adjust the widths of each column individually.
7
by: Dave | last post by:
Are there any add-on products or samples available that can do the following in an vb.net datagrid I want to compare 2 rows in a datagrid - one row from one database and another row for another...
9
by: rn5a | last post by:
A Form has a DataGrid which displays records from a SQL Server 2005 DB table. Users can modify the records using this DataGrid for which I am using EditCommandColumn in the DataGrid. This is the...
2
by: =?Utf-8?B?Y3JlYXZlczA2MjI=?= | last post by:
I have a nested datagrid in a xaml file, the parent datagrid loads the vendor information and the details loads the documents for that vendor in a datagrid. Everything is working fine until I click...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.