/// <summary>
/// 下面要实现的就是将数据库中的数据读取出来,将其保存到文本文件中;
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
string Path = @"D:\AddText.txt";///路径;
string conn = "initial catalog=MyADO;server=.;integrated security=true;";
using(SqlConnection sqlconn=new SqlConnection(conn)){
sqlconn.Open();
using(SqlCommand sqlcmd=sqlconn.CreateCommand()){
sqlcmd.CommandText = "select * from tb_AddUser";
SqlDataReader dr = sqlcmd.ExecuteReader();///读取数据操作;
while(dr.Read()){
string AddContent = "";
string name = dr.GetString(dr.GetOrdinal("AddUserName"));
int age=dr.GetInt32(dr.GetOrdinal("AddAge"));
AddContent=name+'|'+age.ToString();
///将其添加到文本文档中;
if (File.Exists(Path) == false)
{ ///判断该文件是否存在;
MessageBox.Show("该文件不存在!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else {
File.AppendAllText(Path, AddContent); } }
dr.Dispose();
MessageBox.Show("读取完成","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
}} }