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;
using System.Data.SqlClient;
using System.Text;
namespace Warehouse
{
public partial class DropDownHelper : System.Web.UI.Page, IHttpHandler//, IRequiresSessionState
{
protected void Page_Load(object sender, EventArgs e)
{
string sql = "select WW_Name,WW_Id from W_Warehouse,W_Company where WW_Company=WC_Id and WC_Id='" +a+ "'";
SqlDataAdapter myda = new SqlDataAdapter(sql, mycon);
DataSet myset = new DataSet(); myda.Fill(myset);
DataTable mytable = myset.Tables[0];
int n = mytable.Rows.Count;
String str = "";
int i = 0;
for (i = 0; i <n; i++)
{
string Warehouse = mytable.Rows[i]["WW_Name"].ToString();
string WarehouseId = mytable.Rows[i]["WW_Id"].ToString();
if (i >= 1)
{
str += "|";
}
str += "\"" + Warehouse + ":" + WarehouseId + "\"";
}
Response.Write(str);
}
}
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;
using System.Data.SqlClient;
using System.Text;
namespace Warehouse
{
public partial class DropDownHelper : System.Web.UI.Page, IHttpHandler//, IRequiresSessionState
{
protected void Page_Load(object sender, EventArgs e)
{
string a = Request["type"];
Response.Write(a);
string sql = "select WW_Name,WW_Id from W_Warehouse,W_Company where WW_Company=WC_Id and WC_Id='" +a+ "'";
SqlDataAdapter myda = new SqlDataAdapter(sql, mycon);
DataSet myset = new DataSet(); myda.Fill(myset);
DataTable mytable = myset.Tables[0];
int n = mytable.Rows.Count;
String str = "";
int i = 0;
for (i = 0; i <n; i++)
{
string Warehouse = mytable.Rows[i]["WW_Name"].ToString();
string WarehouseId = mytable.Rows[i]["WW_Id"].ToString();
if (i >= 1)
{
str += "|";
}
str += "\"" + Warehouse + ":" + WarehouseId + "\"";
}
Response.Write(str);
}
}
}
aspx后台代码,前台默认即可