protected void getClassTwo() { string sql = "SELECT DISTINCT TY_NAME FROM TBMA_TYPEINFO WHERE TY_FATHERNAME='" + DDLclass.SelectedItem.Text.ToString() + "' ORDER BY TY_NAME"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sql); DDLname.DataSource = dt; DDLname.DataTextField = "TY_NAME"; DDLname.DataValueField = "TY_NAME"; DDLname.DataBind(); }
protected void getClassTwo() { string sql = "SELECT DISTINCT TY_NAME,TY_ID FROM TBMA_TYPEINFO WHERE TY_FATHERID='" + DDLclass.SelectedValue + "' ORDER BY TY_NAME"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sql); DDLname.DataSource = dt; DDLname.DataTextField = "TY_NAME"; DDLname.DataValueField = "TY_ID"; DDLname.DataBind(); DDLname.Items.Insert(0, new ListItem("全部", "")); DDLname.SelectedIndex = 0; }