Retrieving Data From DataSets 1

[khowell78737]

I have 2 functions that make entries "SQL" safe. They add or replace SQL unsafe charactors like "," with "~,~".

My problem is that when I bind a dataset to a control, I have no way to remove the "~" charactors where present.

I am creating a dataSet from an Access datastore from a query that could return over 500 records.

I have found that creating a dataReader and looping through it to .add each row enabling me to strip the charactors is unacceptably slow. Even populating the combo from a dataReader w/o running the stripping procedure on strings (like I do in ASP, ASP.NET) is unrealistically slow.

How do you suggest that I deal with this issue?

Thanks in advance,
Kevin Howell

 

[fawkes]

Each dataset will have a datatable associated with it. Try looking at the datatable and performing operations on that.

 

[fawkes]

If users are entering data through a datagrid into the dataset then use the getChangedRows method of the underlying datatable to get any data that has changed and just check this.