Download multiple Xml file

[Ravindra Nidhonkar]

Following code should solve your problem:

Response.Clear();
Response.ContentType = "text/plain";
Response.WriteFile("D:\\ADIB\\OutputXML.xml");
Response.Flush();

[Palash Biswas]

I wrote my code in VS 2008. Under dialog section of toolbox you can get the specified control. TRY this Code

System.Windows.Forms.SaveFileDialog saveFileDialog = new System.Windows.Forms.SaveFileDialog();

saveFileDialog.Filter = "XML Files (*.xml)|*.*";

if (saveFileDialog.ShowDialog(this) == DialogResult.OK)

{

string FileName = saveFileDialog.FileName;

if (FileName.Trim() != "")

{

// your Code here
}

}

[Tash18]

I did as u said.. but got an error in this line --->

if (saveFileDialog.ShowDialog(this) == DialogResult.OK)

The error stated was ---> The best overloaded method match for 'System.Windows.Forms.CommonDialog.ShowDialog(System.Windows.Forms.IWin32Window)' has some invalid arguments Thanx in advance... Regards, Tash

[Palash Biswas]

try this

if (saveFileDialog.ShowDialog() == DialogResult.OK)

[Tash18]

Hi.. now ther was no build errors but after execution.. when i click my button to create Xml file i receive the following exception ---> It is invalid to show a modal dialog or form when the application is not running in UserInteractive mode. Specify the ServiceNotification or DefaultDesktopOnly style to display a notification from a service application. And the line in which this exception ocuurs -->>

if (saveFileDialog.ShowDialog() == DialogResult.OK)

thanx in advance.. Regards, Tash

[Palash Biswas]

I think you are not use win form application . Is that true if it is then you can't do it using previous procedure.Please use a Custom pop up to do this.

[Tash18]

Ohh no.. so what am i supposed 2 do??? any idea??? regards, tash

[Palash Biswas]

This will help you much , I think it works fine :-D

Response.ContentType = "text/xml";
Response.AppendHeader("Content-Disposition", "attachment; filename=mmm.xml");
Response.TransmitFile(Server.MapPath("~/images/mmm.jpg"));
SqlDataAdapter da = null;
try
{
con = new SqlConnection();
con.ConnectionString = ConfigurationSettings.AppSettings["DSN"];
da = new SqlDataAdapter("select * from card_details", con);
DataSet ds = new DataSet(); da.Fill(ds, "card_details");
ds.WriteXml(Response.OutputStream);
Response.End();
}
catch (SqlException ex)
{
throw new System.Exception("Error -- " + ex.Message);
}
catch (Exception exp)
{
throw new System.Exception("Error -- " + exp.Message);
}
finally
{
con.Close(); da.Dispose();
}

modified on Thursday, February 4, 2010 6:01 AM

[Palash Biswas]

Try this i think it will help you; Response.ContentType = "text/xml"; Response.AppendHeader("Content-Disposition", "attachment; filename=mmm.xml"); Response.TransmitFile(Server.MapPath("~/images/sailbig.jpg")); SqlDataAdapter da = null; try { con = new SqlConnection(); con.ConnectionString = ConfigurationSettings.AppSettings["DSN"]; da = new SqlDataAdapter("select * from card_details", con); DataSet ds = new DataSet(); da.Fill(ds, "card_details"); ds.WriteXml(Response.OutputStream); Response.End(); } catch (SqlException ex) { throw new System.Exception("Error -- " + ex.Message); } catch (Exception exp) { throw new System.Exception("Error -- " + exp.Message); } finally { con.Close(); da.Dispose(); } }

[Palash Biswas]

I think , The below code will help you much

Response.ContentType = "text/xml";
Response.AppendHeader("Content-Disposition", "attachment; filename=mmm.xml");
Response.TransmitFile(Server.MapPath("~/images/mmm.jpg"));
SqlDataAdapter da = null;
try
{
con = new SqlConnection();
con.ConnectionString = ConfigurationSettings.AppSettings["DSN"];
da = new SqlDataAdapter("select * from card_details", con);
DataSet ds = new DataSet(); da.Fill(ds, "card_details");
ds.WriteXml(Response.OutputStream);
Response.End();
}
catch (SqlException ex)
{
throw new System.Exception("Error -- " + ex.Message);
}
catch (Exception exp)
{
throw new System.Exception("Error -- " + exp.Message);
}
finally
{
con.Close(); da.Dispose();
}

[Palash Biswas]

use ...

Response.ContentType = "text/xml";
Response.AppendHeader("Content-Disposition", "attachment; filename=mmm.xml");
Response.TransmitFile(Server.MapPath("~/images/mmm.jpg"));
SqlDataAdapter da = null;
try
{
con = new SqlConnection();
con.ConnectionString = ConfigurationSettings.AppSettings["DSN"];
da = new SqlDataAdapter("select * from card_details", con);
DataSet ds = new DataSet(); da.Fill(ds, "card_details");
ds.WriteXml(Response.OutputStream);
Response.End();
}
catch (SqlException ex)
{
throw new System.Exception("Error -- " + ex.Message);
}
catch (Exception exp)
{
throw new System.Exception("Error -- " + exp.Message);
}
finally
{
con.Close(); da.Dispose();
}