progress bar while calling SqlDataAdapter.fill

[Guest]

Can i show the progress of a SqlDataAdapter1.Update(m_ds, "XLData") statment?

 

[Miha Markic [MVP C#]]

Yup, see RowChanging and RowChanged events.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Can i show the progress of a SqlDataAdapter1.Update(m_ds, "XLData")

statment?

 

[Sahil Malik]

I doubt you can directly .. let me address fill rather than update at this
point since the answers will be mostly similar.

You could use the overload

public int Fill(DataSet, int, int, string);
Adds or refreshes rows in a specified range in the DataSet to match those in
the data source using the DataSet, DataTable, and IDataReader names.

and be able to show the progressbar at the cost of performance.

Or, you could use one of the virtuals accepting a datareader and use those
to give this func. But really your database access layer ideally should be
far far away from the UI. And if you need to show a progressbar, can you
imagine how heavy is the object you are filling?

- Sahil Malik
Independent Consultant
You can reach me thru my blog - http://dotnetjunkies.com/WebLog/sahilmalik/

Can i show the progress of a SqlDataAdapter1.Update(m_ds, "XLData")

statment?

 

[William Ryan eMVP]

Trap either OnRowUpdating (which happens before) or OnRowUpdated (which
happens after)

--

W.G. Ryan, eMVP

http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/

Can i show the progress of a SqlDataAdapter1.Update(m_ds, "XLData")

statment?

 

[Sahil Malik]

Like Kyle would say - I've learnt something today. .. man that is amazing
though.

- Sahil Malik
Independent Consultant
You can reach me thru my blog - http://dotnetjunkies.com/WebLog/sahilmalik/

Yup, see RowChanging and RowChanged events.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Can i show the progress of a SqlDataAdapter1.Update(m_ds, "XLData")

statment?

 

[Miha Markic [MVP C#]]

Sorry, I've made a typo.
William is right, RowUpdated and RowUpdating are the correct ones .

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Yup, see RowChanging and RowChanged events.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Can i show the progress of a SqlDataAdapter1.Update(m_ds, "XLData")

statment?

 

[Cor Ligthert]

Hi Miha,

Did you read the subject?

(Although the message is about the update).



Cor

 

[Miha Markic [MVP C#]]

Haha, I am not sure anymore what I read ;-)
You guys are confusing me

 

[Tommy Malone]

So does the return value "i = daAdapter.fill" come before all the updates?

For example, will you know how many times OnRowUpdating and OnRowUpdated
will be called before that process starts?