C#

DbCommand.CommandText = 
"SELECT MISCITEM-DATE, MISCITEM-SERIAL-NBR,  INV-MK-SERIAL-NBR, MISCITEM-MODEL-NBR, MISCITEM-CUST-ACCT-NBR, MISCITEM-EXCHANGE-MODEL-NBR, " +
" INV-SELL-PRICE,INV-ORIGINAL-COST, MISCITEM-ACTUAL-COST, MISCITEM-SALESMAN-1, MISCITEM-TICKET-NBR, MISCITEM-STORE FROM MISCITEM " +
" INNER JOIN NINVREC ON MISCITEM-SERIAL-NBR=INV-MK-SERIAL-NBR " +
" WHERE (MISCITEM-DATE >= @Date1 AND MISCITEM-DATE <= @Date2) AND (INV-STATUS = 'S')" +
" GROUP BY MISCITEM-STORE, MISCITEM-DATE ORDER BY MISCITEM-STORE, MISCITEM-DATE";				

DbCommand.Paramaters.Add("@Date1", OdbcType.DateTime)
DbCommand.Paramaters["@Date1"].Value = strEOMDate;
DbCommand.Paramaters.Add("@Date2", OdbcType.DateTime)
DbCommand.Paramaters["@Date2"].Value = dtProcDate1;

try			
{
 DbConnection.Open();

 DbReader = DbCommand.ExecuteReader(); 

while(DbReader.Read())

Table Indexes
Name Number of Fields
Key 1 2
Fields:
INV-MK-MODEL-NBR Ascending
INV-MK-SERIAL-NBR Ascending
Key 2 1
Fields:
INV-SERIAL-NBR-KEY Ascending
Key 3 1
Fields:
INV-PRIMARY-SERIAL-NBR Ascending
Key 4 1
Fields:
INV-DATE-SOLD Ascending
Key 5 1
Fields:
INV-LOCATION-REC-1 Ascending
Key 6 1
Fields:
INV-TICKET-NBR Ascending

Table Indexes
Name Number of Fields
Key 1 6
Fields:
MISCITEM-DATE Ascending
MISCITEM-HOUR Ascending
MISCITEM-MINUTE Ascending
MISCITEM-SECOND Ascending
MISCITEM-DUPLICATE-TIME Ascending
MISCITEM-STORE-KEY Ascending
Key 2 1
Fields:
MISCITEM-SALE-DATE Ascending
Key 3 3
Fields:
MISCITEM-CUST-ACCT-NBR Ascending
MISCITEM-TICKET-NBR Ascending
MISCITEM-TICKET-SEQ-NBR Ascending
Key 4 2
Fields:
MISCITEM-MODEL-NBR Ascending
MISCITEM-SERIAL-NBR Ascending
Key 5 2
Fields:
MISCITEM-EXCHANGE-MODEL-NBR Ascending
MISCITEM-EXCHANGE-SERIAL-NBR Ascending
Key 6 1
Fields:
MISCITEM-PENDING-SALE-DATE Ascending

jojoba2010 wrote:

WHY?

jojoba2010 wrote:

If you think something like this ,I am sorry for you ?

public void PopulateTree(string dir, TreeNode node)
        {

            // get the information of the directory

            DirectoryInfo directory = new DirectoryInfo(dir);

            // loop through each subdirectory

            foreach (DirectoryInfo d in directory.GetDirectories())
            {

                if (d.Name != "bin" && d.Name != "obj" && d.Name != "Properties")
                {
                    // create a new node

                    TreeNode t = new TreeNode(d.Name);

                    // populate the new node recursively

                    PopulateTree(d.FullName, t);

                    node.Nodes.Add(t); // add the node to the "master" node
                }

            }

            // lastly, loop through each file in the directory, and add these as nodes

            foreach (FileInfo f in directory.GetFiles())
            {
                string[] Count = f.Name.Split('.');

                // create a new node
                if (Count.Length == 2 && f.Extension == ".cs" && f.Name != "Program.cs")
                {
                    TreeNode t = new TreeNode(f.Name);

                    // add it to the "master"

                    node.Nodes.Add(t);
                }
            }

        }
private void btnGenerate_Click(object sender, EventArgs e)
        {
            treeView1.Nodes.Add("Resource Generator");
            //            PopulateTree(@"G:\Resource Final Editor For JahanBane\ResourceGenerator(FINISHED FINAL)\ResourceGenerator", treeView1.Nodes[0]);
            PopulateTree(@"F:\AliWinTAP\WinTAP", treeView1.Nodes[0]);
        }