{1} : 根据数据库中的结构生成树 ------------------------------------------------------------------------------------- public int GetDataToTree(ref TreeView tv,string CompanyID) { SqlConnection conn = new SqlConnection(SQLHelper.Conn_1);
DataSet ds = SQLHelper.ExecustSQL_DataSet(conn,"select CmpNum,CmpName,Left(CmpNum,Len(CmpNum)-2) as PrtID from Company where CmpNum like '"+CompanyID+"%' order by CmpNum"); dt = ds.Tables["table"]; dv = dt.DefaultView ; dv.Sort = "PrtID"; DataRowView[] arrDRV = dv.FindRows("00"); if (arrDRV.Length==0) return 0;