Hi Friends,

i've a problem so , i've a GridView showing questions from database(i've a SqlDataSource and i bind the data to the control from the stored procedure) like the following :

ID QUESTION LETTER CONTENT
1 Ghjjkllllll A,B,C,D,E Aaa,bbb,ccc,ddd,eee
2 dfhjsdh A,B,C,D,E Fff,ggg,hhh,iii,jjj


i want to take this question and choices and to transfer to a WORD document like the following style :

1)Ghjjkllllll
 A)Aaa
 B)bbb
 C)ccc
 D)ddd
 E)eee

2)dfhjsdh
 A)Fff
 B)ggg
 C)hhh
 D)iii
 E)jjj

i can transfer questions to the word document but choices... i couldnt do it ..!

what can i do? Help me

What you are probably going to have to do is use an HTMLWriter / Table to format the information the way you want.

Your psuedo-code is something like:

//declare table object to be exported to word
//retrieve datasource
//for each row in datasource
     //create new TableRow
     //create new TableCell
        //append data to TableCell
     //add TableCell to TableRow
     //add TableRow to Table
//loop

then to ultimately write the code to the browser you would do something like this:
       System.IO.StringWriter sw = new System.IO.StringWriter();
        HtmlTextWriter hw = new HtmlTextWriter(sw);
        Response.Clear();
        Response.AddHeader("content-disposition", "attachment;filename=test.doc");
        Response.ContentType = "application/vnd.word";

        tbl.RenderControl(hw); //this is your Table object
        Response.Write(sw.ToString());
        Response.End();

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

but i want to transfer this values without table

besides how can i parse Letter and Content Column's values like this

A) aaa
B) bbb
C) ccc
D) ddd
E) eee

As far as I know, one way or the other, you will end up sending some sort of Table to word. That doesn't necesscarily mean the data will be in a tabular format though.

In any event to get the format that you want you would ultimate loop your data source and then split both your Question and Content columns on , you would then loop the resulting string arrays to place the data into the table.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========