Best practice

[Willian Lopes]

Hi everybody.
I´m starting with C# and .NET. So, I have some difficulties with some codes.
I´m already a programmer and I´m migrating from Delphi to C#. My questions
are:

1) Into a form I´ve made my connection string and my SqlConnection variable.
Now, I want use this connection to insert data from the form into table and,
of course, get some data from a table for a search. My doubt is that to much
people adviced me to don´t use DataSets ´cause they´re slow and get to much
system´s memory. So, how do I retrieve and insert this data without
DataSets? I read a lof ot tutorials but each of show a differente manner and
opinion.

2) Is there a manner to use dataBingding without DataSet?

Thanks for help!

Willian Lopes

 

[Arne Vajhøj]

I´m starting with C# and .NET. So, I have some difficulties with some
codes. I´m already a programmer and I´m migrating from Delphi to C#. My
questions are:

1) Into a form I´ve made my connection string and my SqlConnection
variable. Now, I want use this connection to insert data from the form
into table and, of course, get some data from a table for a search. My
doubt is that to much people adviced me to don´t use DataSets ´cause
they´re slow and get to much system´s memory. So, how do I retrieve and
insert this data without DataSets? I read a lof ot tutorials but each of
show a differente manner and opinion.

There are arguments against DataSet's (as well as arguments for), but
performance is not a good argument. If the data is small enough to be
displayed, then it is small enough to be in a DataSet.

There is a huge world of custom collections, O/R mappers, LINQ for SQL
etc..

But if you are starting learning C#, then I can really not
see any reason why you could not start using DataSet.

2) Is there a manner to use dataBingding without DataSet?

Yes.

Arne