Thks !!

The solution was so easyyyyy....

yes.but by this soloution instead of added rowstate we will have modefied state

thanks Paul it was very helpful for me

thanks a lot

Thanks ! worked perfectly!

Thanks a lots Paul. It solved my problem. ^_

Hey it worked.. thanks..

Thank you very much,it is very use full for me

Thanks a lot Paul...really a very good solution...solved my problem...

Good Work!

Hey guys,

I have the same problem but with columns instead.. I want to build a datatable that contains only a subset of columns of another datatable. Is there a function similar to clone that works with columns

DataTable FeatK1 = new DataTable();

            DataColumn intID= TableIntSub.Columns["IntID"];
            DataColumn dc1 = TableIntSub.Columns[featureName + '1'];
            DataColumn dc2 = TableIntSub.Columns[featureName + '2'];
            FeatK1.Columns.Add(intID);--> THIS IS WHERE THE ERROR STARTS
            FeatK1.Columns.Add(dc1);
            FeatK1.Columns.Add(dc2);

Thanks buddy..great work..really helpful..

Thanks buddy..great work..really helpful..

Thanks, worked for me too!

Another way is to use the ToArray property of the DataRow object and feed the to the DataTable.Rows.Add method:

newTable.Rows.Add(originalRow.ToArray);

Many thanks - Nice little solution to a pesky error And you're right - Does make sense once you see it

Thank you..................Very very much paul, Short and strong stuff.

Thanks was so hellful, great solution

Thank you so much! I was getting pretty frustrated!

You're awesome!!!

Thanks a lot,

It solved my problem that was struked for a long time

Thanks again

Thanks a lot. It really help me. I already got this problem for so long, and the solution is very easy. Once again thanks a lot.

Hi

I normally don't post comments on peoples sites. But, I want to thank you for saving me heaps of time trying to figure this out. I knew there would be an easy solution to my problem and your's was it !!!

Cheers

TableNoob

Thanks! This is exactly what i needed

good work man, thanks!

Thanks buddy!!

So many "thanks", here's another

Just copied and paste the error in, it seems so many people have the same kinda programming style. Clearly Microsoft didnt want to do it this way. Awsome man, Cheers.

Your help is soooo nice like u..........!

AWESOME! Thanks for that!

Gotta love GoogleMagic!

Excellent..Tnx Paul!

thx!!!

Just thanks, thanks, very much.

Thanks a lot ,ur solution is very easy and so simple

Its working fine thanx.

Doesn't seem to work on VS 2003/ADO.Net 1.0. 'System.Data.DataRowCollection' does not contain a definition for 'Import'. Darn it! It was such a nice, neat workaround, too.

10x for the solution, i wonder if you find any reference at the msdn.

if same schema u can use dt_tmp.Rows.Add(row.ItemArray); work for me

Thanks, This is just the solution I was looking for

Really helpfull. i applied it in my code

Thanks alot

Thanks alot Paul.

if i wanted to add the nex 48 row how can i do it programmatically...

I use this to get it, but kinda of weird..is it a normal practice?

StreamReader dataStream = File.OpenText(Server.MapPath(@"Data/data.txt"));

                        int i =0;
                        int count = 0;
                        bool found = false;
                        try
                        {
                                DataTable dt = CsvParser.Parse(dataStream,false);
                                DataTable dtNew = new DataTable();
                                dtNew = dt.Clone();
                                foreach (DataRow dRow in dt.Rows)
                                {
                                        i++;


                                        if(ddMeterId.SelectedValue.Equals(dRow["Column1"].ToString()))
                                        {
                                                found = true;
                                        }
                                        if(found)
                                        {
                                                dtNew.ImportRow(dRow);
                                                count++;
                                                if(count==49)
                                                        break;
                                        }


                                }
                                ReadingList.DataSource = dtNew;
                                ReadingList.DataBind();
                        }
                        catch(Exception ex)
                        {
                                Response.Write(ex.Message);
                        }
                        finally
                        {
                                if(dataStream!= null)
                                        dataStream.Close();
                        }

You can take rows and skip rows programatically using LINQ

var d = from c in dt

        select c;

d.Take(48);

Any questions skype me

How can i sort table. when i try to use table.defaultview.sort="", it not work. any help?

To Sort a default view using the sort property you need to specify a field and this defaults to ASC unless you specify DESC

e.g

DefaultView dv = table.DefaultView;

dv.Sort = "FIELD1 DESC";

hi paul,

didn't realize I could use ImportRow() method instead of trying to add a new row in rowcollection )

this sure saves me a heck of frustrations

thx man!

thanks a lot...

it worked!!!

Thanks Paul

Thanks my friend,

It solved my problem.

I was very frustrated for a long time

Thanks again from Costa Rica...

working like a charm !! Thanks a lot man

Thanks for the easy answer bro.

I got the exact same error and your post saved my day! . Thanks a lot!

what about DataTableExtensions..::.CopyToDataTable<(Of <(T>> Method ?

http://msdn.microsoft.com/en-us/library/bb396189.aspx

Awesome job, Paul. You are my new hero.

Your post is still helping developers even though it was posted more than one year ago.

Thanks,

I had the same problem and this solution worked perfectly. It kept me from jumping off the roof of our building. Thanks

Thank you so much for giving me the option to go to bed when it is still dark outside... no doubt, the best post i have ever seen on the net.

I struggled this for all day long. You've helped me save a lot of time! Thanks!

Thanks, this was the first result on google and was exact solution.

Thanks man!!!

dt_tmp.Rows.Add(row.ItemArray);

The above way does not work in C# as far as I know...

Thanks

Thanks so much for taking the time to post this solution

Thanks, Paul. Worked like a charm!

Thanks! It solved my problem!

Hey, Was stuck with this annoying issue for such a long time! Dint know the resolution wud be so simple!

Thanks for the solution.!! Keep up the good work!

thanks alot!! it worked!!!

Great solution thanks!

Thanks it helped me too

Thank you. You are absolutely right about the "columns".

Thanks a Lot Paul

Thanks Paul.. very useful solution

dt2.Rows.Add(dt1.ItemArray) should also work for the above problem.

Thanks a lot for nice solution

Hey Paul, Thanks this solution has solved my problem

Thanks man! Also helped here!

Thanks. This saved me 10 minutes of frustration.

<a href="http://windows-linux-admin.blogspot.com">C# and jQuery tips</a>

The Solution is simple.. Yet Powerful.... Thanks a lot..

Thanks a lot. That saved me a lot of time.

Thank you very much Paul

When I tried to update the table with the newly imported rows to a MS Access database the changes do not show up, do you know off the top of your head what could be some reasons?

Thanks!

great info...keep doing the great work

Thanks once again!!

Thanks Paul, saved me so much time!

Great article, but if anyone is using a List(of DataRow) object to begin with, then the simplest solution is as follows:

Dim lstResults As New List(of DataRow)

'... Code to populate 1...n rows in object above

'Now in single line using Extension method, copy to DataTable

Dim myDataTable As DataTable = lstResults.CopyToDataTable()

Cheers buddy! Worked perfectly

Cheers mate.

thanks

Wonderful!

worked perfectly

I put the error into Google search and this was the first result - it perfectly solved my problem. That happens far too rarely!

This solution was posted in 2006 and is still saving people grief! Thank you!

Thnx!! it is working fine.

Thanks !

Thank you so much !!!

Helped so much. Thanks for posting.

Nice solution

Great help, sorted issue for me as well. Thanks

thank sir it is working fine

Thaks lot Paul.

Thanks Paul, it working fine

Thanks Paul, very helpful

Thank you. A clear explanation and a simple solution. I looked at several reponses to this problem and found the usual - people commenting for the sake of showing how smart they are without providing a solution. One idiot even ignored the fact that the problem was importing a column schema and prattled on about using .ImportRow!!

I am very happy to be part of your life! you're amazing. hehe