这个 文本文件为什么不能导入、我很郁闷。求大神赐教、就是导入后数据库里边没显示！！

Question

namespace 数据导入导出1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }        private void button1_Click(object sender, EventArgs e)
        {
            if (odfimport.ShowDialog() == DialogResult.OK)
            {
                using (FileStream filestream = File.OpenRead(odfimport.FileName))
                {
                    using (StreamReader streamreader = new StreamReader(filestream))
                    {
                        string line = null;
                        while ((line = streamreader.ReadLine()) != null)
                        {
                            string[] strs = line.Split('|');
                            string name = strs[0];
                            int age = Convert.ToInt32(strs[1]);
                            using (SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDBFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=true
"))
                            {
                                conn.Open();
                                using (SqlCommand cmd = conn.CreateCommand())
                                {
                                    cmd.CommandText = "insert into T_Persons(Name,Age) values(@N,@A)";
                                    cmd.Parameters.Add(new SqlParameter("N", name));
                                    cmd.Parameters.Add(new SqlParameter("A", age));
                                    cmd.ExecuteNonQuery();
                                }                            }
                        }
                    }
                }
            }
            MessageBox.Show("导入成功！");
        }
    }
}

Answer 1

cmd.CommandText = "insert into T_Persons([Name],[Age]) values(@N,@A)";
cmd.Parameters.AddWithValue("@N", name);
cmd.Parameters.AddWithValue("@A", age);

Answer 2

哪里错,我就不知道了,但这样修改,会不会更好一点呢?
    using (SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDBFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=true"))
                            {
                                conn.Open();
                                string line = null;
                                while ((line = streamreader.ReadLine()) != null)
                                {
                                    string[] strs = line.Split('|');
                                    string name = strs[0];
                                    int age = Convert.ToInt32(strs[1]);                                    using (SqlCommand cmd = conn.CreateCommand())
                                    {
                                        cmd.CommandText = "insert into T_Persons(Name,Age) values(@N,@A)";
                                        cmd.Parameters.Add(new SqlParameter("@N", name));
                                        cmd.Parameters.Add(new SqlParameter("@A", age));
                                        cmd.ExecuteNonQuery();
                                    }                                }
                            }

Answer 3

导入后你是如何看的没数据，将数据放到页面gridview中看有吗？

Answer 4

就是在数据库中看不到数据！没用gridview控件