using System.IO;
using System.Data.OleDb;
private string sql = "";
private string strConnection = @"Provider=Microsoft.Jet.OleDb.4.0;Data Source=./hf.mdb";
OleDbConnection conn = new OleDbConnection();
OleDbCommand cmd = new OleDbCommand();
StreamReader sr = new StreamReader(@"C:/Documents and Settings/M.90F002E5C7904EA/桌面/D512计费系统/20080808.txt");
while (!sr.EndOfStream)
{
string strd = sr.ReadLine().ToString().Trim();
string str = strd.Substring(0,3);
str += strd.Substring(20,6);
//txt +=str;
--以下为写数据库
sql = "insert into hf(fjh,total) values('" + str.Substring(0, 3) + "','" + str.Substring(4) + "')";
cmd.Connection = conn;
conn.Open();
cmd.CommandText = sql.ToString();
cmd.ExecuteNonQuery();
conn.Close();
}
sr.Close();
this.textBox1.Text = txt.ToString();
---另外加点
private void button1_Click(object sender, EventArgs e)
{
System.IO.StreamWriter sr = File.CreateText(".//ly.txt");
sr.Write(this.textBox1.Text);
sr.Close();
}
private void button2_Click(object sender, EventArgs e)
{
StreamReader sr = new StreamReader(".//ly.txt");
string strd="";
while (!sr.EndOfStream)
{
strd = sr.ReadLine().ToString().Trim();
}
MessageBox.Show(strd.ToString());
sr.Close();
}