Converting datagrid content to string.

Question

Is it possible to convert data in a datagrid to a string?. I want to send the info in the grid via e-mail and it has to be in the format that the content appears in the datagrid. Thanx

Amit Mishra · Answer

You can use the following code to get to the individual cells of the datagrid and then format the info as you want: foreach(DataGridItem i in myGrid.Items) { if (i.ItemType == ListItemType.Header) { // i is the header row } else if (i.ItemType == ListItemType.Item || i.ItemType == ListItemType.AlternatingItem || i.ItemType == ListItemType.SelectedItem) { //i is one of the data rows // if you want the textbox for e.g. TextBox t = (TextBox)i.FindControl(TextBoxID); ..... } else if (i.ItemType == ListItemType.Footer) { // i is the footer row } }

jaac79 · Answer

It is somewhat complicated. If the DataGrid is associated with a DataSet use DataSet.WriteXml method to convert the contents into a xml file. Create a XSL file and use it to convert the XML file into HTML. I haven't tried this before. But got to try.......... Thanks Jagan Mohan