ASP.net does IP access restrictions

Accidentally when do message this think of do so, the specific train of thought may not be good, do just throw out a brick to lead a jade, hope to have a better method!

IP adds pages with one ListBox, TextBox, and two Button, while on other pages it compares IP in the database directly with the current IP. The code is as follows!

Limit IP to add page HTML code

< %@ Page Language="C#" AutoEventWireup="true" CodeFile="ip.aspx.cs" Inherits="admin_ip" % >
< !DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" >
< html xmlns="http://www.w3.org/1999/xhtml" >
< head runat="server" >
      < title > No title page < /title >
      < link href="../images/news.css" rel="stylesheet" type="text/css" / >
< /head >
< body >
      < form id="form1" runat="server" >
      < div >
              < asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString=" < %$ ConnectionStrings:book % > "
                      ProviderName=" < %$ ConnectionStrings:book.ProviderName % > " SelectCommand="SELECT [ip] FROM [ip]" >
              < /asp:SqlDataSource >
              < table align="center" style="border-right: #0066cc 1px dotted; border-top: #0066cc 1px dotted; border-left: #0066cc 1px dotted; border-bottom: #0066cc 1px dotted" >
                      < tr >
                              < td rowspan="2" style="width: 100px; border-right: #33ccff 1px groove; border-top: #33ccff 1px groove; border-left: #33ccff 1px groove; border-bottom: #33ccff 1px groove;" >
                                      < asp:ListBox ID="iplxb" runat="server" DataSourceID="SqlDataSource1" DataTextField="ip"
                                              DataValueField="ip" Height="194px" Width="153px" > < /asp:ListBox > < /td >
                              < td style="width: 100px; border-right: #33ccff 1px groove; border-top: #33ccff 1px groove; border-left: #33ccff 1px groove; border-bottom: #33ccff 1px groove;" >
                            fill in the standard IP address in the text box at the bottom left, then click the button to add! < br / >
                                      < asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="iptb"
                  Display="Dynamic" ErrorMessage=" incorrect IP address format "ValidationExpression="([0-9]{ 2, 3 & # 125;) ([]) ([0-9] & # 123; 1, 3 & # 125;) ([]) ([0-9] & # 123; 1, 3 & # 125;) ([]) ([0-9] & # 123; 1, 3 & # 125;) "> < /asp:RegularExpressionValidator > < /td >
                      < /tr >
                      < tr >
                              < td style="width: 100px; border-right: #33ccff 1px groove; border-top: #33ccff 1px groove; border-left: #33ccff 1px groove; border-bottom: #33ccff 1px groove;" >
                                      < asp:LinkButton ID="LinkButton1" runat="server" OnClick="LinkButton1_Click" > Delete the selected line < /asp:LinkButton > < /td >
                      < /tr >
                      < tr >
                              < td style="width: 100px; border-right: #33ccff 1px groove; border-top: #33ccff 1px groove; border-left: #33ccff 1px groove; border-bottom: #33ccff 1px groove;" >
                                      < asp:TextBox ID="iptb" runat="server" Width="150px" > 61.139.33.22 < /asp:TextBox > < /td >
                              < td style="width: 100px; border-right: #33ccff 1px groove; border-top: #33ccff 1px groove; border-left: #33ccff 1px groove; border-bottom: #33ccff 1px groove;" >
                                      < asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text=" increase "Width="80px" /> < /td >
                      < /tr >
          < /table >      
      < /div >
      < /form >
< /body >
< /html >

Limit IP to add page CS code

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class admin_ip : System.Web.UI.Page
{
      protected void Page_Load(object sender, EventArgs e)
      {
              Server.Execute("chklog.aspx");
      }
      protected void Button1_Click(object sender, EventArgs e)
      {              
              iplxb.Items.Add(iptb.Text);
              odb.insert("insert into ip (ip) values ('" + iptb.Text + "')");
      }
      protected void LinkButton1_Click(object sender, EventArgs e)
      {
              for (int i = 0; i < iplxb.Items.Count; i++)
              {
                      if (iplxb.Items[i].Selected)
                      {
                              odb.insert("delete from ip where ip='"+iplxb.SelectedItem.Text+"'");
                              iplxb.Items.Remove(iplxb.SelectedItem.Text);
                      }
              }
      }
}

The code

for the page that needs to be restricted to IP calls the page

  protected void Page_Load(object sender, EventArgs e)
      {
              string ip = Request.UserHostAddress.ToString();
                      if (Convert.ToInt32(odb.scr("select count(*) from [ip] where ip='" + ip + "'")) > 0)
              Response Write(" sorry, your IP has restricted access, please consult your administrator ");
      }
}