Dear sir/mam,

   I have spec in c#.det.My spec concept is to retrive the data from the databse.After retrive that data from the database,to save that datas as xml file,before to save that .Database manager query You,If You save or open or cancel.that database manager display the file name,size of the file,thats all.

After You choose to save it is stored as xml file.
I specify my code.But that need some modifications


i=DropDownList1.SelectedItem.Value.ToString();
            j=DropDownList2.SelectedItem.Value.ToString();
            k=DropDownList3.SelectedItem.Value.ToString();
            d=i+"/"+j+"/"+k;

            i1=DropDownList4.SelectedItem.Value.ToString();
            j1=DropDownList5.SelectedItem.Value.ToString();
            k1=DropDownList6.SelectedItem.Value.ToString();
            d1=i1+"/"+j1+"/"+k1;


            fy=DateTime.Now.Year.ToString();
            fm=DateTime.Now.Month.ToString();
            fd=DateTime.Now.Day.ToString();
            fh=DateTime.Now.Hour.ToString();
            fmin=DateTime.Now.Minute.ToString();
            fsec=DateTime.Now.Second.ToString();

            used=fy+fm+fd+fh+fmin+fsec+".xml";


            string c;
            c="User ID=sa;password=tiger;Initial Catalog=tohoweb;Data Source=HEMA";
            try
            {
                c1=new SqlConnection(c);
                string cd="select * from uv_c_sakuhin_lst where release_date >='"+ d +"' and release_date <='"+ d1 +"'";
                SqlDataAdapter ad=new SqlDataAdapter (cd,c1);
                ad.Fill(ds,"uv_c_sakuhin_lst");
                XmlDataDocument xd=new XmlDataDocument(ds);

                xd.Save(".\\"+used);




                                Response.AddHeader( "Content-Disposition", "attachment; filename=" +used );


    string [email protected](".\\"+used);
}