C#交叉表数据库

C#交叉表数据库查询实例

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace CrossAnalyse
{
    public partial class Form1 : Form
    {
        public Form1（）
        {
            InitializeComponent（）;
        }

        private void Form1_Load（object sender EventArgs e）
        {
            comboBox1.SelectedIndex = 0;
            comboBox2.SelectedIndex = 0;
            bindInfo（）;
        }

        private void button1_Click（object sender EventArgs e）
        {
            bindInfo（）;
        }

        private void comboBox1_SelectedIndexChanged（object sender EventArgs e）
        {
            if （comb

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2013-01-25 10:28  交叉表\
     目录           0  2013-01-25 10:28  交叉表\CrossAnalyse\
     目录           0  2013-01-25 10:28  交叉表\CrossAnalyse\CrossAnalyse\
     文件         926  2008-12-01 14:02  交叉表\CrossAnalyse\CrossAnalyse.sln
     文件       16896  2009-01-05 16:02  交叉表\CrossAnalyse\CrossAnalyse.suo
     目录           0  2013-01-25 10:28  交叉表\CrossAnalyse\CrossAnalyse\bin\
     目录           0  2013-01-25 10:28  交叉表\CrossAnalyse\CrossAnalyse\bin\Debug\
     文件       11776  2009-01-05 15:58  交叉表\CrossAnalyse\CrossAnalyse\bin\Debug\CrossAnalyse.exe
     文件       22016  2009-01-05 15:58  交叉表\CrossAnalyse\CrossAnalyse\bin\Debug\CrossAnalyse.pdb
     文件       14328  2010-08-18 17:51  交叉表\CrossAnalyse\CrossAnalyse\bin\Debug\CrossAnalyse.vshost.exe
     文件         490  2007-07-21 01:33  交叉表\CrossAnalyse\CrossAnalyse\bin\Debug\CrossAnalyse.vshost.exe.manifest
     文件        3770  2008-12-01 14:03  交叉表\CrossAnalyse\CrossAnalyse\CrossAnalyse.csproj
     文件        2714  2009-01-05 15:58  交叉表\CrossAnalyse\CrossAnalyse\Form1.cs
     文件        6580  2009-01-05 15:58  交叉表\CrossAnalyse\CrossAnalyse\Form1.Designer.cs
     文件        5814  2009-01-05 15:58  交叉表\CrossAnalyse\CrossAnalyse\Form1.resx
     目录           0  2013-01-25 10:28  交叉表\CrossAnalyse\CrossAnalyse\obj\
     目录           0  2013-01-25 10:28  交叉表\CrossAnalyse\CrossAnalyse\obj\Debug\
     文件         735  2009-01-05 15:58  交叉表\CrossAnalyse\CrossAnalyse\obj\Debug\CrossAnalyse.csproj.FileListAbsolute.txt
     文件         847  2009-01-05 15:58  交叉表\CrossAnalyse\CrossAnalyse\obj\Debug\CrossAnalyse.csproj.GenerateResource.Cache
     文件       11776  2009-01-05 15:58  交叉表\CrossAnalyse\CrossAnalyse\obj\Debug\CrossAnalyse.exe
     文件         180  2009-01-05 15:58  交叉表\CrossAnalyse\CrossAnalyse\obj\Debug\CrossAnalyse.Form1.resources
     文件       22016  2010-08-18 17:51  交叉表\CrossAnalyse\CrossAnalyse\obj\Debug\CrossAnalyse.pdb
     文件         180  2009-01-05 15:58  交叉表\CrossAnalyse\CrossAnalyse\obj\Debug\CrossAnalyse.Properties.Resources.resources
     目录           0  2012-05-02 09:57  交叉表\CrossAnalyse\CrossAnalyse\obj\Debug\TempPE\
     文件         493  2008-12-01 14:02  交叉表\CrossAnalyse\CrossAnalyse\Program.cs
     目录           0  2013-01-25 10:28  交叉表\CrossAnalyse\CrossAnalyse\Properties\
     文件        1389  2008-12-11 14:30  交叉表\CrossAnalyse\CrossAnalyse\Properties\AssemblyInfo.cs
     文件        2874  2008-12-01 14:02  交叉表\CrossAnalyse\CrossAnalyse\Properties\Resources.Designer.cs
     文件        5612  2008-12-01 14:02  交叉表\CrossAnalyse\CrossAnalyse\Properties\Resources.resx
     文件        1097  2008-12-01 14:02  交叉表\CrossAnalyse\CrossAnalyse\Properties\Settings.Designer.cs
     文件         249  2008-12-01 14:02  交叉表\CrossAnalyse\CrossAnalyse\Properties\Settings.settings
............此处省略3个文件信息