c# - 避免 datagridview 的按钮点击/控件；自动显示

Question

我不想使用按钮控件，我只想显示数据，然后在 gridview 中按照代码状态将数据传输到 excel 中。有没有办法消除/跳过按钮控制/点击？

public partial class Form1 : Form
{
    public Form1()
    {
        InitializeComponent();
    }

    private void button1_Click(object sender, EventArgs e)
    {
        string[] fileEntries = Directory.GetFiles(@"c:\Sciclone UAC", "*.cfg*");
        foreach (string fileName in fileEntries)
        {

            var query = from file in fileEntries
                        let doc = XDocument.Load(file)
                        let x = doc.Descendants("XAxisCalib").Single()
                        let y = doc.Descendants("YAxisCalib").Single()
                        let z = doc.Descendants("ZAxisCalib").Single()
                        select new
                        {

                            XMax = x.Element("Max").Value,
                            XMin = x.Element("Min").Value,
                            YMax = y.Element("Max").Value,
                            YMin = y.Element("Min").Value,
                            ZMax = z.Element("Max").Value,
                            ZMin = z.Element("Min").Value
                        }; 


            var bs3 = new BindingSource { DataSource = query };

            dataGridView1.AutoGenerateColumns = true;
            dataGridView1.AutoSize = true;

            dataGridView1.DataSource = bs3;
        }
    }

    private void button2_Click(object sender, EventArgs e)
    {
        Excel.Application xlApp ;
        Excel.Workbook xlWorkBook ;
        Excel.Worksheet xlWorkSheet ;
        object misValue = System.Reflection.Missing.Value;

        xlApp = new Excel.Application();
        xlWorkBook = xlApp.Workbooks.Add(misValue);
        xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);

Answer 1

只需将代码拉出到函数中:

public Form1()
{
    InitializeComponent();
    // Could add calls here
    LoadData();
    RunExcel();
}

// Remove this button click handler if desired
private void button1_Click(object sender, EventArgs e)
{
   LoadData();
}

// Remove this button click handler if desired
private void button2_Click(object sender, EventArgs e)
{
   RunExcel();
}

private void LoadData()
{
    string[] fileEntries = Directory.GetFiles(@"c:\Sciclone UAC", "*.cfg*");
    foreach (string fileName in fileEntries)
    {

        var query = from file in fileEntries
                    let doc = XDocument.Load(file)
                    let x = doc.Descendants("XAxisCalib").Single()
                    let y = doc.Descendants("YAxisCalib").Single()
                    let z = doc.Descendants("ZAxisCalib").Single()
                    select new
                    {

                        XMax = x.Element("Max").Value,
                        XMin = x.Element("Min").Value,
                        YMax = y.Element("Max").Value,
                        YMin = y.Element("Min").Value,
                        ZMax = z.Element("Max").Value,
                        ZMin = z.Element("Min").Value
                    }; 


        var bs3 = new BindingSource { DataSource = query };

        dataGridView1.AutoGenerateColumns = true;
        dataGridView1.AutoSize = true;

        dataGridView1.DataSource = bs3;
    }
}

private void RunExcel()
{
   Excel.Application xlApp ;
   Excel.Workbook xlWorkBook ;
   Excel.Worksheet xlWorkSheet ;
   object misValue = System.Reflection.Missing.Value;

   xlApp = new Excel.Application();
   xlWorkBook = xlApp.Workbooks.Add(misValue);
   xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
   ....
}