SqlDataAdapter data = *****;
DataSet ds = ****;
data.Fill(ds);
ds.WriteXml(string.Format(@"C:\{0}.txt", DateTime.Now.ToString("yyyyMMdd")));