asp中的省市二级联动.doc

asp中的省市二级联动(2008-11-27 22:26:05)
标签：it 
分类：asp
sql server下的自建表 province（省份），city（城市），如下：
                   省份表province
 province_id
province_name 
ProvinceNo 
 ProvinceOrder
 1
 北京市
 1
 1
 2
 上海市
 2
 2
 3
 黑龙江省
 3
 3
 4
 吉林省
 4
 4

                   城市表city

city_id 
 city_name
 CityNo
CityOrder 
province_id 
 1
 东城区
 1
 1
 1
 2
 哈尔滨
 2
 2
 3
 3
 佳木斯
 3
 3
 3
 4
 黄浦区
 4
 4
 2
 5
 长春市
 5
 5
 4

联动代码如下：

1>户籍所在
搜索户籍所在地满足条件的用户

请选择省份……
<%
dim tmpid '定义一个临时变量用来记住省id
tmpid=0
set rs_Province4、server.CreateObject("ADODB.recordset")
sql="select * from province order by ProvinceOrder"
rs_Province.open sql,conn,1,1
while not rs_Province.eof
tmpid=rs_Province("province_id")
%>
" ><%=trim(rs_Province("province_name"))%>
<%
rs_Prov5、ince.movenext
wend
rs_Province.close
set rs_Province=nothing
%>

请选择城市……
<%
set rs_City=server.createobject("adodb.recordset")
sql="select 6、 from city where province_id="&tmpid&" order by CityOrder"
rs_City.open sql,conn,1,1
while not rs_City.eof
%>
"><%=trim(rs_City("city_name"))%>
<%
rs_City.movenext
wend
rs_City.close
set rs_City=nothing
%>

server.CreateObject("ADODB.recordset")
sql="select * from province order by ProvinceOrder"
rs_Province.open sql,conn,1,1
while not rs_Province.eof
tmpid=rs_Province("province_id")
%>
ince.movenext
wend
rs_Province.close
set rs_Province=nothing
%>
from city where province_id="&tmpid&" order by CityOrder"
rs_City.open sql,conn,1,1
while not rs_City.eof
%>

2009-09-09 22:09:40 asp二级联动同个表
分类:(asp编程) | 评论:(0) | 浏览:(137) | 标签: 二级联动 同个表
数据库结构
程序代码

  id   anclassid     anclass             nclass  
  0           0               一年级             一年五班                          
  1           1               二年级             二年二班                          
  2           0               一年级             一年二班                          
  3           1               二年级             二年一班                          
  4           1               二年级             二年三班                          
  5           2               三年级             三年一班                          
  6           2               三年级             三年二班                          
  7           2               三年级             三年三班

<%       
  dim   conn,constr     
  constr="driver={microsoft   access   driver   (*.mdb)};uid=admin;pwd=数据库密码;dbq="&   server.mappath("class.mdb")     
  set   conn=server.createobject("adodb.connection")       
  conn.open   constr     

  set   rs=server.createobject("adodb.recordset")     
  rs.open   "select   *   from   school   order   by   anclassid",conn,1,1%>     
  aScript">     
  var   onecount;     
  onecount=0;     
  subcat   =   new   Array();     
  <%     
        count   =   0     
        do   while   not   rs.eof       
  %>     
  subcat[<%=count%>]   =   new   Array("<%=   trim(rs("anclassid"))%>","<%=   rs("anclass")%>","<%=   rs("nclass")%>");     
  <%     
                  countcount   =   count   +   1     
                  rs.movenext     
                  loop     
                  rs.close     
  %>     

  onecount=<%=count%>;     

  function   changelocation(locationid)     
          {     
          document.form.Nclassid.length   =   0;       

          var   locationidlocationid=locationid;     
          var   i;     
          for   (i=0;i   <   onecount;   i++)     
                  {     
                          if   (subcat[i][0]   ==   locationid)     
                          {       
                            document.form.Nclassid.options[document.form.Nclassid.length]   =   new   Option(subcat[i][2],   subcat[i][2]);   //这里图像的内容已[ 2 ]  
                          }                     
                  }     

          }             

  <%     
  set   rs=server.createobject("adodb.recordset")     
  rs.open   "select   distinct   anclassid,anclass   from   school   order   by   anclassid",conn,1,1     
  if   rs.eof   and   rs.bof   then     
  response.write   "请先添加栏目。"     
  response.end     
  else     
  %>     

  "><%=trim(rs("anclass"))%>     
  <%   dim   selclass     
                    selclass=rs("anclassid")     
                  rs.movenext     
                  do   while   not   rs.eof     
  %>       
  "><%=trim(rs("anclass"))%>     
  <%     
                  rs.movenext     
                  loop     
  end   if     
                  rs.close     
  %>       

    <%rs.open   "select   *   from   school   where   anclassid="&selclass   ,conn,1,1     
  if   not(rs.eof   and   rs.bof)   then     
  %>       
    lue="<%=rs("nclass")%>"><%=rs("nclass")%>     
    <%   rs.movenext     
  do   while   not   rs.eof%>       
  "><%=rs("nclass")%>     
  <%   rs.movenext     
  loop     
  end   if     
                  rs.close     
                  set   rs   =   nothing     
  %>       

Asp.Net DataGrid控件分页代码
2008-08-21 18:23
先看实现的效果：

代码：
<% @ Page Language="C#" %>
<% @ Import Namespace="System.Data" %>
<% @ Import Namespace="System.Data.OleDb" %>
<p style='padding:5px 0px;'>21、"C#" runat="Server">
private int recordCount;
public void Page_Load(Object src,EventArgs e)
{

string strComm = "select * from news";
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=";
     strConnection += Server.MapPath("app_data/data.mdb");

OleDbConnection </p><p style='padding:5px 0px;'>22、MyConnection = new OleDbConnection(strConnection);
OleDbDataAdapter MyComm = new OleDbDataAdapter(strComm, MyConnection);

DataSet MyDataSet = new DataSet();
MyComm.Fill(MyDataSet,"UserList");
recordCount = MyDataSet.Tables[0].Rows.Count;

DataGrid1.DataSource = MyDataSet.Tables["UserList"].D</p><p style='padding:5px 0px;'>23、efaultView;

if(!Page.IsPostBack)
{
   DataGrid1.DataBind();
   pagecount.Text = DataGrid1.PageCount.ToString();
   nowpage.Text = "1";
   pagesize.Text = DataGrid1.PageSize.ToString();
   _recordCount.Text = recordCount.ToString();
}
}
private void change_page(object sender, System.Event</p><p style='padding:5px 0px;'>24、Args e)
{
    LinkButton btn = (LinkButton)sender;
    int PageIndex = Int32.Parse(nowpage.Text) - 1;
    int _pagecount = Int32.Parse(pagecount.Text);
    switch(btn.CommandName)
    {
        case "First":
            PageIndex = 0;
            break;
        case "Prev":
            Pa</p><p style='height:0px;padding:0;overflow:hidden'>25、geIndex = PageIndex - 1;
            break;
        case "Next":
            PageIndex = PageIndex + 1;
            break;
        case "Last":
            PageIndex = _pagecount-1;
            break;
    }
    if(PageIndex < 0)
        PageIndex = 0;
    else if (PageIndex > _pagecount-1</p><p style='height:0px;padding:0;overflow:hidden'>26、)
        PageIndex = _pagecount-1;

    DataGrid1.CurrentPageIndex = PageIndex;
    DataGrid1.DataBind();
pagecount.Text = DataGrid1.PageCount.ToString();
nowpage.Text = (DataGrid1.CurrentPageIndex + 1).ToString();
pagesize.Text = DataGrid1.PageSize.ToString();
_recordCount.Text = r</p><p style='height:0px;padding:0;overflow:hidden'>27、ecordCount.ToString();
}

public void DataGrid1_PageIndexChanged(object sender,DataGridPageChangedEventArgs e)  
{  
//startIndex = e.NewPageIndex*DataGrid1.PageSize;  
DataGrid1.CurrentPageIndex=e.NewPageIndex;  
DataGrid1.DataBind();
}

    Asp.Net分页学习</p><p style='height:0px;padding:0;overflow:hidden'>28、

e>

            ataField="new_time" />

    首页
    上一页
    inkButton ID="LBtnNext" runat="server" CommandName="Next" OnClick="change_page">下一页
    尾页

    第页
    共ID="pagecount" runat="server">页
    每页条
    共条
p="true" CodeFile="PageGridView.aspx.cs" Inherits="PageGridView" %>

DataGridPaging

tent="javascript" name="vs_defaultClientScript">

tyle="FONT-SIZE: 9pt" cellSpacing="1" cellPadding="1" width="450" align="center"
border="1">
>
下一页
尾页 ASP:literal>页 每页
条 共
条
ng System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;

public partial class PageGridView : System.Web.UI.Page
{
    private int recordCount;
    private int pageCount;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            DataGridDataBind();
        }
    }
    //绑定数据
    private void DataGridDataBind()
    {
        DataSet ds = GetCustomersData();
        recordCount = ds.Tables[0].Rows.Count;
        //获取当前的页数
        pageCount = (int)Math.Ceiling(recordCount * 1.0 / PageSize);
        //避免纪录从有到无时，并且已经进行过反页的情况下CurrentPageIndex > PageCount出错
        if (recordCount == 0)
        {
            this.DataGrid1.CurrentPageIndex = 0;
        }
        else if (this.DataGrid1CurrentPageIndex >= pageCount)
        {
            this.DataGrid1.CurrentPageIndex = pageCount - 1;
        }
        this.DataGrid1.DataSource = ds;
        this.DataGrid1.DataBind();
        NavigationStateChange();
    }
    #region Web 窗体设计器生成的代码
    override protected void OnInit(EventArgs e)
    {
        //
        // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
        //
        InitializeComponent();
        base.OnInit(e);
    }
    ///     this.LBtnFirst.Click += new System.EventHandler(this.LBtnNavigation_Click);
        this.LBtnPrev.Click += new System.EventHandler(this.LBtnNavigation_Click);
        this.LBtnNext.Click += new System.EventHandler(this.LBtnNavigation_Click);
        this.LBtnLast.Click += new System.EventHandler(this.LBtnNavigation_Click);
        this.Load += new System.EventHandler(this.Page_Load);
    }
    #endregion
    private void LBtnNavigation_Click(object sender, System.EventArgs e)
    {
        LinkButton btn = (LinkButton)sender;
        switch (btn.CommandName)
        {
            case "First":
                PageIndex = 0;
                break;
            case "Prev"://if( PageIndex > 0 )
                PageIndex = PageIndex - 1;
                break;
            case "Next"://if( PageIndex < PageCount -1)
                PageIndex = PageIndex + 1;
                break;
            case "Last":
                PageIndex = PageCount - 1;
                break;
        }
        DataGridDataBind();
    }
    //数据绑定
    public static DataSet GetCustomersData()
    {
        SqlConnection conn = new SqlConnection("server=.;database=NorthWind;uid=sa;pwd=sa;");
        string sqlStr = "SELECT CustomerID, CompanyName,Address,Phone FROM Customers";
        SqlCommand comm = new SqlCommand(sqlStr, conn);
        SqlDataAdapter dataAdapter = new SqlDataAdapter(comm);
        DataSet ds = new DataSet();
        dataAdapter.Fill(ds);
        return ds;
    }
    ///