我们看下其实这里的这么多表字段 个人觉得 pid子节点(如果是0那么就是根节点,1子节点,3子节点的子节点) name要显示的名称 url连接地址 title标题 icon关闭图片的路径 iconopen打开图片的路径 这里不详细介绍了 大家可以试下 我们最主要的就是根据username 进行判断 大家也可以是把username换成是引用的字段 我这里只是一个测试的所以就用了个字符串类型 下面我们来动态加载treeview
private DataSet GetDt(string username)
{
string strConn="server=ZHOUYUN;database=Mytest;uid=sa;pwd=123456";
SqlConnection conn = new SqlConnection(strConn);
string strSql = string.Format("
select * from treeview where username='{0}'",username);
SqlDataAdapter da = new SqlDataAdapter(strSql, conn);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
}
Then we put the js that we generated into the book first into the .cs file. One of the key things is to pay attention to the pouring of the .js file and the pouring of the .css file. We can use Page.hearder.innerHTMl="" The file name you want to import
public void treeview()
{
//Strengthen a long string type
StringBuilder strbu = new StringBuilder();
//We are generating a class that retains the position of static text
Literal lit = new Literal();
//This is where we just mentioned to put the .js and .cs files
//page.Header.InnerHtml means to put this file reference in the html tag Inside
// Between this
Page.Header.InnerHtml = @"<
link rel='StyleSheet' href='dtree.css' type= 'text/css'/>
";//End of pouring
string username = "zhangsan";
DataSet ds = GetDt(username.Trim());
DataTable dt = ds.Tables[0];
//We now start to put the js file into the long string type
strbu.Append(@"
"); //End of long file type addition
//Now we keep the static text The text value is equal to the value of the long file type we just mentioned
lit.Text = Convert.ToString(strbu);
//Then we are thinking about how to put a paragraph of text into
//
form1.InnerHtml = "";
//We can get form1 directly from the .cs file and then .Controls.Add()
//He can only put static text, so we assigned the value of the long file type to the static text
//Then we can add it directly here
form1.Controls.Add(lit );
}