Backgroundworker + Sql

Hot Topic

predefined attributes
Reversing Rows of an Image in a Byte Array
confused with runtime error and compiletime error
app.config
GetEnumerator question
dayOfWeek and hour of SysTime sample
waiting for an event
Display image from SQL DB on to Picturebox In Windows Forms App Using C# 2.0
Using WMI to get Current Logged On User
string vs. String / double - Double / etc.

Visual C#

How do I change the default language in Visual Studio 2005?
Connection string for MS Access database having password to open
Identifying a local IP from internet
Active scripting and webservices
XML socket problem?
anyway to improve IDE performance
Simple C# dll project template
namespace const and enum
synchronization???????????????????
app.config

Backgroundworker + Sql

Hi

I am using a Backgroundworker do load media files from a Sql Server. The user should be able to cancel this operation, but I am not sure how to implement this. If I call backgroundWorker1.CancelAsync(); there is no while-loop I can stop.

private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)

{

...

XmlReader myReader = XmlReader.Create(sqlCommand.ExecuteXmlReader(), mySettings);

....

}

Thank you

Answer this question

Backgroundworker + Sql

  • rodniko

    Thanks for the answer, but what I want to know is, how can I cancel Sql queries If the the transfer rate is low or the Sql Server unreachable, how can I stop the BackgroundWorker (a user can hit cancel to abort the operation)

    public DataTable GetData(string sqlCmd)

    {

    sqlCommand = new SqlCommand(sqlCmd, sqlConnection);

    SqlDataAdapter adapter = new SqlDataAdapter();

    adapter.SelectCommand = sqlCommand;

    DataTable table = new DataTable();

    table.Locale = System.Globalization.CultureInfo.InvariantCulture;

    adapter.Fill(table); // I want to allow users to cancel this statement which is run by BackgroundWorker

    sqlCommand = null;

    return table;

    }

    P.S How can I format code examples for the forum

    Thanks again.

  • Bram Veenhof

  • Backgroundworker + Sql
Answer this question