List<string> retList = new List<string>(); FilterName.Clear(); string connectionString = "Provider=Microsoft.JET.OLEDB.4.0;data source=" + strPath; OleDbConnection conn = new OleDbConnection(connectionString); string sql = "SELECT DISTINCT "+stringColName+" From " + strTable; OleDbCommand cmd = new OleDbCommand(sql, conn); conn.Open(); OleDbDataReader reader; reader = cmd.ExecuteReader(); TreeNode tn = null;
List<string> reeList = new List<string>(); FilterName.Clear(); string connectionString = "Provider=Microsoft.JET.OLEDB.4.0;data source=" + strPath; OleDbConnection conn = new OleDbConnection(connectionString); string sql = "SELECT DISTINCT "+stringColName+" From " + strTable; OleDbCommand cmd = new OleDbCommand(sql, conn); conn.Open(); OleDbDataReader reader; reader = cmd.ExecuteReader(); TreeNode tn = null; tn=new TreeNode(ParentNode); while(reader.Read()) { tn.Nodes>Add(reader.GetString(0),reader.GetString(0)) FilterName.Add(reader.GetString(0)); }</string></string>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)