using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;using System.Data.SqlClient;using System.IO;namespace winformDemo{ public partial class Form1 : Form {  public Form1()  {   InitializeComponent();   //讓textBox2隱藏   this.textBox2.Visible = false;   //讓dataGridView1表中的最后一行空值隱藏掉   this.dataGridView1.AllowUserToAddRows = false;  }  SqlConnection con = new SqlConnection();  SqlCommand com = new SqlCommand();  OpenFileDialog open = new OpenFileDialog();  /// <summary>  /// 行  /// </summary>  string ClickRow = "";  /// <summary>  /// 列  /// </summary>  string ClickCells = "";  /// <summary>  /// 行和列相加的字符串  /// </summary>  string SqlLanding = "server=.;uid=sa;pwd=123456789;database=myfirstDemo";  private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)  {   //獲取正在點擊的行和列。   ClickRow = this.dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();   ClickCells = this.dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();  }  private void Form1_Load(object sender, EventArgs e)  {   SelectInfo();  }  public void SelectInfo()  {   //斷開式鏈接查看數據庫數據   con.ConnectionString = SqlLanding;   com.CommandText = "select Name as 文件名,TxtLuJing as 文件路徑 from TxtBianJiQi";   com.Connection = con;   DataSet ds = new DataSet();   SqlDataAdapter sda = new SqlDataAdapter(com);   sda.Fill(ds);   this.dataGridView1.DataSource = ds.Tables[0];  }  private void 打開ToolStripMenuItem_Click(object sender, EventArgs e)  {   string Filepath = ClickCells + ClickRow;   this.textBox2.Visible = true;   try   {    //只讀流；    FileStream fss = new FileStream(Filepath, FileMode.OpenOrCreate, FileAccess.Read);    StreamReader sww = new StreamReader(fss, Encoding.Default);    textBox2.Text = sww.ReadToEnd();    sww.Close();    fss.Close();   }   catch (Exception ex)   {    //如果沒有選擇路徑提示出一句話；    MessageBox.Show("查看路徑錯誤：" + ex.Message);   }  }  private void 保存ToolStripMenuItem_Click(object sender, EventArgs e)  {   string Filepath = ClickCells + ClickRow;   try   {    //只寫流；    FileStream fss = new FileStream(Filepath, FileMode.Create, FileAccess.Write);    StreamWriter sww = new StreamWriter(fss, Encoding.Default);    sww.Write(textBox2.Text);    sww.Close();    fss.Close();    MessageBox.Show("保存成功！");   }   catch (Exception ex)   {    //如果沒有選擇路徑提示出一句話；    MessageBox.Show("保存路徑錯誤：" + ex.Message);   }   this.textBox2.Visible = false;  }  private void 新建ToolStripMenuItem_Click(object sender, EventArgs e)  {   this.textBox2.Text = "";   string localFilePath = "";   string fileNameExt = "";   string flie = "";   SaveFileDialog saveFileDialog = new SaveFileDialog();   //打開默認的文件目錄   saveFileDialog.InitialDirectory = "D:////Text//";   //文件后綴名   saveFileDialog.Filter = "文本文件(*.txt)|*.txt|所有文件(*.*)|*.*";   saveFileDialog.FilterIndex = 2;   string LuJing = saveFileDialog.InitialDirectory;   if (saveFileDialog.ShowDialog() == DialogResult.OK)   {    flie = saveFileDialog.FileName;    //文件目錄名    localFilePath = saveFileDialog.FileName.ToString();    //截取文件名字    fileNameExt = localFilePath.Substring(localFilePath.LastIndexOf("http://") + 1);   }   string sql = "select name from TxtBianJiQi";   SqlCommand co = new SqlCommand(sql, con);   SqlDataAdapter da = new SqlDataAdapter(co);   DataSet dss = new DataSet();   da.Fill(dss);   //循環判斷傳入的表中name   for (int i = 0; i < dss.Tables[0].Rows.Count; i++)   {    //定一個變量去接獲取出來name    string ss = dss.Tables[0].Rows[i][0].ToString();    //判斷對話框里輸入的值是否與查出來的name相同    if (fileNameExt == ss)    {     MessageBox.Show("文件已更改！");     return;    }   }   try   {    //只寫流    FileStream fs = new FileStream(flie, FileMode.Create, FileAccess.Write);    StreamWriter sw = new StreamWriter(fs, Encoding.Default);//對話框另存為。    sw.Write(textBox2.Text);    sw.Flush();    fs.Close();    con.ConnectionString = SqlLanding;    //往數據庫添加 文件名和路徑名 sql語句    com.CommandText = String.Format("insert into TxtBianJiQi(Name,TxtLuJing)values('{0}','{1}')", fileNameExt, LuJing);    com.Connection = con;    con.Open();    int insertInto = Convert.ToInt32(com.ExecuteScalar());    if (insertInto > 0)    {     MessageBox.Show("操作失敗！請重試。");    }    else    {     MessageBox.Show("添加成功！");     this.textBox2.Visible = false;    }   }   catch (Exception ex)   {    MessageBox.Show("添加日志失敗：" + ex.Message);   }   con.Close();   SelectInfo();  }  private void 刪除ToolStripMenuItem_Click(object sender, EventArgs e)  {   con.ConnectionString = SqlLanding;   //從數據庫刪除正在點擊的文件名   com.CommandText = String.Format("delete from TxtBianJiQi where Name='{0}'", ClickRow);   com.Connection = con;   con.Open();   DialogResult dr = MessageBox.Show("確認刪除？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);   if (dr == DialogResult.OK)   {    int insertInto = Convert.ToInt32(com.ExecuteScalar());    if (insertInto > 0)    {     MessageBox.Show("操作失誤！！");    }    else    {     //File.Delete(ClickCells + ClickRow);刪除Windows里的文件，括號里是要刪除文檔的路徑。     File.Delete(ClickCells + ClickRow);     MessageBox.Show("刪除成功！");    }   }   con.Close();   SelectInfo();  }  private void 退出ToolStripMenuItem_Click(object sender, EventArgs e)  {   this.Close();  } }}