解决netMarketing类库dataSetHelper类在多线程下的使用问题


在v1.3.0版本的netMarketing类库中,dataSetHelper类已经做了多线程安全性的处理。

对于在多线程下绑定dataTable到dataGridView控件时出现的错误(见下图1),这一版已经做了处理。

image.png

(图1)


详细的解决办法请参考下面的演示程序。

其关键的是使用returnDataTableCopy()函数返回表的拷贝,而不是直接使用returnDataTable()返回表对象。

 myDataGridView1.DataSource = null;
 myDataGridView1.DataSource = set.returnDataTableCopy(0);


image.png


using sharClass;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        dataSetHelper set = new dataSetHelper("set1");
        List<student> data = new List<student>();
        Thread t1,t2,t3,t4,t5;
        
        public Form1()
        {
            InitializeComponent();
            set.createTable("tab1", "name,age,workAge", "string,int,int");
            //this.myDataGridView1.DataError += myDataGridView1_DataError;

            for (int i = 0; i < 10; i++)
            {
                addNew();
            }
            t1 = new Thread(new ThreadStart(fun1));
            t1.IsBackground = true;
            t2 = new Thread(new ThreadStart(fun2));
            t2.IsBackground = true;

            t3 = new Thread(new ThreadStart(fun3));
            t3.IsBackground = true;
            t4 = new Thread(new ThreadStart(fun4));
            t4.IsBackground = true;
            t5 = new Thread(new ThreadStart(fun5));
            t5.IsBackground = true;
        }

        //void myDataGridView1_DataError(object sender, DataGridViewDataErrorEventArgs e)
        //{

        //}

        private void Form1_Load(object sender, EventArgs e)
        {
            
        }

        private void timer1_Tick(object sender, EventArgs e)
        {
            myDataGridView1.DataSource = null;
            myDataGridView1.DataSource = set.returnDataTableCopy(0);
            addNew();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            timer1.Enabled = true;
            timer1.Start();
            timer2.Enabled = true;
            timer2.Start();
            t1.Start();
            t2.Start();
            t3.Start();
            t4.Start();
            t5.Start();
        }


        private void addNew()
        {
            try
            {
                var data = new List<object>(){
                randomHelper.GenerateRndNumLetter(8),
                randomHelper.GetRandomInt(11, 55),randomHelper.GetRandomInt(5555, 9999) };
                set.appendRowData("tab1", data);
            }
            catch(Exception ex)
            {

            }
        }

        private void removeOneRow()
        {
            try
            {
                var tab = set.ReturnDataTable(0);
                if (tab.Rows.Count > 2)
                    set.delRow("tab1", randomHelper.GetRandomInt(0, tab.Rows.Count - 1));
            }
            catch(Exception ex)
            {
                //MessageBox.Show(ex.Message);
            }
        }

        private void timer2_Tick(object sender, EventArgs e)
        {
            addNew();
            
        }

        private void fun1()
        {
            while(true)
            {
                if (randomHelper.GetRandomInt(1, 100) % 2 == 0)
                    removeOneRow();
                else
                    addNew();
                Thread.Sleep(200);
            }
        }

        private void fun2()
        {
            while (true)
            {
                if (randomHelper.GetRandomInt(1, 100) % 2 == 0)
                    removeOneRow();
                else
                    addNew();
                Thread.Sleep(200);
            }
        }

        private void fun3()
        {
            while (true)
            {
                if (randomHelper.GetRandomInt(1, 100) % 2 == 0)
                    removeOneRow();
                else
                    addNew();
                Thread.Sleep(200);
            }
        }

        private void fun4()
        {
            while (true)
            {
                if (randomHelper.GetRandomInt(1, 100) % 2 == 0)
                    removeOneRow();
                else
                    addNew();
                Thread.Sleep(200);
            }
        }

        private void fun5()
        {
            while (true)
            {
                if (randomHelper.GetRandomInt(1, 100) % 2 == 0)
                    removeOneRow();
                else
                    addNew();
                Thread.Sleep(200);
            }
        }
    }

    public class student
    {
        public string name { get; set; }
        public int age { get; set; }
        public int workAge { get; set; }
    }
}

--------------------- 

作者:hackpig
来源:www.skcircle.com
版权声明:本文为博主原创文章,转载请附上博文链接!


本文出自勇哥的网站《少有人走的路》wwww.skcircle.com,转载请注明出处!讨论可扫码加群:

发表评论:

◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。

会员中心
搜索
«    2025年4月    »
123456
78910111213
14151617181920
21222324252627
282930
网站分类
标签列表
最新留言
    热门文章 | 热评文章 | 随机文章
文章归档
友情链接
  • 订阅本站的 RSS 2.0 新闻聚合
  • 扫描加本站机器视觉QQ群,验证答案为:halcon勇哥的机器视觉
  • 点击查阅微信群二维码
  • 扫描加勇哥的非标自动化群,验证答案:C#/C++/VB勇哥的非标自动化群
  • 扫描加站长微信:站长微信:abc496103864
  • 扫描加站长QQ:
  • 扫描赞赏本站:
  • 留言板:

Powered By Z-BlogPHP 1.7.2

Copyright Your skcircle.com Rights Reserved.

鄂ICP备18008319号


站长QQ:496103864 微信:abc496103864