Windows Forms

jogisarge wrote:

how could this be handled ?

Rahul Say hiiiii wrote:

Can u give me a names of thoird party control

public void DoBackgroundWork(string stringParameter, int intParameter)
{
    bgWorker = new BackgroundWorker();
    bgWorker.WorkerReportsProgress = false;
    bgWorker.WorkerSupportsCancellation = false;
    bgWorker.DoWork += new DoWorkEventHandler(DoWorkAsync);
    bgWorker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(DoWorkAsyncCompleted);
    bgWorker.RunWorkerAsync(new object[] { stringParameter, intParameter }); <--- pass parameters here
}

public void DoWorkAsync(object sender, DoWorkEventArgs e)
{
    object[] parameters = (object[])e.Argument; <--- unpack the parameters here
    string stringParameter = (string)parameters[0];
    int intParameter = (int)parameters[1];
    <... do work tasks here ...>
    bool boolResultValue = ...; <--- prepare result values for WorkCompleted handler
    string stringResultValue = ...;
    object[] results = new object[2];
    results[0] = boolResultValue;
    results[1] = stringResultValue
    e.Result = results; <--- pass result data to WorkCompleted handler
}

public void DoWorkAsyncCompleted(object sender, RunWorkerCompletedEventArgs e)
{
    object[] results = (object[])e.Result; <--- unpack the result data here
    bool boolResultValue = (bool)results[0];
    string stringResultValue = (string)results[1];
    <... do result tasks here ...>
}

Uma Kameswari wrote:

can some one let me know the points to be taken care when working with huge volumes of data

Uma Kameswari wrote:

Each of them has 30+lakhs of records

Mika Wendelius wrote:

I don't know what 30+lakhs means.

Luc Pattyn [Forum Guidelines] [My Articles]

---

Fixturized forever.

---

Luc Pattyn wrote:

30+lakhs is more than 3 million

Luc Pattyn wrote:

that is a lot of rows...

Uma Kameswari wrote:

a stored procedure that uses cursor