使用async / await填充DGV [英] using async / await to fill DGV

问题描述

嗨
我有使用async / await方法触发datagridview的问题。



按钮点击事件：

Hi I am have a litle problems firing my datagridview using the async / await method.

Button click event:

private async void button2_Click(object sender, EventArgs e)
        {
            datagridview1.Visible = true;
            //Progressbar  
            Progressbar1  .Visible = true;
            Progressbar1  .Style = ProgressBarStyle.Marquee;
            var period2 = cb1.SelectedValue.ToString();
            var period1 = cb2.SelectedValue.ToString();
           

            /*A variable to hold the parameters*/
            //var table = await loadTable((period1, period2));

            await Task.Run(() => loadTable(period1, period2));

             /*back to the UI */
            //datagridview1.DataSource = datatable;
            
            //datagridview1.DataSource = table;

            Progressbar1  .Visible = false;
        }

我尝试使用两个// datagridview.DataSource行来获取DGV但没有成功。< br $>


我的任务方法：

I haved tried fetching the DGV by using the using the two // datagridview.DataSource line without success.

My Task method:

 private async Task Zugänge(string period1, string period2) 

{

    //
    string C = ConfigurationManager.ConnectionStrings["123"].ConnectionString;
    using (var con = new SqlConnection(C))
    using (var cmd = new SqlCommand())
    {
        cmd.Connection = con;
        cmd.CommandText = ("[dbo].[spInfo]");
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@Periode2", period2);
        cmd.Parameters.AddWithValue("@Periode1", period1);
        // open the connection
        con.Open();
        SqlDataAdapter adapter = new SqlDataAdapter(cmd);
        DataTable datatable = new DataTable();
        adapter.Fill(datatable );
       
        await Task.Run(() => adapter.Fill(datatable ));
        
    }
}

推荐答案

我添加了一个返回结束我的Task方法：< br $>

I added a return to end of my Task method:

private async Task Zugänge(string period1, string period2) 
 
{
 
    //
    string C = ConfigurationManager.ConnectionStrings["123"].ConnectionString;
    using (var con = new SqlConnection(C))
    using (var cmd = new SqlCommand())
    {
        cmd.Connection = con;
        cmd.CommandText = ("[dbo].[spInfo]");
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@Periode2", period2);
        cmd.Parameters.AddWithValue("@Periode1", period1);
        // open the connection
 // Here open the connection async:
        await con.OpenAsync();
        SqlDataAdapter adapter = new SqlDataAdapter(cmd);
        DataTable datatable = new DataTable();
        adapter.Fill(datatable );
       
        await Task.Run(() => adapter.Fill(datatable ));
return dt;
        
    }
}

这篇关于使用async / await填充DGV的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！