把文本文件中的内容导入到数据库中

       protected void btnImport_Click(object sender, EventArgs e)
        {
            string connStr = @"data source=.\SQLEXPRESS;initial catalog=Test;User ID=sa;Password=admin";
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                string sql = "select * from Login";
                using (SqlCommand cmd = new SqlCommand(sql, conn))
                {
                    conn.Open();
                    using (SqlDataReader reader = cmd.ExecuteReader())
                    {
                        //判断是否查询出数据
                        if (reader.HasRows)
                        {

                            using (StreamWriter sw = new StreamWriter(@"F:\1109ADO\tclUser.txt"))
                            {

                                while (reader.Read())
                                {
                                    for (int i = 0; i < reader.FieldCount; i++)
                                   //{
                                        object objname = reader.GetValue(1);
                                        object objpwd = reader.GetValue(2);
                                        string line = string.Format("{0},{1}", objname, objpwd);
                                        sw.WriteLine(line);
                                   // }
                                }

                              Response.Write("导出完毕");

                            }
                        }
                        else
                        {
                            Response.Write("数据表中没有数据，没有到处任何数据");
                        }
                    }
                }
            }
        }