Loading Lots of Data

bmains · June 12th, 2006, 03:12 PM

Hello,

I'm loading a lot of data into the API; is there a way I can make that asyncronous, so I don't have to wait in the application the whole time while it loads? I know of the background worker control, but I'm in the API and not doing this in a windows form. What approach should I use? I'm using SQL Server express database.

Thanks.

Brian

DZukiewicz · January 28th, 2008, 12:57 PM

You can you BeginExecuteReader and then EndExecuteReader to do the query.

Code:

SqlConnection sqlConn = new SqlConnection( ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString );

using(SqlCommand comm = new SqlCommand())
{
     comm.CommandType = CommandType.Text;
     comm.CommandText = "Select * from tblBig";

     IAsyncResult res = comm.BeginExecuteReader();

     /////// Do your long operation

     SqlDataReader dr = comm.EndExecuteReader(res);

     //Enquire data.
}

Hope this helps,

Dominic