//获取车站列表至控件 public static void FullToPrefixCodeLst(DropDownCheckList ddlList) { ddlList.Items.Clear(); string sSQL = "Select * from SysPrefixCode_Info Where Status=0 And IsNull(SystemID,0)=" + SysParams.GetPurviewSystemID().ToString() + " Order By SortID"; SqlDataReader sdr = DataCommon.GetDataByReader(sSQL); while (sdr.Read()) { ListItem liItem = new ListItem(); liItem.Value = sdr["ID"].ToString(); liItem.Text = sdr["PrefixCodeName"].ToString(); ddlList.Items.Add(liItem); } sdr.Close(); }
protected void BindDropDownList(DropDownCheckList dlist, string DataTypeValue) { tempDt = bllTypeData.GetdllDateTypeList(DataTypeValue); dlist.DataSource = tempDt.DefaultView; dlist.DataTextField = "DataValue"; dlist.DataValueField = "DataCode"; dlist.DataBind(); tempDt.Clear(); }