AJax带数据库的三级联动
标签:
•
文件类型: .rar
•
文件大小: 1.08MB
•
下载次数: 1
•
带数据库的,省市县的三级联动,是自己做的,好多公司面试题都是这个。
代码片段和文件信息
属性 大小 日期 时间 名称
----------- --------- ---------- ----- ----
文件 774 2009-03-04 10:27 shengshixianApp_CodeClass1.cs
文件 74401 2009-03-04 10:30 shengshixianApp_CodeSqlHelper.cs
文件 143360 2007-11-20 16:46 shengshixianinAjaxPro.2.dll
文件 48 2009-03-04 10:24 shengshixianinAjaxPro.2.dll.refresh
文件 5289 2009-03-04 12:18 shengshixianDefault.aspx
文件 6020 2009-03-04 12:12 shengshixianDefault.aspx.cs
文件 2244 2009-03-04 11:17 shengshixianWeb.config
目录 0 2009-03-04 10:30 shengshixianApp_Code
目录 0 2009-03-04 10:24 shengshixianApp_Data
目录 0 2009-03-04 10:24 shengshixianin
目录 0 2009-03-04 21:31 shengshixian
文件 774 2009-03-04 10:27 shengshixianshengshixianApp_CodeClass1.cs
文件 74401 2009-03-04 10:30 shengshixianshengshixianApp_CodeSqlHelper.cs
文件 143360 2007-11-20 16:46 shengshixianshengshixianinAjaxPro.2.dll
文件 36 2009-03-04 19:51 shengshixianshengshixianinAjaxPro.2.dll.refresh
文件 5294 2009-03-04 18:56 shengshixianshengshixianDefault.aspx
文件 6020 2009-03-04 12:12 shengshixianshengshixianDefault.aspx.cs
文件 2234 2009-03-04 19:46 shengshixianshengshixianWeb.config
目录 0 2009-03-04 10:30 shengshixianshengshixianApp_Code
目录 0 2009-03-04 10:24 shengshixianshengshixianApp_Data
目录 0 2009-03-04 10:24 shengshixianshengshixianin
目录 0 2009-03-04 21:31 shengshixianshengshixian
文件 3145728 2009-03-04 21:24 shengshixianshengshixiandatasheng.mdf
文件 1048576 2009-03-04 21:24 shengshixianshengshixiandatasheng_log.ldf
目录 0 2009-03-04 21:31 shengshixianshengshixiandata
----------- --------- ---------- ----- ----
4658559 25
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
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;
using ProjectManage.DataAccesslayer;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender EventArgs e)
{
AjaxPro.Utility.RegisterTypeForAjax(typeof(_Default));
if (!IsPostBack)
{
setProvince();
ListItem listCity = new ListItem(“请选择“ “-1“);
ddlCity.Items.Insert(0 listCity);
ListItem listArea = new ListItem(“请选择“ “-1“);
ddlArea.Items.Insert(0 listArea);
}
}
private void setProvince()
{
ddlProvince.DataSource = getdate();
ddlProvince.DataTextField = “name“;
ddlProvince.DataValueField = “pid“;
ddlProvince.DataBind();
ListItem listProvince = new ListItem(“请选择“ “-1“);
ddlProvince.Items.Insert(0 listProvince);
}
public DataTable getdate()
{
string strSql = “select * from cepro“;
return SqlHelper.ExecuteDataset(Class1.ConnectionString CommandType.Text strSql).Tables[0];
}
///
/// 市
///
///
///
[AjaxPro.AjaxMethod(AjaxPro.HttpSessionStateRequirement.ReadWrite)]
public string getParent(string parentID)
{
DataTable dtCity = getdate1(parentID);
string strCity = ““;
for (int i = 0; i < dtCity.Rows.Count; i++)
{
strCity += dtCity.Rows[i][“name“].ToString().Trim() + ““ + dtCity.Rows[i][“cid“].ToString().Trim() + “-“;
if (i == dtCity.Rows.Count - 1) strCity = strCity.Substring(0 strCity.Length - 1);
}
return strCity;
}
///
/// 县
///
///
///
[AjaxPro.AjaxMethod(AjaxPro.HttpSessionStateRequirement.ReadWrite)]
public string getParentarea(string parentID)
{
DataTable dtCity = getdate2(parentID);
string strCity = ““;
for (int i = 0; i < dtCity.Rows.Count; i++)
{
strCity += dtCity.Rows[i][“name“].ToString().Trim() + ““ + dtCity.Rows[i][“cid“].ToString().Trim() + “-“;
if (i == dtCity.Rows.Count - 1) strCity = strCity.Substring(0 strCity.Length - 1);
}
return strCity;
}
///
/// 取市
///
///
///
public DataTable getdate1(string pid)
{
string strSql = “select * from cecity where pid=@pid“;
SqlParameter[] _param =
{
new SqlParameter(“@pid“SqlDbType.VarChar)
};
_param[0].Value = pid;
属性 大小 日期 时间 名称
----------- --------- ---------- ----- ----
文件 774 2009-03-04 10:27 shengshixianApp_CodeClass1.cs
文件 74401 2009-03-04 10:30 shengshixianApp_CodeSqlHelper.cs
文件 143360 2007-11-20 16:46 shengshixianinAjaxPro.2.dll
文件 48 2009-03-04 10:24 shengshixianinAjaxPro.2.dll.refresh
文件 5289 2009-03-04 12:18 shengshixianDefault.aspx
文件 6020 2009-03-04 12:12 shengshixianDefault.aspx.cs
文件 2244 2009-03-04 11:17 shengshixianWeb.config
目录 0 2009-03-04 10:30 shengshixianApp_Code
目录 0 2009-03-04 10:24 shengshixianApp_Data
目录 0 2009-03-04 10:24 shengshixianin
目录 0 2009-03-04 21:31 shengshixian
文件 774 2009-03-04 10:27 shengshixianshengshixianApp_CodeClass1.cs
文件 74401 2009-03-04 10:30 shengshixianshengshixianApp_CodeSqlHelper.cs
文件 143360 2007-11-20 16:46 shengshixianshengshixianinAjaxPro.2.dll
文件 36 2009-03-04 19:51 shengshixianshengshixianinAjaxPro.2.dll.refresh
文件 5294 2009-03-04 18:56 shengshixianshengshixianDefault.aspx
文件 6020 2009-03-04 12:12 shengshixianshengshixianDefault.aspx.cs
文件 2234 2009-03-04 19:46 shengshixianshengshixianWeb.config
目录 0 2009-03-04 10:30 shengshixianshengshixianApp_Code
目录 0 2009-03-04 10:24 shengshixianshengshixianApp_Data
目录 0 2009-03-04 10:24 shengshixianshengshixianin
目录 0 2009-03-04 21:31 shengshixianshengshixian
文件 3145728 2009-03-04 21:24 shengshixianshengshixiandatasheng.mdf
文件 1048576 2009-03-04 21:24 shengshixianshengshixiandatasheng_log.ldf
目录 0 2009-03-04 21:31 shengshixianshengshixiandata
----------- --------- ---------- ----- ----
4658559 25
版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容, 请发送邮件举报,一经查实,本站将立刻删除。
评论列表(条)