db update

[Brian]

hi,
I get my app connecting to a sql2005 database and can query the table and
display as i wish.. one record at a time. now, I want the user to be able
to delete or modify whatever record they are on. I am still learning this
and i am using the gui xsd to create my connection and adapter and dataset.
I am really strugling with how i can use this gui to do the update() or
delete or add. how can I do this using the gui tool? I figured if i could
use the tool and then see how MS does it.. i could get some insight on the
inner workings before venturing out to write my own classes....

[Cor Ligthert[MVP]]

Re: db update

Brian,

Don't make it yourself to difficult.

All modern databases are build around tables, which contains rows, which
cointains items.
The tables can have relations to each other but never more then one to many
or one to one.

In one to many the first is called the parent.

That is it.

Cor

"Brian" <LandLord323@gm ail.comschreef in bericht
news:17udnf35_v zGBSTVnZ2dnUVZ_ tHinZ2d@insight bb.com...

hi,
I get my app connecting to a sql2005 database and can query the table and
display as i wish.. one record at a time. now, I want the user to be able
to delete or modify whatever record they are on. I am still learning this
and i am using the gui xsd to create my connection and adapter and
dataset.
I am really strugling with how i can use this gui to do the update() or
delete or add. how can I do this using the gui tool? I figured if i
could use the tool and then see how MS does it.. i could get some insight
on the inner workings before venturing out to write my own classes....
>
>
>

[Brian]

Re: db update

Well, I struggled with this and followed through all the "Wizard" code. for
some reason the updatecommand was never being ran, even though it was being
called.
I ended up scarping my databinding souce, dataset and dataadapter and
starting over. This time it was simple. I am not sure what steps i had
taken to mess it up, but as soon as I learn more, I'll do the same thing
that I did in vb6, dump the wizards.....
Thanks for the help though...

"Cor Ligthert[MVP]" <notmyfirstname @planet.nlwrote in message
news:DB08DDC4-6E59-4E0E-9C7A-A268EAF6C5E8@mi crosoft.com...

Brian,
>
Don't make it yourself to difficult.
>
All modern databases are build around tables, which contains rows, which
cointains items.
The tables can have relations to each other but never more then one to
many or one to one.
>
In one to many the first is called the parent.
>
That is it.
>
Cor
>
"Brian" <LandLord323@gm ail.comschreef in bericht
news:17udnf35_v zGBSTVnZ2dnUVZ_ tHinZ2d@insight bb.com...

>hi,
>I get my app connecting to a sql2005 database and can query the table and
>display as i wish.. one record at a time. now, I want the user to be
>able to delete or modify whatever record they are on. I am still
>learning this and i am using the gui xsd to create my connection and
>adapter and dataset.
>I am really strugling with how i can use this gui to do the update() or
>delete or add. how can I do this using the gui tool? I figured if i
>could use the tool and then see how MS does it.. i could get some insight
>on the inner workings before venturing out to write my own classes....
>>
>>
>>

>

[Cor Ligthert[MVP]]

Re: db update

Brian,

You did it in my idea with the classic wizards in the most important way
they should be used. "To learn".

(This statements however is not for all modern wizards as Linq to SQL and
those for creating screans which are not even seen as wizards anymore)

Cor

"Brian" <bsgallatin@com munity.nospamsc hreef in bericht
news:eWJvaLKDJH A.3392@TK2MSFTN GP03.phx.gbl...

Well, I struggled with this and followed through all the "Wizard" code.
for some reason the updatecommand was never being ran, even though it was
being called.
I ended up scarping my databinding souce, dataset and dataadapter and
starting over. This time it was simple. I am not sure what steps i had
taken to mess it up, but as soon as I learn more, I'll do the same thing
that I did in vb6, dump the wizards.....
Thanks for the help though...
>
"Cor Ligthert[MVP]" <notmyfirstname @planet.nlwrote in message
news:DB08DDC4-6E59-4E0E-9C7A-A268EAF6C5E8@mi crosoft.com...

>Brian,
>>
>Don't make it yourself to difficult.
>>
>All modern databases are build around tables, which contains rows, which
>cointains items.
>The tables can have relations to each other but never more then one to
>many or one to one.
>>
>In one to many the first is called the parent.
>>
>That is it.
>>
>Cor
>>
>"Brian" <LandLord323@gm ail.comschreef in bericht
>news:17udnf35_ vzGBSTVnZ2dnUVZ _tHinZ2d@insigh tbb.com...

>>hi,
>>I get my app connecting to a sql2005 database and can query the table
>>and display as i wish.. one record at a time. now, I want the user to
>>be able to delete or modify whatever record they are on. I am still
>>learning this and i am using the gui xsd to create my connection and
>>adapter and dataset.
>>I am really strugling with how i can use this gui to do the update() or
>>delete or add. how can I do this using the gui tool? I figured if i
>>could use the tool and then see how MS does it.. i could get some
>>insight on the inner workings before venturing out to write my own
>>classes....
>>>
>>>
>>>

>>

>
>