---------------------- Windows Phone 7手机开发、.Net培训、期待与您交流! ----------------------
自己动手做个手机号码归属地实例。
现在数据库中用sql语句创建一个手机号码归属地表(sql语句此处省略,太多了!)
然后再在vs中的新建一个winform程序,绑定好vs与数据库。
最后再在程序运行时开始写如下代码:
Private voidForm1_Load(object sender,EventArgs e)
{
}
Using(SqlConnection conn=new SqlConnetciton(@”DataSource=\SQLSERVER;AttachDbFilename=DataDirectiry|\databas2.mdf;Integratedsecurity=True;User Instance=True”))
{
Conn Open();
Using (SqlCommandcmd=conn.CreateCommand())
{
cmd.CommandTest=”select*from promary”;
using(SqlDataReaderdataReader=cmd.ExecuteReader())
{
While(dataReader.Read())
{
ProvinceItemitem=new ProvinceItem();
Item.Id=dataReader.GetInt32(dataReader.GetOrdinal(“proID”));
Item.Name=dataReader.GetString(dataReader.GetOrdinal(“proName”));
Cmd省.Item.Add(item);
}
}
}
}
Private void cmd省_SelectedIndexchanged(object sender,EventArgs e)
{
ProvinceItemitem=(ProvinceItem)cmd省.SelectedItem;
Int proID=item.Id;
Cmd省.Items.Clear();//清除旧数据
Using(SqlConnection conn=new SqlConnetciton(@”DataSource=\SQLSERVER;AttachDbFilename=DataDirectiry|\databas2.mdf;Integratedsecurity=True;User Instance=True”))
{
Conn Open();
Using (SqlCommandcmd=conn.CreateCommand())
{
cmd.CommandTest=”select*from city where proID=@proID”;
cmd.Paraneers.Add(newSqlParameter(“proID,proID”));
using(SqlDataReaderdataReader=cmd.ExecuteReader())
{
While(dataReader.Read())
{
StringcintyName=dataReader.GetString(dataReader.GetOrdinal(“cityName”));
Cmd市.Item.Add(cityName);
}
}
}
}
}
Private void cmd省_SelectedIndexChanged(object send,EvenArgs e)
{
ProvinceItemitem=(ProvinceItem)cmd省.SelectedItem;
Object obj1=item;
ProvinceItemp2=obj1;
}
Class ProvinceItem
{
Public stringName{get;set;}
Public intId={get;set;}
}
ok!基本搞定!试试运行下,看有结果如何?
代码挺多的慢慢来。有的没有理解透的也慢慢理解,结合代码和实例好好理解!
----------------------Windows Phone 7手机开发、.Net培训、期待与您交流! ---------------------- 详细请查看:http://net.itheima.com/