CRUD with ADO.NET

[Torben Madsen]

Hello,

I have a C# problem that I hope you could help me with.

I'm making a program where I need data from a database using ADO.NET.

The problem is that I can't figure out how to retrieve the data without
using a datagrid (I presume that a dataset is the correct solution, when I
also need to CRUD (Create-Read-Update-Delete).

I need to use the data in my system instead of displaying it in the GUI, but
I haven't found any examples that could help me.

In other words: I need to read data from a database and storage it in a
arraylist (or whatever) with the possibility to CRUD using ADO.NET.

best regards

Torben

[Diwakar R]

Hi,

I guess what you are looking for is a DataSet. To cut a long story short, a
dataset is an inmemory disconnected data representation.

You could get all your data into a dataset, work with the
datatables,datacolums and datarows in the dataset to do CRUD.

For more info on how to use the Dataset, Pl lookup the reference ( I guess
there is no point in my repeating what is already published :) )

-Diws
"Torben Madsen" <as*****@privat.dk> wrote in message
news:ut**************@TK2MSFTNGP09.phx.gbl...

Hello,

I have a C# problem that I hope you could help me with.

I'm making a program where I need data from a database using ADO.NET.

The problem is that I can't figure out how to retrieve the data without
using a datagrid (I presume that a dataset is the correct solution, when I
also need to CRUD (Create-Read-Update-Delete).

I need to use the data in my system instead of displaying it in the GUI, but I haven't found any examples that could help me.

In other words: I need to read data from a database and storage it in a
arraylist (or whatever) with the possibility to CRUD using ADO.NET.

best regards

Torben

[Bjorn A]

Torben wrote:

The problem is that I can't figure out how to retrieve
the data without using a datagrid (I presume that a
dataset is the correct solution, when I
also need to CRUD (Create-Read-Update-Delete).
Not necessarily, many advocates the use of "disconnected" sets. In that case
you simply read the data, check what you have to do, and make those changes
in another call.
I need to use the data in my system instead of
displaying it in the GUI, but I haven't found
any examples that could help me.

Since you're danish, maybe this compendium can
help you, though it's written in swedish... ;-)

http://www.eki.mdh.se/kurshemsidor/i...endier/DB3.pdf

It doesn't solve your question per se, since it doesn't use connected sets
exactly as you've asked for, but it maybe can give you some hints, and at
least some alternatives.

// Bjorn A

[Torben Madsen]

tusind tak og mange gode guldbajere Bjorn ;o)
-med lidt modifikationer fik jeg det til at virke :o)

(thanks a bunch Bjorn, its worked with some modifications)

best regards
Torben

"Bjorn A" <bj*************@DoNotSpam.hotmail.com> skrev i en meddelelse
news:uQ**************@TK2MSFTNGP10.phx.gbl...

Torben wrote:

The problem is that I can't figure out how to retrieve
the data without using a datagrid (I presume that a
dataset is the correct solution, when I
also need to CRUD (Create-Read-Update-Delete).
Not necessarily, many advocates the use of "disconnected" sets. In that

case you simply read the data, check what you have to do, and make those changes in another call.

I need to use the data in my system instead of
displaying it in the GUI, but I haven't found
any examples that could help me.

Since you're danish, maybe this compendium can
help you, though it's written in swedish... ;-)

http://www.eki.mdh.se/kurshemsidor/i...endier/DB3.pdf

It doesn't solve your question per se, since it doesn't use connected sets
exactly as you've asked for, but it maybe can give you some hints, and at
least some alternatives.

// Bjorn A