datarow

Accessing DataTable.Rows performace decreases over time?

I have a IHttpHandler that I'm using to import an uploaded CSVfile into a database. The class has a static DataTable variable. They first time the handler is run, it opens the CSV file, reads it in to the static DataTable class and closes the file. Each time the handler is accessed after that point it starts a a for loop with the reques...

Is it possible to figure out WHAT is changing in a RowChanging event?

The DataTable class has RowChanging as well as RowChanged events, which is convenient (for those of us foolish enough to be using the DataTable class in the first place). Event handlers for these events take a parameter of type DataRowChangeEventArgs, whose properties comprise a DataRowAction (Add, Change, Delete, etc.) and the DataRow b...

select distinct from dataset

I have got duplicate rows in a dataset. how can i select distinct rows from that. From comments: My query is something like this: select name, age from student When I receive its output in a dataset the output consists of rows having duplicate names. Using dataset itself I have to select distinct name from this because I need the s...