樱之花

            SqlConnection con=new SqlConnection("server=cxw;database=pubs;user id=sa;password=");
            con.Open ();
            SqlDataAdapter da=new SqlDataAdapter("select * from jobs",con);
            DataSet ds=new DataSet();
            da.Fill(ds);
            con.Close ();
           
            StreamWriter sw =new StreamWriter(Server.MapPath("bin")+"\\test.txt");
            for (int i=0;i<=ds.Tables[0].Rows.Count -1;i++)
            {
                string str=null;
                for (int j=0;j<ds.Tables [0].Columns.Count-1;j++)
                {
                   str+=ds.Tables [0].Rows[i][j].ToString ()+",";  
                }

              sw.WriteLine(str);
            }
            sw.Flush();
            sw.Close();