|
Posted on
2005-09-05 13:50
TomSun
阅读( 1042)
评论()
编辑
收藏
举报
使用方法:
![](/Images/OutliningIndicators/None.gif)
SqlConnection cnn;
SqlCommand cmd;
![](/Images/OutliningIndicators/None.gif)
cnn = new SqlConnection(SqlHelper.connstr());
cmd = cnn.CreateCommand();
![](/Images/OutliningIndicators/None.gif)
cnn.Open();
if (!Page.IsPostBack)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif) {
SqlDataReader dr;
cmd.CommandText = "SELECT MenuID,MenuName FROM Menu where ParentID=0 and MenuType='product'";
dr = cmd.ExecuteReader();
ddlPublishers.DataSource = dr;
ddlPublishers.DataTextField = "MenuName";
ddlPublishers.DataValueField = "MenuID";
ddlPublishers.DataBind();
dr.Close();
}
![](/Images/OutliningIndicators/None.gif)
cmd.CommandText = "SELECT MenuID,ParentID,MenuName from Menu where ParentID>0 and MenuType='product'";
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet("Titles");
da.Fill(ds,"titles");
Array Data;
Data = Array.CreateInstance(typeof(object),1,3);//1控制后续菜单的数量.
Data.SetValue("ddlTitles",0,0);
Data.SetValue(ds,0,1);
Data.SetValue("titles",0,2);
ddlTitles.TableName = "titles";
![](/Images/OutliningIndicators/None.gif)
ddlPublishers.SlaveData = Data;
cnn.Close();
}
|