C#异步绑定数据实现方法

Z时代
2024-01-10
分类：综合

本文实例讲述了C#异步绑定数据实现方法。分享给大家供大家参考。具体如下：


using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using System.Windows.Forms;
namespace WindowsApplication2
{
 public class AsyncCallBackOpeartion
 {
  private static DataGridView dataGridView;
  public static void AsyncCallBack(string connectionString, string sql, DataGridView dgv)
  {
   dataGridView = dgv;
   connectionString += ";Asynchronous Processing=true";
   SqlConnection conn = new SqlConnection(connectionString);
   SqlCommand command = new SqlCommand(sql, conn);
   conn.Open();
   command.BeginExecuteReader(new AsyncCallback(AsyncCallBack), command);
  }
  static void AsyncCallBack(IAsyncResult ar)
  {
   if (ar.IsCompleted)
   {
    SqlCommand com = (SqlCommand)ar.AsyncState;
    SqlDataReader dr = com.EndExecuteReader(ar);
    DataTable dt = new DataTable();
    dt.Load(dr);
    dr.Close();
    if (dataGridView.InvokeRequired)
    {
     updateDG ur = new updateDG(dataBin);
     dataGridView.Invoke(ur, dt);
    }
   }
  }
  delegate void updateDG(DataTable dt);
  public static void dataBin(DataTable dt)
  {
   dataGridView.DataSource = dt;
  }
 }
}