将txt中的数据存到Sql数据表中

 

将下面txt中的数据存到Sql数据表中

 

a|123434343|邯郸|23|男

b|123434343|保定|21|男

c|242422343|沧州|22|男

d|123434343|邯郸|22|男

e|123434343|邯郸|22|女

string sLine = "";

  string txtFileName = "C:\\Users\\lenovo\\Desktop\\2.txt";

 StreamReader txtReader = new StreamReader(txtFileName, Encoding.Default);

string str = "server=.\\SQLEXPRESS;initial catalog=myfirst;integrated security=true";

            using (SqlConnection con = new SqlConnection(str))

            {

                try

                {

                    do

                    {

                        sLine = txtReader.ReadLine(); //从txt中读取一行(一次读出，一次一行)

 

                        if (sLine == null)

                            break;

 

                        string[] getmessage = sLine.Split('|'); //将读出的字符串按‘|’分割，依次存到字符串数组中

                        using (SqlCommand com = con.CreateCommand())

                        {

                            //将数组中的数据存到t_read表中

                            com.CommandText = "insert into T_read(name,Tel,age,sex,address) values(@name,@tel,@age,@sex,@address) ";

                            SqlParameter name = new SqlParameter("@name", SqlDbType.NVarChar, 20);

                            com.Parameters.Add(name);

                            SqlParameter tel = new SqlParameter("@tel", SqlDbType.Int);

                            com.Parameters.Add(tel);

                            SqlParameter address = new SqlParameter("@address", SqlDbType.NVarChar, 50);

                            com.Parameters.Add(address);

                            SqlParameter age = new SqlParameter("@age", SqlDbType.Int);

                            com.Parameters.Add(age);

                            SqlParameter sex = new SqlParameter("@sex", SqlDbType.Bit);

                            com.Parameters.Add(sex);

 

                            for (int i = 0; i < 5; i++)

                            {

 

                                if (i == 1 || i == 3)

                                {

                                    com.Parameters[i].Value = Convert.ToInt32(getmessage[i]);

                                }

                                else if (i == 4)

                                {

                                    if (getmessage[i] == "男")

                                        com.Parameters[i].Value = "true";

                                    else

                                    {

                                        com.Parameters[i].Value = "false";

                                    }

                                }

                                else

                                {

                                    com.Parameters[i].Value = getmessage[i];

                                }

                            }

                            con.Open();

                            com.ExecuteNonQuery();

                        }

                        con.Close();

                    } while (true);

                    txtReader.Close();

                }

 

                catch (Exception ex)

                {

                    MessageBox.Show(ex.Message.ToString());

                }

                finally

                {

                    if (con.State.ToString() == "Open")

                        con.Close();

                    if (txtReader != null)

                        txtReader.Close();

                }

 

            }