大量数据一次性显示到dataGridView不卡界面

网上大量说绑定到dataGridview不卡界面的，我大部分都试用了，结果表明还是卡，最好的2万多条也要卡3秒以上，我这个大约大约卡界面一秒不到，接受范围内~仅供参考，只有部分代码，不过缺省的也就是一些自动生成的代码~ 

工具VS2013，语言C#

 Thread threadG;//声明线程
        delegate void changetext(DataTable result);

  //创建一个委托
  public delegate void UpdateD(DataTable result);
  public UpdateD updated;

 private void dGV_Load(object sender, EventArgs e)
 {
      ThreadStart threaddgv = new ThreadStart(Getdgv);
      threadG = new Thread(threaddgv);
      //  threadG.IsBackground = true;
     threadG.Start();

      updated = new UpdateD(UpdateDataTable);
  }

public void Getdgv()
        {
            con1.ConnectionString = "server=.;database=T_JNS;uid=sa;pwd=sa";
            con.ConnectionString = "server=.;database=T_JNS;uid=sa;pwd=sa";

            con1.Open();

            string sql = "select T_Value0 通道1,T_Value1 通道2, T_numNC 内存长度, T_Index 点位,T_dtime 测试时间 from T_SJCJ where T_Value0>0 and T_Value1>0 and T_Value0< 6.4120 and T_Value1<6.402  order by T_Index";

            DataTable dt = new DataTable();
            SqlCommand cmd = new SqlCommand(sql, con1);
   
            SqlDataAdapter sdz = new SqlDataAdapter(sql, con1);
            DataSet ddz = new DataSet();
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            adapter.Fill(dt);
            sdz.Fill(ddz);
            con1.Close();
            // HYSdGV.DataSource = ddz.Tables[0];
            System.Data.DataTable table = new DataTable();
            System.Data.DataColumn column = new DataColumn();
        //    column.ColumnName = "序号";
         //   column.AutoIncrement = true; //是否为自增
          //  column.AutoIncrementSeed = 1; //开始
          //  column.AutoIncrementStep = 1;//自增+1
       //     table.Columns.Add(column);
            table.Merge(ddz.Tables[0]);
        
            int i = 0;
            // Console.WriteLine("输出取得的数值：");
            foreach (DataRow dr in dt.Rows)
            {

                //  Console.WriteLine(dr[0].ToString());
                d1[i] = dr[0].ToString();
                d2[i] = dr[1].ToString();

                s3[i] = dr[2].ToString();
                i++;

            }
            DataTable result = table;
          //  CalcFinished(result);
            Invoke(new changetext(Changetext), new object[] { result });
        }
        public void Changetext(DataTable result)
        {

            dataGridView1.DataSource = result;
        }

         public void UpdateDataTable(DataTable result)
        {
            dataGridView1.DataSource = result;

        }

 public void CalcFinished(DataTable result)
        {
            if (this.dataGridView1.InvokeRequired)
            {
                while (!this.dataGridView1.IsHandleCreated)
                {
                    if (this.dataGridView1.Disposing || this.dataGridView1.IsDisposed)
                    {
                        return;
                    }
                }
                changetext c = new changetext(CalcFinished);
                this.dataGridView1.Invoke(c, new object[] { result });
          
                //   OutPutResult(_grpGetData.Text, _btnGetMeasureData.Text, result);
            }
            else
            {
                dataGridView1.DataSource = result;
              //  dataGridView1.Columns["序号"].DisplayIndex = 0;
            }
        }

另外可以参考：https://blog.csdn.net/bowangting/article/details/88535879