SQL Server 数据导入

ExcuteNonQuery() 返回影响的行数

ExcuteSacalar() 返回第一行的第一列

ExcuteReader() Reader指针，指向表的表头

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace UserInfo
{
    public partial class MainFrm : Form
    {
        public MainFrm()
        {
            InitializeComponent();
        }

        private void btnOpen_Click(object sender, EventArgs e)
        {
            using (OpenFileDialog ofd = new OpenFileDialog())
            {
                ofd.Filter = "文本文件|*.txt";
                if (ofd.ShowDialog()==DialogResult.OK)
                {
                    this.textPath.Text = ofd.FileName;
                    //导入数据
                    ImportData(ofd.FileName);
                }
            }

        }

        //导入数据的方法
        private void ImportData(string fileName)
        {
            string temp = string.Empty;
            using (StreamReader reader=new StreamReader(fileName,Encoding.UTF8))
            {
                //去掉第一行
                reader.ReadLine();
                //string str = "server=.;uid=sa;pwd=tracy05;database=Test";
                string str = ConfigurationManager.ConnectionStrings["sqlConn"].ConnectionString;
                using (SqlConnection conn=new SqlConnection(str))
                {
                    using (SqlCommand cmd=conn.CreateCommand())
                    {
                        conn.Open();
                        while (!string.IsNullOrEmpty(temp = reader.ReadLine()))
                        {
                            var strs = temp.Split(',');
                            string sql = string.Format(@"INSERT INTO 
                                                UserInfo(StuName,StuSex,StuBirthdate,StuPhone) 
                                                VALUES('{0}','{1}','{2}','{3}')",
                                                        strs[1], strs[2], strs[3], strs[4]);
                            cmd.CommandText = sql;
                            cmd.ExecuteNonQuery();
                        }
                    }

                }

            }
        }
    }
}