Hi;

i use the DataSet to fill a datagrid, and i don´t know how to save the values of a datagrid in a Excell format....

Thanks...

You could save the DataSet in XML format, then open it with Excel.

- A.Kahtava

Hi..here is the code to save the datagrid in excel format. the language used is C#. You will have to pass the dataset that is being used to fill the datagrid as parameter to the function

public static void Convert(DataSet ds ,HttpResponse response)
        {
            //first let's clean up the response.object
            response.Clear();
            response.Buffer = true;
            response.Charset = "";
            response.AddHeader("Content-Disposition", "attachment;filename=Report.xls");

            //set the response mime type for excel
            response.ContentType = "application/vnd.ms-excel";
            //create a string writer

            System.IO.StringWriter stringWrite;
            stringWrite=new System.IO.StringWriter();
            //create an htmltextwriter which uses the stringwriter

            HtmlTextWriter htmlWrite;
            htmlWrite=new System.Web.UI.HtmlTextWriter(stringWrite);
            //instantiate a datagrid
            System.Web.UI.WebControls.DataGrid dg=new System.Web.UI.WebControls.DataGrid();
            //set the datagrid datasource to the dataset passed in
            dg.DataSource = ds.Tables[0];
            //bind the datagrid
            dg.DataBind();
            //tell the datagrid to render itself to our htmltextwriter
            dg.RenderControl(htmlWrite);
            //all that's left is to output the html
            response.Write(stringWrite.ToString());
            response.End();
        }

agarwalvidhu;

thanks for your reply.

but i cant execute the code because the VS dont recognizing the response object.

Can you help me again to solve this problem...


Thanks...

Hi...

where exactly are you using this code..?is it a class file.?In that case did u import required SYstem namespaces..? System.Web is the namespace that contains definition for HttpResponse object. Please check if this namespace is imported in the code or not

Hi agarwalvidhu;

thanks for your reply again.

My problem is: I have a windows application, not a web project in C#, and this application has a windows form with a datagrid.

I create a button to save the datagrid context to a excell format.
To do this i use your example code.

The System.Web namespace was imported correctly and i use the instance of HttpContext, like below, to acess all of the Response propertys and methods.


public static void ConvertXLS(DataSet ds)
        {
            System.Web.HttpResponse response = System.Web.HttpContext.Current.Response;

            //first let's clean up the response.object
            response.Clear();
            response.Buffer = true;
            response.Charset = "";

But in a runtime the line "System.Web.HttpResponse response = System.Web.HttpContext.Current.Response;" provokes an exception like below:
"System.NullReferenceException: Object reference not set to an instance of an object."

Can you help me again???
thanks...

hi there...

the exception occured bcoz i observed that you have declared response object of System.Web.HttpResponse class n while instantiating u have used System.Web.HttpContext.Current.Response class.

Also in windows form too, if u r writing the function in code behind page than u can directly say Response.clear() and access all its properties. If the function is in some other class file then i would suggest u to pass Response object as parameter to this function

C if this thing works out