62,074
社区成员
发帖
与我相关
我的任务
分享
public void ddlDepartName_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dt = new DataTable();
SqlDataAdapter adpt = new SqlDataAdapter("SELECT e.EmpId,e.[EmpName],D.[DepartId],D.[DepartName],w.[BaseID],w.[PaymentBase], w.[PensionBase], w.[FertilityBase], w.[MedicalBase] FROM [Crm_Employee] e LEFT outer JOIN [Crm_WagePaymentBase] w on e.EmpId=w.EmpID LEFT outer JOIN Crm_Depart D ON D.DepartId=e.DepartId WHERE D.Departid=N'" + ((DropDownList)gvWageBase.HeaderRow.Cells[0].FindControl("ddlDepart")).SelectedValue + "'", connectionString);
dt.Clear();
adpt.Fill(dt);
gvWageBase.DataSource = dt;
gvWageBase.DataBind();
}
你考虑用下红色部分的事件
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//绑定ddlclass
SqlConnection con = new SqlConnection(strCon);
con.Open();
SqlCommand cmd = new SqlCommand("select * from class ", con);
SqlDataReader reader = cmd.ExecuteReader();
ddlclass.DataSource = reader;
ddlclass.DataTextField = "classname";
ddlclass.DataValueField = "classno";
ddlclass.DataBind();
reader.Close();
//绑定ddldevice
SqlCommand cmd2 = new SqlCommand("select * from deviceinfo where classno=" + this.ddlclass.SelectedValue, con);
reader = cmd2.ExecuteReader();//上面定义过reader,这里就不用从新定义
ddldevice.DataSource = reader;
ddldevice.DataTextField = "deviceno";
ddldevice.DataValueField = "classno";
ddldevice.DataBind();
reader.Close();
string b = this.ddldevice.SelectedItem.ToString();
}
}
protected void ddlclass_SelectedIndexChanged(object sender, EventArgs e)
{
//ddlclass与ddldevice数据绑定的联动性
string code = this.ddlclass.SelectedValue;
string a = this.ddldevice.SelectedItem.ToString ();
SqlConnection con = new SqlConnection(strCon);
con.Open();
SqlCommand cmd = new SqlCommand("select * from deviceinfo where classno=" + code, con);
SqlDataReader reader = cmd.ExecuteReader();
this.ddldevice.DataSource = reader;
this.ddldevice.DataTextField = "deviceno";
this.ddldevice.DataValueField = "classno";
this.ddldevice.DataBind();
reader.Close();
con.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
zh.BLL.BLLSell sell = new zh.BLL.BLLSell();
DataSet ds = new DataSet();
ds = sell.GetList(" recid<100");
ddlclass.DataSource = ds;
ddlclass.DataTextField = "Sellid";
ddlclass.DataValueField = "recid";
ddlclass.DataBind();
}
}
//下班给你测试了下,没问题,LZ还是仔细检查下吧
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
zh.BLL.BLLSell sell = new zh.BLL.BLLSell();
DataSet ds = new DataSet();
ds = sell.GetList(" recid<100");
ddlclass.DataSource = ds;
ddlclass.DataTextField = "Sellid";
ddlclass.DataValueField = "recid";
ddlclass.DataBind();
zh.BLL.BLLSellDetail sellse = new zh.BLL.BLLSellDetail();
DataSet dss = new DataSet();
dss = sellse.GetList(" sellid='" + ddlclass.SelectedItem.Text + "'");
this.ddldevice.DataSource = dss;
this.ddldevice.DataTextField = "goodsname";
this.ddldevice.DataValueField = "recid";
this.ddldevice.DataBind();
}
}
protected void ddlclass_SelectedIndexChanged(object sender, EventArgs e)
{
zh.BLL.BLLSellDetail sellse = new zh.BLL.BLLSellDetail();
DataSet dss = new DataSet();
dss = sellse.GetList(" sellid='" + ddlclass.SelectedItem.Text + "'");
this.ddldevice.DataSource = dss;
this.ddldevice.DataTextField = "goodsname";
this.ddldevice.DataValueField = "recid";
this.ddldevice.DataBind();
}
protected void btnRegion_Click(object sender, EventArgs e)
{
string aaaa = ddldevice.SelectedItem.Text.ToString();//这里取到的值是所选泽的
}
//若是需要这些类别的ID就是这样
objCommand.Parameters["classno"].Value = ddlclass.SelectedValue;
objCommand.Parameters["deviceno"].Value = ddldevice.SelectedValue;
//若是需要这些类别的名称就是这样
objCommand.Parameters["classno"].Value = ddlclass.SelectedText;
objCommand.Parameters["deviceno"].Value = ddldevice.SelectedText;