holic戾停更了吗:数据库里ip地址转换问题 (asp.net)

来源:百度文库 编辑:高校问答 时间:2024/05/01 00:19:21
我把山湖虫的QQIP库导入了Access数据库中,格式是:
startip(字符) endip(字符) province(字符)
192.168.0.1 255.255.255.0 局域网
127.0.0.1 127.0.0.1 个人电脑
.............(下面还有好多数据)
类试这样的,我想把里面的ip地址都转换成192168000001形式的,这样我好做比较IP来查询province字段,以下是我写的代码:
internal string IP2string (string ip)
{
string[] strs = ip.Split('.');
System.Text.StringBuilder builder = new System.Text.StringBuilder();
foreach( string s in strs )
{
int num = Int32.Parse(s);
builder.Append(num.ToString("000"));
}
return builder.ToString();
}

private void Button1_Click(object sender, System.EventArgs e)
{
OleDbConnection con=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("db1.mdb"));
con.Open();
OleDbCommand cmd=new OleDbCommand("select * from ip",con);
OleDbDataReader oddr=cmd.ExecuteReader();
oddr.Read();
string endip=this.IP2string(Convert.ToString((oddr["startup"])));
oddr.Close();

cmd=new OleDbCommand("update ip set startup="+endip,con);
cmd.ExecuteNonQuery();
}

楼上说的太难啦,用代理好些