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();
评论