--用ADO.net导入文件内容到数据库
private void button1_Click(object sender, EventArgs e) { //数据导入 if (inputfile.ShowDialog() == DialogResult.OK) { using (FileStream filestream = File.OpenRead(inputfile.FileName)) { using (StreamReader streamreader = new StreamReader(filestream)) { using (SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDBFilename= |DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True")) { conn.Open(); SqlCommand com = conn.CreateCommand(); com.CommandText = "insert into users(username,age) values(@name,@age)"; string line = null; while ((line = streamreader.ReadLine()) != null) { string[] strs = line.Split('|'); string name = strs[0]; int age = Convert.ToInt32(strs[1]); com.Parameters.Clear(); com.Parameters.Add(new SqlParameter("name", name)); com.Parameters.Add(new SqlParameter("age", age)); com.ExecuteNonQuery(); } } } } MessageBox.Show("daoruchenggong"); } } } }
--省市联动跟号码归属地查询
1 private void Form1_Load(object sender, EventArgs e) 2 { 3 using(SqlConnection conn=new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True")) 4 { 5 conn.Open(); 6 using (SqlCommand cmd = conn.CreateCommand()) 7 { 8 cmd.CommandText = "select * from promary"; 9 SqlDataReader reader = cmd.ExecuteReader(); 10 while (reader.Read()) 11 { 12 provionitem item = new provionitem(); 13 item.Id= reader.GetInt32(reader.GetOrdinal("proID")); 14 item.name = reader.GetString(reader.GetOrdinal("proName")); 15 sheng.Items.Add(item); 16 17 } 18 19 20 } 21 22 23 } 24 } 25 26 private void sheng_SelectedIndexChanged(object sender, EventArgs e) 27 { 28 市.Items.Clear(); 29 30 using(SqlConnection conn=new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True")) 31 { 32 conn.Open(); 33 using (SqlCommand cmd = conn.CreateCommand()) 34 { 35 36 provionitem item = (provionitem)sheng.SelectedItem; 37 cmd.CommandText = "select * from city where proID=@proid"; 38 cmd.Parameters.Add(new SqlParameter("proid", item.Id)); 39 SqlDataReader reader = cmd.ExecuteReader(); 40 while (reader.Read()) 41 { 42 provionitem item1 = new provionitem(); 43 item1.name = reader.GetString(reader.GetOrdinal("cityName")); 44 市.Items.Add(item1); 45 46 47 48 } 49 50 51 } 52 } 53 } 54 55 56 } 57 class provionitem 58 { 59 public string name 60 { 61 get; 62 set; } 63 public int Id 64 { 65 get; 66 set; 67 } 68 } 69 }
View Code
private void button1_Click(object sender, EventArgs e) { //弹出一个路径选择框 FolderBrowserDialog fold = new FolderBrowserDialog(); //判断是否选择OK; if (fold.ShowDialog() != DialogResult.OK) { return; } string constr = ConfigurationManager.ConnectionStrings["conn"].ConnectionString; using (SqlConnection conn = new SqlConnection(constr)) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = "delete from phone "; cmd.ExecuteNonQuery(); } } //定义一个路径 string path = fold.SelectedPath; //获得路径下所有为。txt的文件 string[] files = Directory.GetFiles(path, "*.txt", SearchOption.AllDirectories); using (SqlConnection conn = new SqlConnection(constr)) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = "insert into phone(StartNo,EndNo,Name) values(@num1,@num2,@name)"; foreach (string file in files) { string yunyingname = Path.GetFileNameWithoutExtension(file); string[] lines = File.ReadAllLines(file, Encoding.Default); foreach (string line in lines) { string[] str = line.Split('-'); string startnumber = str[0]; string endnumber = str[1]; string name = str[2]; cmd.Parameters.Clear(); cmd.Parameters.Add(new SqlParameter("num1", startnumber)); cmd.Parameters.Add(new SqlParameter("num2", endnumber)); cmd.Parameters.Add(new SqlParameter("name", name + yunyingname)); cmd.ExecuteNonQuery(); } } MessageBox.Show("成功"); } } } private void button2_Click(object sender, EventArgs e) { string constr = ConfigurationManager.ConnectionStrings["conn"].ConnectionString; using (SqlConnection conn = new SqlConnection(constr)) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = "select * from phone where StartNo<=@number and @number>=Endno"; cmd.Parameters.Add(new SqlParameter("number", textBox1.Text)); using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) { string name = reader.GetString(reader.GetOrdinal("Name")); MessageBox.Show(name); } else MessageBox.Show("你输入的号码有误"); } } } } } }