Ado.net视频例题

--用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("你输入的号码有误");
                    }
                }
            }
        }
    }
}         

 

 

 

转载于:https://www.cnblogs.com/rebirthgrow/archive/2012/07/24/ado.html