Is there anyway to add rows to a dataset/datatable without having to
populate the object with rows from the source table????

It seems to be pretty daunting in terms of memory/processing
requirements to have to fill the dataset with all rows from a source
and then make additions.

No, you don't need to fill it beforhand.
What makes you think you have to fill it before adding new rows?

-- 
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"maz"  wrote in message 
news:1186638980.793722.78650@l70g2000hse.googlegroups.com...

> Is there anyway to add rows to a dataset/datatable without having to
> populate the object with rows from the source table????
>
> It seems to be pretty daunting in terms of memory/processing
> requirements to have to fill the dataset with all rows from a source
> and then make additions.
> 

On Aug 9, 11:15 am, "Miha Markic" <miha at rthand com> wrote:

> No, you don't need to fill it beforhand.
> What makes you think you have to fill it before adding new rows?
>
> --
> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
> RightHand .NET consulting & developmentwww.rthand.com
> Blog:http://cs.rthand.com/blogs/blog_with_righthand/
>
> "maz"  wrote in message
>
> news:1186638980.793722.78650@l70g2000hse.googlegroups.com...
>
>
>
> > Is there anyway to add rows to a dataset/datatable without having to
> > populate the object with rows from the source table????
>
> > It seems to be pretty daunting in terms of memory/processing
> > requirements to have to fill the dataset with all rows from a source
> > and then make additions.- Hide quoted text -
>
> - Show quoted text -


The examples given in a text I have called the fill method. That's
what made me think so, which I found to be extremely unreasonable!

Note that the table I want to add rows to already has existing rows.

if u have references to web resources that may help please provide
them.

Thanks

You can do a schema-only query or construct the DataTable in code and 
populated it as needed.

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"maz"  wrote in message 
news:1186649855.698371.308040@l70g2000hse.googlegroups.com...

> On Aug 9, 11:15 am, "Miha Markic" <miha at rthand com> wrote:
>> No, you don't need to fill it beforhand.
>> What makes you think you have to fill it before adding new rows?
>>
>> --
>> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
>> RightHand .NET consulting & developmentwww.rthand.com
>> Blog:http://cs.rthand.com/blogs/blog_with_righthand/
>>
>> "maz"  wrote in message
>>
>> news:1186638980.793722.78650@l70g2000hse.googlegroups.com...
>>
>>
>>
>> > Is there anyway to add rows to a dataset/datatable without having to
>> > populate the object with rows from the source table????
>>
>> > It seems to be pretty daunting in terms of memory/processing
>> > requirements to have to fill the dataset with all rows from a source
>> > and then make additions.- Hide quoted text -
>>
>> - Show quoted text -
>
> The examples given in a text I have called the fill method. That's
> what made me think so, which I found to be extremely unreasonable!
>
> Note that the table I want to add rows to already has existing rows.
>
> if u have references to web resources that may help please provide
> them.
>
> Thanks
>