ASP.NET

public void GenerateXMLFile(string sFileName)
{
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["newcon"].ConnectionString);
    SqlCommand cmd = new SqlCommand("select * from CATEGORY ", con);
    //SqlCommand cmd1 = new SqlCommand("select * from PRODUCTS ",con);
    cmd.Connection.Open();
    //cmd1.Connection.Open();

    SqlDataReader reader1 = cmd.ExecuteReader();

    //Create XML

    Encoding enc = Encoding.UTF8;
    XmlTextWriter objXMLTW = new XmlTextWriter(sFileName, enc);
    try
    {
        objXMLTW.WriteStartDocument();//xml document open

        //'Top level (Parent element)
        //root node open
        objXMLTW.WriteStartElement("siteMap");

        //first Node of the Menu open
        objXMLTW.WriteStartElement("siteMapNode");

        //Title attribute set
        objXMLTW.WriteAttributeString("title", "Home");
        objXMLTW.WriteAttributeString("description", "This is home");//Description attribute set
        objXMLTW.WriteAttributeString("url", "~/index.aspx");//URL attribute set

        //Loop and create nodes

        while (reader1.Read())
        {
            int MasterID = reader1.GetInt32(0);
            objXMLTW.WriteStartElement("siteMapNode");
            objXMLTW.WriteAttributeString("title", reader1.GetString(1));
            objXMLTW.WriteAttributeString("description", reader1.GetString(5));
            objXMLTW.WriteAttributeString("url", reader1.GetString(11));


            objXMLTW.WriteEndElement();//Close the siteMapNode
        }
        objXMLTW.WriteEndElement();//Close the first siteMapNode
        objXMLTW.WriteEndDocument();//xml document closed
    }
    finally
    {
        objXMLTW.Flush();
        objXMLTW.Close();
        //cmd1.Connection.Close();
        cmd.Connection.Close();
    }
}

public class HttpModule2 : IHttpModule
{
    public void Dispose()
    {

    }
    public void Init(HttpApplication App)
    {

        App.Error += new EventHandler(App_EndRequest);


    }

    void App_EndRequest(object sender, EventArgs e)
    {
        HttpApplication App = (HttpApplication)(sender);
        App.Response.Redirect("Default.aspx",true);
    }

}

  <httpModules>

<add name="ErrorModule" type="HttpModule2"/>
</httpModules>

protected void LinkButton1_Click(object sender, EventArgs e)
    {
        try
        {
            int k = 0;
            int m = 100 / k;
            Response.Redirect("MyTxt.txt");
        }
        catch (Exception ex)
        {
            throw ex;
        }
    
    }

<script type="text/javascript"> 
        function Download(nom_fich) 
        { 
        window.open("Downloadfile.aspx?ar=" + nom_fich,"Download","width=10,height=10,resizable=yes;top=200,left=150,menubar=no,toolbar=no,status=no,location=no");
        } 
</script>

<input id="Bt_Descarga" class="" visible="TRUE" style="width: 100px" type="button" value="Download" onclick="Download(txtFile.text)" />

<asp:Textbox ID="txtFichero" runat="server" CssClass="cuerpopar" Width="100%"></asp:Textbox>  <pre> 

<div class="ForumSig">Time to come clean...

Vive y deja vivir / Live and let live

Javier</div>