好得很程序员自学网

<tfoot draggable='sEl'></tfoot>

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

本文实例讲述了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;

   }

  }

}

希望本文所述对大家的C#程序设计有所帮助。

dy("nrwz");

查看更多关于C#异步绑定数据实现方法的详细内容...

  阅读:69次