110,538
社区成员
发帖
与我相关
我的任务
分享
private void frmTreeView_Load(object sender, EventArgs e)
{
string sqlConn = "data source=.;database=bfbc;uid=sa;pwd=sa";
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(sqlConn);
conn.Open();
string selectSql = "select FileName,VehicleConfigureDocument from DemarcateRelatingDocument";
DataTable dt=new DataTable("DemarcateRelatingDocument");
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(selectSql, sqlConn);
int fillNum = 0;
fillNum=da.Fill(dt);
for (int i = 0; i < fillNum; i++)
{
this.treeView1.Nodes.Add(dt.Rows[i][0].ToString());
}
conn.Close();
}
private void frmTreeView_Load(object sender, EventArgs e)
{
string sqlConn = "data source=.;database=bfbc;uid=sa;pwd=sa";
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(sqlConn);
conn.Open();
string selectSql = "select FileName,VehicleConfigureDocument from DemarcateRelatingDocument";
DataTable dt=new DataTable();
System.Data.SqlClient.SqlDataAdapter da=new System.Data.SqlClient.SqlDataAdapter(selectSql,conn);
int rtnNum=0;
rtnNum=da.Fill(dt);
for (int i = 0; i < rtnNum; i++)
{
TreeNode fileNameNode = new TreeNode(dt.Rows[i][0].ToString());
if (!this.treeView1.Nodes.Contains(fileNameNode))
{
this.treeView1.Nodes.Add(fileNameNode);
}
TreeNode documentNode = new TreeNode(dt.Rows[i]["VehicleConfigureDocument"].ToString());
if (!fileNameNode.Nodes.Contains(documentNode))
{
fileNameNode.Nodes.Add(documentNode);
}
}
conn.Close();
}