C#异步绑定数据实现方法
本文实例讲述了C#异步绑定数据实现方法。分享给大家供大家参考。具体如下:
usingSystem;
usingSystem.Collections.Generic;
usingSystem.Text;
usingSystem.Data.SqlClient;
usingSystem.Data;
usingSystem.Windows.Forms;
namespaceWindowsApplication2
{
publicclassAsyncCallBackOpeartion
{
privatestaticDataGridViewdataGridView;
publicstaticvoidAsyncCallBack(stringconnectionString,stringsql,DataGridViewdgv)
{
dataGridView=dgv;
connectionString+=";AsynchronousProcessing=true";
SqlConnectionconn=newSqlConnection(connectionString);
SqlCommandcommand=newSqlCommand(sql,conn);
conn.Open();
command.BeginExecuteReader(newAsyncCallback(AsyncCallBack),command);
}
staticvoidAsyncCallBack(IAsyncResultar)
{
if(ar.IsCompleted)
{
SqlCommandcom=(SqlCommand)ar.AsyncState;
SqlDataReaderdr=com.EndExecuteReader(ar);
DataTabledt=newDataTable();
dt.Load(dr);
dr.Close();
if(dataGridView.InvokeRequired)
{
updateDGur=newupdateDG(dataBin);
dataGridView.Invoke(ur,dt);
}
}
}
delegatevoidupdateDG(DataTabledt);
publicstaticvoiddataBin(DataTabledt)
{
dataGridView.DataSource=dt;
}
}
}
希望本文所述对大家的C#程序设计有所帮助。