在下面的代码中如何在Treeview前面添加checkbox复选框?是用VS2005做ASP.net开发的
TreeView1.Attributes["OnClick"] = @"javascript: window.setTimeout('__doPostBack(\'TreeView1\',\'\')', 0, 'JavaScript')";
String strodbc = "Data Source=YJ;User Id=yj;Password=yj;Unicode=True;";
OracleConnection oledbc = new OracleConnection(strodbc);
String sql = "select ID,NAME from AUTH_DEPARTMENT ";
//String sql = "select ID,NAME from AUTH_DEPARTMENT where PARENT_ID != null ";
TreeNode tmpTn = new TreeNode();
tmpTn.Checked = true;
TreeView1.Nodes.Add(new TreeNode("系统用户", " "));
TreeNode tn;
try
{
oledbc.Open();
OracleCommand odbccmd = new OracleCommand();
odbccmd.Connection = oledbc;
odbccmd.CommandText = sql;
OracleDataAdapter dataadapter = new OracleDataAdapter();
dataadapter.SelectCommand = odbccmd;
DataSet sourceDS = new DataSet();
dataadapter.Fill(sourceDS);
DataTable sourceTable = sourceDS.Tables[0];
int i = 0;
foreach (DataRow dr in sourceTable.Rows)
{
TreeView1.Checkboxes = true;
TreeView1.Nodes[0].ChildNodes.Add(new TreeNode(dr["NAME"].ToString().Trim(),dr["ID"].ToString().Trim()));
//获取子节点
String sqltwo = string.Format(@"select ID,NAME from AUTH_ACCOUNT where DEPT_id = '{0}'", dr["ID"].ToString().Trim());
OracleCommand odbc2 = new OracleCommand();
odbc2.Connection = oledbc;
odbc2.CommandText = sqltwo;
OracleDataAdapter adaptertwo = new OracleDataAdapter();
adaptertwo.SelectCommand = odbc2;
DataSet sourceDStwo = new DataSet();
adaptertwo.Fill(sourceDStwo);
DataTable sourceTabletwo = sourceDStwo.Tables[0];
foreach (DataRow drtwo in sourceTabletwo.Rows)
{
TreeView1.Nodes[0].ChildNodes[i].ChildNodes.Add(new TreeNode(drtwo["NAME"].ToString().Trim(),dr["ID"].ToString().Trim()));
}
i++;
}
oledbc.Close();
}
catch (OracleException ex)
{
throw ex;
}