黑马程序员--手机号码归属地验证

---------------------- Windows Phone 7手机开发、.Net培训、期待与您交流！ ----------------------

数据库数据可以在百度GOOGLE搜一下，有很多。CSDN上也有

将数据导入数据库

        private void button1_Click(object sender, EventArgs e)
        {
            string phoneNo,province,city,areacode,postcode,phoneNoType;
            string connstr = ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;
            if (openFileDialog1.ShowDialog() != DialogResult.OK)
            { return; }
            //using(FileStream filestream=File .OpenRead(openFileDialog1.FileName))
            //{
                using (StreamReader streamreader = new StreamReader(openFileDialog1.FileName,Encoding.Default))
                {

                    using (SqlConnection conn = new SqlConnection(connstr))
                    {
                        conn.Open();
                        using (SqlCommand cmd = conn.CreateCommand())
                        {
                            cmd.CommandText = "insert into phoneNoArea(phoneNo,province,city,areacode,postcode,phoneNoType) values(@phoneNo,@province,@city,@areacode,@postcode,@phoneNoType)";
                            string line = null;
                            while ((line = streamreader.ReadLine()) != null)
                            {
                                MatchCollection mc = regex.Matches(line);
                                string[] strarr = line.Split('-');
                                phoneNo = strarr[1];
                                province = strarr[2];
                                city = strarr[3];
                                areacode = strarr[4];
                                postcode = strarr[5];
                                phoneNoType = strarr[6];
                                cmd.Parameters.Clear();
                                cmd.Parameters.Add("phoneNo", phoneNo);
                                cmd.Parameters.Add("province", province);
                                cmd.Parameters.Add("city", city);
                                cmd.Parameters.Add("areacode", areacode);
                                cmd.Parameters.Add("postcode", postcode);
                                cmd.Parameters.Add("phoneNoType", phoneNoType);
                                cmd.ExecuteNonQuery();

                            }
                        }
                    }
                //}
            }
            MessageBox.Show("导入成功");
        }

以下是验证数据的代码

 private void button2_Click(object sender, EventArgs e)
        {
            string phoneNostr = textBox1.Text.Substring(0,7);
            string connstr = ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;
            using (SqlConnection conn = new SqlConnection(connstr))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "SELECT [PhoneNo],[Province],[City],[AreaCode],[PostCode],[PhoneNoType] FROM [test].[dbo].[PhoneNoArea] where [PhoneNo] =@phoneNo";
                    cmd.Parameters.AddWithValue("phoneNo", phoneNostr);
                    using (SqlDataReader reader = cmd.ExecuteReader())
                    {
                        if (reader.Read())//读取数据，并判断是否为真
                        {
                            string result = reader.GetString(reader.GetOrdinal("Province"));
                            result += " " + reader.GetString(reader.GetOrdinal("city"));
                            result += " " + reader.GetString(reader.GetOrdinal("phoneNoType"));
                            resultlabel1.Text = result;
                        }
                    }
                    
                }
            }
        }

---------------------- Windows Phone 7手机开发、 .Net培训、期待与您交流！ ----------------------详细请查看： http://net.itheima.com/