[dba-VB] Updating dataset from datagrid

Thanks to all who replied.

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Friday, May 30, 2008 10:01 AM
To: dba-vb at databaseadvisors.com
Subject: Re: [dba-VB] Updating dataset from datagrid

Hi Eric and Shamil

I located the links Shamil posted in January:

<quote>
You can start here with ASP.NET:

http://www.asp.net/get-started/
http://quickstarts.asp.net/QuickStartv20/aspnet/Default.aspx
http://www.asp.net/learn/
http://www.asp.net/learn/data-access/
</quote>

The last does a good job explaning data access using DataTable and DAL.

/gustav

>>> shamil at smsconsulting.spb.ru 30-05-2008 14:45 >>>
Hi Gustav,

<<<
So go for option 3. (!)
>>>
What is option 3?

--
Shamil 

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Friday, May 30, 2008 11:21 AM
To: dba-vb at databaseadvisors.com
Subject: Re: [dba-VB] Updating dataset from datagrid

Hi Eric

> What I don't like about the approach in Option 1 is that you have to
hard-code the SELECT statement 

I think all this SQLAdapter and SQLCommand mechanics are left-overs from old
.Net and ASP. 
MS has done a tremendous work with the DataTable, DataTableAdapter, DAL
(Data Access Layer), and LINQ.

Shamil has posted several links for tutorials and I can highly recommend
looking these up.

Problem is, that if you google for code on various topics, the net is
flooded with old SqlThisAndThat quick-and-dirty code from ASP kiddies which
won't help you in the long run.

So go for option 3. (!)

/gustav



_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com