savetotxt.txt

来自「c# 将数据库中的数据以文本格式保存到硬盘上」· 文本 代码 · 共 37 行

		protected void Button_Save(object sender, System.EventArgs e)
		{
			string connectionString = "server=clj;database=test;uid=sa;pwd=sa";
			//string connectionString = "server="+ server.Text +";database="+ DBName.Text +";uid="+ uid.Text +";pwd="+ pwd.Text;
			SqlConnection mySqlConnection = new SqlConnection(connectionString);
			string selectString = "select FileName,Remarks from aa";
			//string selectString = SearchString.Text;
			SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
			mySqlCommand.CommandText = selectString;
			SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();
			mySqlDataAdapter.SelectCommand = mySqlCommand;
			DataSet myDataSet = new DataSet();
			mySqlConnection.Open();
			mySqlDataAdapter.Fill(myDataSet,"aa");
			//mySqlDataAdapter.Fill(myDataSet,tableName.Text);

			StreamWriter rw = File.CreateText(Server.MapPath(".") + "\\aa.txt");
			//StreamWriter rw = File.CreateText(pathBack.Text);
			
			//for(int i=0;i<=myDataSet.Tables["aa"].Rows.Count-1;i++)
			for(int i=0;i<=myDataSet.Tables[tableName.Text].Rows.Count-1;i++)
			{
				StringBuilder putin = new StringBuilder();
				for(int j=0;j<=myDataSet.Tables["aa"].Columns.Count-1;j++)
				//for(int j=0;j<myDataSet.Tables[tableName.Text].Columns.Count-1;j++)
				{
					putin.Append(myDataSet.Tables["aa"].Rows[i][j].ToString());
					//if(j<myDataSet.Tables["aa"].Columns.Count-1) //用逗号隔开
					//{
					//	putin.Append(",");
					//}
				}	
				rw.WriteLine(putin.ToString());
			}
			rw.Close();		
		}