sqlConnection conn=new sqlConnection("/*链接字符串*/")
string sqlstr="insert into tableName values(content)"
sqlCommand cmd=new Sqlcommand(conn,sqlStr)
cmd.executeNonquery()
只是一个思路,你尝试看
下面的是打开文本文件的代码,你打开后,按照我上面说的内容做就可以了
private void fileOpen_Click(object sender, EventArgs e)
{
string path
OpenFileDialog OpenFile = new OpenFileDialog()
OpenFile.Title = "打开"
OpenFile.InitialDirectory = @"桌面"
OpenFile.Filter = "文本文件(*.txt|*.txt*.doc)"
DialogResult drResult = OpenFile.ShowDialog()
if (drResult == DialogResult.OK)
path = OpenFile.FileName
else
return
StreamReader myReader
myReader = new StreamReader(path)
strHeight = myReader.ReadToEnd()
myReader.Close()
}
先不看你对每行是怎么处理的,只看怎么获取每行,代码也显得冗余和容易出错
没必要定义FileStream,没必要使用Seek
while (strLine != null)永远不可能为null,最多为空字符串
参考代码如下
StreamReader sr=new StreamReader(@"c:\1.txt")while (!sr.EndOfStream)
{
string line = sr.ReadLine()
//处理
}
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)