using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;u ...
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("\\") + 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();
}
}
}
就是寫了一個挺簡單的在winform里進行填寫文本，裡面用到的ADO.NET來鏈接資料庫，在新建文本的時候需要寫入.txt尾碼名，打開或者是刪除的時候需要先點擊一下文本名。 寫的不足請見諒！
