基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：813200300

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

从数据库读取数据 加载至树形空间

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Timers;
using System.IO;
using Excel = Microsoft.Office.Interop.Excel;
using System.Data.OleDb;

using System.Data.SqlClient;
using System.Windows.Forms;

namespace vs.net
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        public void GetCavenMenu(TreeNode newNodeA, ToolStripDropDownItem newmenuA, bool BL)
        {
            bool Var_bool = true;
            if (newmenuA.HasDropDownItems && newmenuA.DropDownItems.Count > 0)
                for (int j = 0; j < newmenuA.DropDownItems.Count;j   )
                {
                    TreeNode newNodeB = newNodeA.Nodes.Add(newmenuA.DropDownItems[j].Text);
                    Var_bool = true;
                    if (BL == false)
                    {
                        newNodeB.ForeColor = Color.Silver;
                        newNodeB.Tag = 0;
                        Var_bool = false;
                    }
                    else
                    {
                        if (newmenuA.DropDownItems[j].Enabled == false)
                        {
                            newNodeB.ForeColor = Color.Silver;
                            newNodeB.Tag = 0;
                            Var_bool = false;
                        }
                        else
                        {
                            newNodeA.ForeColor = Color.Black;
                            newNodeB.Tag = int.Parse(newmenuA.DropDownItems[j].Tag.ToString());
                        }

                    }
                    ToolStripDropDownItem newmenuB = (ToolStripDropDownItem)newmenuA.DropDownItems[j];
                    if (newmenuB.HasDropDownItems && newmenuA.DropDownItems.Count > 0)
                    {
                        newNodeB.Tag = 0;
                        GetCavenMenu(newNodeB, newmenuB, Var_bool);
                    }

                }
        }

        public void GetMenu(TreeView treeV, MenuStrip MenuS)
        {
            bool Var_Bool = true;
            for (int x = 0; x < MenuS.Items.Count; x  ) //遍历MenuStrip组件中的一级菜单项
            {
                //将一级菜单项的名称添加到TreeView组件的根节点中，并设置当前节点的子节点newNode1
                TreeNode newNode1 = treeV.Nodes.Add(MenuS.Items[x].Text);
                if (MenuS.Items[x].Enabled == false)//判断当前项是否为可用
                {
                    newNode1.ForeColor = Color.Silver;//改变树节点的字体颜色为不可用色
                    Var_Bool = false;
                }
                else
                {
                    newNode1.ForeColor = Color.Black;//改变树节点的字体颜色为可用色
                    Var_Bool = true;
                }
                newNode1.Tag = 0;//标识，有子项的命令项
                //将当前菜单项的所有相关信息存入到ToolStripDropDownItem对象中
                ToolStripDropDownItem newmenu = (ToolStripDropDownItem)MenuS.Items[x];
                GetCavenMenu(newNode1, newmenu, Var_Bool);//添加多层命令项
            }
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            comboBox1.DropDownStyle = ComboBoxStyle.DropDownList;
            comboBox1.Items.Add("明日科技");
            comboBox1.Items.Add("C#编程实战");
            comboBox1.Items.Add("C#从基础到项目实战");


            dateTimePicker1.Format = DateTimePickerFormat.Custom;
            dateTimePicker1.CustomFormat = "yyyy-mm-dd hh:mm:ss";
            dateTimePicker1.Value = DateTime.Now;
            dateTimePicker1.Value = System.DateTime.Now;
            dateTimePicker1.Text = System.DateTime.Now.ToString();
            label1.Text = dateTimePicker1.Text;
            label2.Text = dateTimePicker1.Value.Year.ToString();
            label3.Text = dateTimePicker1.Value.Month.ToString();
            label4.Text = dateTimePicker1.Value.Day.ToString();

            dateEdit1.DateTime = System.DateTime.Now;
            timeEdit1.Time = System.DateTime.Now;
        }

          

        private void button1_Click(object sender, EventArgs e)
        {
            progressBar1.Value = 0;
            progressBar1.Minimum = 0;
            progressBar1.Maximum = 2000;
            progressBar1.Step = 1;
            for (int i = 0; i < 2000; i  )
            {
                progressBar1.PerformStep();
                label5.Text = "";
                label5.Text = "进度值"   progressBar1.Value.ToString();
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {

            //*****************************
            SqlConnection sqlcon = new SqlConnection("data source  = sqlsrv ;database = igs ; uid = sa; pwd=123");
            SqlDataAdapter myda;
            DataSet myds;

            myda = new SqlDataAdapter("select * from dbo.ms_employee where emp_no >1000 and leaving_date is null", sqlcon);
            myds = new DataSet();
            myda.Fill(myds);
            dataGridView1.DataSource = myds.Tables[0];
            //*****************************
           
            ExportDataGridview(dataGridView1,true);

        }
        public bool ExportDataGridview(DataGridView dgv , bool isShowExcle)
            {
                if (dgv.Rows.Count == 0 )
                    return false;

               // 建立连接excel

                Excel.Application excel = new Excel.Application();
                excel.Application.Workbooks.Add(true);
                excel.Visible = isShowExcle;
               
                for (int i = 0 ; i<dgv.ColumnCount;i  )
                {
                    excel.Cells[1,i 1] = dgv.Columns[i].HeaderText;

                }
            //  填充数据
                for (int n = 0; n < dgv.RowCount - 1 ; n  )
                {
                    for (int j = 0; j < dgv.ColumnCount; j  )
                    {
                        if (dgv[j, n].ValueType == typeof(string))
                        {
                            excel.Cells[n   2, j   1] = "'"   dgv[j, n].Value.ToString();
                        }
                        else
                        {
                            excel.Cells[n   2, j   1] = dgv[j, n].Value.ToString();
                        }
                        // excel.Cells[n   2, j   1] = dgv[n, j].Value.ToString();
                    }
                }

              return true;
            }
       
        private void toolStripMenuItem8_Click(object sender, EventArgs e)
        {

        }

        private void toolStripMenuItem15_Click(object sender, EventArgs e)
        {

        }

        private void button3_Click(object sender, EventArgs e)
        {
            //GetCavenMenu(treeView1, menuStrip1, true);
            //GetCavenMenu();

            GetMenu(treeView1, menuStrip1);
        }

        
    }
}