I don't think that what you're asking for is reasonably possible. This would lead to several problems: - how the client side knows which columns are fetched from which row - what if id X in table has 3 rows in table B, but id Y has two rows, what would be the result etc I would look for alternative solutions for the client side. If the client needs the data in several (undetermine amount) columns based on several rows, fetching the data in such format from the database isn't practical. Could you for example use XML formatting for the data from the database and then use XML data at client or should you fetch the correct rows from the database as they are and handle all the formatting at the client. The correct approach depends on the requirements, what is the client side actually doing. The need to optimize rises from a bad design. My articles[^]

U can use the code in .aspx page inside the content place holder tag,in code behind page in page_load event just type the modal popup control id.show. Eg: popupmsg.show()

Your header row should have as many columns as data rows. So you should modify your data to: Header|| xx|yy|zz aa|bb|cc Footer|| Although you can start from second row using FirstRow=2, note that: The FIRSTROW attribute is not intended to skip column headers. Skipping headers is not supported by the BULK INSERT statement. When skipping rows, the SQL Server Database Engine looks only at the field terminators, and does not validate the data in the fields of skipped rows. The need to optimize rises from a bad design. My articles[^]

Hi, You get the header text this way protected void datagrid_ItemCreated(object sender, DataGridItemEventArgs e) { if (e.Item.ItemType == ListItemType.Header) { string var = e.Item.Cells[0].Text.ToString(); } } Hope this helps :). Regards, John Adams ComponentOne LLC

Did you do the 2nd bit of my post? Add the onclick delcaration to the aspx control. Its currently not specified. you have: you need The answers posted by me are suggestions only and cannot be used in anyway against me.

Try using the Header Template for the headers where you can customize the view of the headers. Or if you have the data come from different data source and one is depenedent on the other try using a repeater for the main data then a grid view for each repeated item. But I am not sure this is your case. Sincerely Samer Abu Rabie

d

Thank you for all help. I find 2 place to put the code to addhandler for button at gridview's header. first at Pageload don't use if not page ispostback second at RowCreated this 2 place have same result .I don't know the best place to put this code but my code is complete .Thank you again to all :-D

Hi Thanks for replying. I want the Excel to have a drop-down list. I have a string of xml like this: xml.txt <?xml version="1.0"?> <?mso-application progid="Excel.Sheet"?> <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns: o ="urn:schemas-microsoft-com:office:office" xmlns: x ="urn:schemas-microsoft-com:office:excel" xmlns:ss ="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html ="http://www.w3.org/TR/REC-html40"> <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"> <Author>Mee</Author> <LastAuthor>Mee</LastAuthor> <Created>2008-05-07T06:18:28Z</Created> <Company>Ram</Company> <Version>11.5606</Version> </DocumentProperties> <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"> <WindowHeight>8700</WindowHeight> <WindowWidth>12315</WindowWidth> <WindowTopX>0</WindowTopX> <WindowTopY>120</WindowTopY> <ProtectStructure>False</ProtectStructure> <ProtectWindows>False</ProtectWindows> </ExcelWorkbook> <Styles> <Style ss:ID="Default" ss:Name="Normal"> <Alignment ss:Vertical="Bottom"/> <Borders/> <Font x:CharSet="222"/> <Interior/> <NumberFormat/> <Protection/> </Style> </Styles> <Names> <NamedRange ss:Name="x" ss:RefersTo="=Sheet2!R1C1:R2C1"/> </Names> <Worksheet ss:Name="Sheet1"> <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1" x:FullColumns="1" x:FullRows="1"> <Row> <Cell><Data ss:Type="String">data</Data></Cell> </Row> </Table> <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> <Selected/> <Panes> <Pane> <Number>3</Number> <ActiveRow>2</ActiveRow> </Pane> </Panes> <ProtectObjects>False</ProtectObjects> <ProtectScenarios>False</ProtectScenarios> </WorksheetOptions> <DataValidation xmlns="urn:schemas-microsoft-com:office:excel"> <Range>R2C1</Range> <Type>List</Type> <Value>x</Value> </DataValidation> </Worksheet> <Worksheet ss:Name="Sheet2"> <Table ss:ExpandedColumnCount="1" ss:Expande