62,025
社区成员
发帖
与我相关
我的任务
分享
public void BindTree(TreeView tview, TreeNode tn_main, string First_ID, string sql)
{
string ConnectionStr = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=" + Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["ConnectionStr"].ToString());//从Web.config文件中获取数据库连接字符串
OleDbConnection AccessConnection = new OleDbConnection(ConnectionStr);
AccessConnection.Open();//打开数据库
string sql1 = "select Role from Fun_First ";
OleDbCommand AccessCommand = new OleDbCommand(sql1,AccessConnection);
OleDbDataReader AccessReader = AccessCommand.ExecuteReader();
OleDbDataAdapter adapter = new OleDbDataAdapter(sql1,AccessConnection);
DataSet DS = new DataSet();
adapter.Fill(DS,"Fun_First");
TreeNode tn = null;
tview.Font.Size = FontUnit.Small;
tview.ForeColor = System.Drawing.Color.Black;
DataTable dTable = DS.Tables[0];
DataRow[] drows = dTable.Select(" First_ID='" + First_ID + "'");
foreach (DataRow drow in drows)
{
tn = new TreeNode();
tn.Text = drow["modulName"].ToString();
tn.Value = drow["modulId"].ToString();
tn.SelectAction = TreeNodeSelectAction.Expand;
tn.NavigateUrl = "MAIN.aspx";
tn.Expanded = true;
if (tn_main == null)
{
tview.Nodes.Add(tn);
}
else
{
tn_main.ChildNodes.Add(tn);
}
DataSet DST = new DataSet();
adapter.Fill(DST, "TB_User");
DataTable DTB = DST.Tables[0];
DataRow[] dar = DTB.Select(" First_ID='" + tn.Value + "'");
First_ID = tn.Value;
BindTree(tview, tn, First_ID, sql);
}
}
没有数据的说 哪里没显示出来,DataTable里面没数据,还是没有这个ID?调试下看看
哪里没显示出来,DataTable里面没数据,还是没有这个ID?调试下看看