C# 使用线程定时刷新dataGridView

最新推荐文章于 2023-08-11 21:29:02 发布

开局一个bug

最新推荐文章于 2023-08-11 21:29:02 发布

阅读量3k

点赞数 4

分类专栏： C# 文章标签： C# winform

本文链接：https://blog.csdn.net/weixin_42322532/article/details/102974983

版权

C# 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

  #region 线程刷新dataGridView Demo
        private Thread th;
        private bool bol = true;
        private void getdata()
        {
            th = new Thread(new ThreadStart(StartData));
            th.IsBackground = true;
            th.Start();
        }
        private delegate void InvokeHandler();
        private void StartData()
        {
            try
            {
                while (true)
                {
                    if (this.IsHandleCreated)
                    {
                        string sql = string.Format(@"SELECT  top 5 [LogID]
                                          ,[esn]
                                          ,[EquipmenName]
                                          ,[StatesName]
                                          ,[Ltime]
                                          ,[UName]
                                      FROM [hongd39].[dbo].[hongd39.RC_Logs]
                                     order by LogID desc ");

                   
                        //dataGridView1.BeginInvoke(new ThreadStart(delegate()
                        //     {
                        //         dataGridView1.DataSource = DBHelper.ExcuteDataTable(sql);
                        //         data.dategirds(dataGridView1);
                        //     }));
                        this.Invoke(new InvokeHandler(delegate()
                        {
                            dataGridView1.DataSource = DBHelper.ExcuteDataTable(sql);
                            data.dategirds(dataGridView1);
                        }));
                    }
                    Thread.Sleep(100);
                }
            }
            catch
            {
                return;
            }
        }
        private void button1_Click(object sender, EventArgs e)
        {
            if (bol)
            {
                getdata();
            }
        }
        private void button2_Click(object sender, EventArgs e)
        {
            th.Interrupt();
            bol = true;
        }
        private void Form1_Load(object sender, EventArgs e)
        {
            getdata();
        }
        #endregion