将txt中的数据插入到数据库中

最新推荐文章于 2024-09-22 11:17:00 发布

yu851293483

最新推荐文章于 2024-09-22 11:17:00 发布

阅读量456

点赞数

文章标签：数据库 string object insert cmm button

本文链接：https://blog.csdn.net/yu851293483/article/details/7288639

版权

txt中有姓名电话地址年龄性别等数据；

例如：张三 | 87583 | ushfjghg| 18|男

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using System.Data.SqlClient;
using System.Configuration;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        FileStream fs = new FileStream("f:\\1.txt ", FileMode.Open);
        StreamReader sr = new StreamReader(fs,System.Text.Encoding.Default);
        string lingtext = sr.ReadLine();

        while (lingtext != null)
        {
            string[]data= lingtext.Split('|');
            addData(data[0],data[1],data[2],data[3],data[4]);
            lingtext=sr.ReadLine();
        }
    }

    private static void addData(string a,string b,string c,string d,string e)
    {
        string sql = ConfigurationManager.ConnectionStrings["strcon"].ConnectionString;
        using (SqlConnection cnn = new SqlConnection(sql))
        {
            using (SqlCommand cmm = cnn.CreateCommand())
            {

                cmm.CommandText = "insert into info(name,tel,address,age,general) values(@name,@tel,@address,@age,@general)";
                cmm.Parameters.AddWithValue("@name", a);
                cmm.Parameters.AddWithValue("@tel", b);
                cmm.Parameters.AddWithValue("@address", c);
                cmm.Parameters.AddWithValue("@age", d);
                cmm.Parameters.AddWithValue("@general", e);
                cnn.Open();
                cmm.ExecuteNonQuery();
            }
        }
    }
}