Get column value

**Cor Ligthert [MVP]** · Apr 16 '07, 12:05 AM

Re: Get column value

Vovan,

I cannot find a nice sample at the moment, however you need the datarowstate
to get the changed rows per table in a copy of your dataset

Those you update to your database in the sequence
childs deleted
parents deleted
parents added
childs added
parents updated
childs updated

However you use for that the dataadapter and not the executenonquery as I
get the idea you want to do.

If everything goes right than you have to do an acceptchanges at the end.

Quickly written in this messages so watch typos or whatever.

Cor

"vovan" <someone@vovan. comschreef in bericht
news:eThkkN7fHH A.588@TK2MSFTNG P06.phx.gbl...

I'm creating DataSet, then 2 DataTables, then DataRelation between those
DataTables.
I populate DataTables with DataAdapters. Data from each table is displayed
in Grids.
For display everything works fine - if I change the current record in the
Parent grid then the Child grid displays records related to the Parent.
In order to update any record in both Parent and Child underlying
datasources (SQL Server tables) I need to know ID of the record.
What is the proper way to get an ID (it exists in the DataTable, in
BindingSource)? I just do not know how to get it? The only way I found (I
don't like it) is to bind ID field to TextBox control and then when I need
ID I get it from the bound TextBox.
>
Thank you
vovan
>
>
>

**vovan** · Apr 16 '07, 12:15 AM

Re: Get column value

Thank you Cor
First of all, I need to use ExecuteNoneQuer y because I'm working on upgrade
of VB6 application which uses tons of existing Stored Procedures and I was
thinking that using existing SPs will decrease the time of developing.
The second reason is I couldn't find any sample which uses your approach and
SPs at the same time. Everything I found so far with Update/Insert/Delete
operations was with SQL codes in the body of the program with some question
marks in the bodies of statements. Unfortunately I couldn't understand those
codes.

vovan

"Cor Ligthert [MVP]" <notmyfirstname @planet.nlwrote in message
news:OEPJJn7fHH A.4692@TK2MSFTN GP03.phx.gbl...

Vovan,
>
I cannot find a nice sample at the moment, however you need the
datarowstate to get the changed rows per table in a copy of your dataset
>
Those you update to your database in the sequence
childs deleted
parents deleted
parents added
childs added
parents updated
childs updated
>
However you use for that the dataadapter and not the executenonquery as I
get the idea you want to do.
>
If everything goes right than you have to do an acceptchanges at the end.
>
Quickly written in this messages so watch typos or whatever.
>
Cor
>
>
>
>
"vovan" <someone@vovan. comschreef in bericht
news:eThkkN7fHH A.588@TK2MSFTNG P06.phx.gbl...

>I'm creating DataSet, then 2 DataTables, then DataRelation between those
>DataTables.
>I populate DataTables with DataAdapters. Data from each table is
>displayed in Grids.
>For display everything works fine - if I change the current record in the
>Parent grid then the Child grid displays records related to the Parent.
>In order to update any record in both Parent and Child underlying
>datasources (SQL Server tables) I need to know ID of the record.
>What is the proper way to get an ID (it exists in the DataTable, in
>BindingSource) ? I just do not know how to get it? The only way I found (I
>don't like it) is to bind ID field to TextBox control and then when I
>need ID I get it from the bound TextBox.
>>
>Thank you
>vovan
>>
>>
>>

>
>

**Cor Ligthert [MVP]** · Apr 16 '07, 10:55 AM

Re: Get column value

Vovan,

It is almost impossible to show samples with stored procedures.

However an text procedure is good written nowhere different from a stored
procedure while such a procedure is just by copy and paste to bring to a
stored procedure and than the only thing that has be changed is the adding
of the property

http://msdn2.microsoft.com/en-us/lib...pe(vs.80).aspx

Cor

"vovan" <someone@vovan. comschreef in bericht
news:O9ub8u7fHH A.4596@TK2MSFTN GP05.phx.gbl...

Thank you Cor
First of all, I need to use ExecuteNoneQuer y because I'm working on
upgrade of VB6 application which uses tons of existing Stored Procedures
and I was thinking that using existing SPs will decrease the time of
developing.
The second reason is I couldn't find any sample which uses your approach
and SPs at the same time. Everything I found so far with
Update/Insert/Delete operations was with SQL codes in the body of the
program with some question marks in the bodies of statements.
Unfortunately I couldn't understand those codes.
>
vovan
>
"Cor Ligthert [MVP]" <notmyfirstname @planet.nlwrote in message
news:OEPJJn7fHH A.4692@TK2MSFTN GP03.phx.gbl...

>Vovan,
>>
>I cannot find a nice sample at the moment, however you need the
>datarowstate to get the changed rows per table in a copy of your dataset
>>
>Those you update to your database in the sequence
>childs deleted
>parents deleted
>parents added
>childs added
>parents updated
>childs updated
>>
>However you use for that the dataadapter and not the executenonquery as I
>get the idea you want to do.
>>
>If everything goes right than you have to do an acceptchanges at the end.
>>
>Quickly written in this messages so watch typos or whatever.
>>
>Cor
>>
>>
>>
>>
>"vovan" <someone@vovan. comschreef in bericht
>news:eThkkN7fH HA.588@TK2MSFTN GP06.phx.gbl...

>>I'm creating DataSet, then 2 DataTables, then DataRelation between
>>those DataTables.
>>I populate DataTables with DataAdapters. Data from each table is
>>displayed in Grids.
>>For display everything works fine - if I change the current record in
>>the Parent grid then the Child grid displays records related to the
>>Parent.
>>In order to update any record in both Parent and Child underlying
>>datasources (SQL Server tables) I need to know ID of the record.
>>What is the proper way to get an ID (it exists in the DataTable, in
>>BindingSource )? I just do not know how to get it? The only way I found
>>(I don't like it) is to bind ID field to TextBox control and then when I
>>need ID I get it from the bound TextBox.
>>>
>>Thank you
>>vovan
>>>
>>>
>>>

>>
>>

>
>

**vovan** · Apr 16 '07, 01:05 PM

Re: Get column value

As I know from my VB6/SQL Server experience there is a huge difference in
performance between SPs and build in code.
The same body of some procedures and the code imbedded into VB application.
The time of execution for an SP is a portion of a second, the code from VB
takes 10 seconds. It's due to the need to compile the embedded code first.
SP is already compiled.
Maybe it works differently with VB2005? I don't know.

vovan

"Cor Ligthert [MVP]" <notmyfirstname @planet.nlwrote in message
news:%23GMjORBg HHA.2396@TK2MSF TNGP04.phx.gbl. ..

Vovan,
>
It is almost impossible to show samples with stored procedures.
>
However an text procedure is good written nowhere different from a stored
procedure while such a procedure is just by copy and paste to bring to a
stored procedure and than the only thing that has be changed is the adding
of the property
>
http://msdn2.microsoft.com/en-us/lib...pe(vs.80).aspx
>
Cor
>
"vovan" <someone@vovan. comschreef in bericht
news:O9ub8u7fHH A.4596@TK2MSFTN GP05.phx.gbl...

>Thank you Cor
>First of all, I need to use ExecuteNoneQuer y because I'm working on
>upgrade of VB6 application which uses tons of existing Stored Procedures
>and I was thinking that using existing SPs will decrease the time of
>developing.
>The second reason is I couldn't find any sample which uses your approach
>and SPs at the same time. Everything I found so far with
>Update/Insert/Delete operations was with SQL codes in the body of the
>program with some question marks in the bodies of statements.
>Unfortunatel y I couldn't understand those codes.
>>
>vovan
>>
>"Cor Ligthert [MVP]" <notmyfirstname @planet.nlwrote in message
>news:OEPJJn7fH HA.4692@TK2MSFT NGP03.phx.gbl.. .

>>Vovan,
>>>
>>I cannot find a nice sample at the moment, however you need the
>>datarowstat e to get the changed rows per table in a copy of your dataset
>>>
>>Those you update to your database in the sequence
>>childs deleted
>>parents deleted
>>parents added
>>childs added
>>parents updated
>>childs updated
>>>
>>However you use for that the dataadapter and not the executenonquery as
>>I get the idea you want to do.
>>>
>>If everything goes right than you have to do an acceptchanges at the
>>end.
>>>
>>Quickly written in this messages so watch typos or whatever.
>>>
>>Cor
>>>
>>>
>>>
>>>
>>"vovan" <someone@vovan. comschreef in bericht
>>news:eThkkN7f HHA.588@TK2MSFT NGP06.phx.gbl.. .
>>>I'm creating DataSet, then 2 DataTables, then DataRelation between
>>>those DataTables.
>>>I populate DataTables with DataAdapters. Data from each table is
>>>displayed in Grids.
>>>For display everything works fine - if I change the current record in
>>>the Parent grid then the Child grid displays records related to the
>>>Parent.
>>>In order to update any record in both Parent and Child underlying
>>>datasource s (SQL Server tables) I need to know ID of the record.
>>>What is the proper way to get an ID (it exists in the DataTable, in
>>>BindingSourc e)? I just do not know how to get it? The only way I found
>>>(I don't like it) is to bind ID field to TextBox control and then when
>>>I need ID I get it from the bound TextBox.
>>>>
>>>Thank you
>>>vovan
>>>>
>>>>
>>>>
>>>
>>>

>>
>>

>
>

**Cor Ligthert [MVP]** · Apr 16 '07, 05:05 PM

Re: Get column value

Vovan,

There is only one SQL database server that uses compiled procedures. That is
the IBM DB2. Neither Oracle, Microsoft of whatever other does that (quoting
Frans Bouma for the non Microsoft versions).

SP's have in common a slightly better performance because that they don't
have to be loaded everytime, but don't think than in seconds, just parts of
seconds.

There are some advantages for the SP but that is for the oposite as well.
However, in common it are fairly tails.

Cor

"vovan" <someone@vovan. comschreef in bericht
news:uzbSwcCgHH A.3412@TK2MSFTN GP02.phx.gbl...

As I know from my VB6/SQL Server experience there is a huge difference in
performance between SPs and build in code.
The same body of some procedures and the code imbedded into VB
application. The time of execution for an SP is a portion of a second, the
code from VB takes 10 seconds. It's due to the need to compile the
embedded code first. SP is already compiled.
Maybe it works differently with VB2005? I don't know.
>
vovan
>
"Cor Ligthert [MVP]" <notmyfirstname @planet.nlwrote in message
news:%23GMjORBg HHA.2396@TK2MSF TNGP04.phx.gbl. ..

>Vovan,
>>
>It is almost impossible to show samples with stored procedures.
>>
>However an text procedure is good written nowhere different from a stored
>procedure while such a procedure is just by copy and paste to bring to a
>stored procedure and than the only thing that has be changed is the
>adding of the property
>>
>http://msdn2.microsoft.com/en-us/lib...pe(vs.80).aspx
>>
>Cor
>>
>"vovan" <someone@vovan. comschreef in bericht
>news:O9ub8u7fH HA.4596@TK2MSFT NGP05.phx.gbl.. .

>>Thank you Cor
>>First of all, I need to use ExecuteNoneQuer y because I'm working on
>>upgrade of VB6 application which uses tons of existing Stored Procedures
>>and I was thinking that using existing SPs will decrease the time of
>>developing.
>>The second reason is I couldn't find any sample which uses your approach
>>and SPs at the same time. Everything I found so far with
>>Update/Insert/Delete operations was with SQL codes in the body of the
>>program with some question marks in the bodies of statements.
>>Unfortunate ly I couldn't understand those codes.
>>>
>>vovan
>>>
>>"Cor Ligthert [MVP]" <notmyfirstname @planet.nlwrote in message
>>news:OEPJJn7f HHA.4692@TK2MSF TNGP03.phx.gbl. ..
>>>Vovan,
>>>>
>>>I cannot find a nice sample at the moment, however you need the
>>>datarowsta te to get the changed rows per table in a copy of your
>>>dataset
>>>>
>>>Those you update to your database in the sequence
>>>childs deleted
>>>parents deleted
>>>parents added
>>>childs added
>>>parents updated
>>>childs updated
>>>>
>>>However you use for that the dataadapter and not the executenonquery as
>>>I get the idea you want to do.
>>>>
>>>If everything goes right than you have to do an acceptchanges at the
>>>end.
>>>>
>>>Quickly written in this messages so watch typos or whatever.
>>>>
>>>Cor
>>>>
>>>>
>>>>
>>>>
>>>"vovan" <someone@vovan. comschreef in bericht
>>>news:eThkkN7 fHHA.588@TK2MSF TNGP06.phx.gbl. ..
>>>>I'm creating DataSet, then 2 DataTables, then DataRelation between
>>>>those DataTables.
>>>>I populate DataTables with DataAdapters. Data from each table is
>>>>displayed in Grids.
>>>>For display everything works fine - if I change the current record in
>>>>the Parent grid then the Child grid displays records related to the
>>>>Parent.
>>>>In order to update any record in both Parent and Child underlying
>>>>datasourc es (SQL Server tables) I need to know ID of the record.
>>>>What is the proper way to get an ID (it exists in the DataTable, in
>>>>BindingSour ce)? I just do not know how to get it? The only way I found
>>>>(I don't like it) is to bind ID field to TextBox control and then when
>>>>I need ID I get it from the bound TextBox.
>>>>>
>>>>Thank you
>>>>vovan
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>

>>
>>

>
>

**vovan** · Apr 16 '07, 08:15 PM

Re: Get column value

I don't know, Cor.
I'm telling you what I met. Initially my application was written to work
with Access. Later Access was upgraded to SQL Server. No SPs were used right
after that. In a couple of years some screens begun to work pretty slow.
Using Debug.Print Now I found all buttle necks, I mean places in the code
where the application spends a significant time. Most of them were
populating recordsets via embedded SQL statements.
I was surprized with the result when I replaced the most slow part with SP.
Although I did not change statements logic (often I just moved the code into
the body of SP, added parameters etc), the speed encreased dramatically.
Maybe in theory SQL Server doesn't compile SP. But the result of using SPs
doesn't make me go back to embedded code.

vovan

"Cor Ligthert [MVP]" <notmyfirstname @planet.nlwrote in message
news:%23nxjUjEg HHA.1244@TK2MSF TNGP04.phx.gbl. ..

Vovan,
>
There is only one SQL database server that uses compiled procedures. That
is the IBM DB2. Neither Oracle, Microsoft of whatever other does that
(quoting Frans Bouma for the non Microsoft versions).
>
SP's have in common a slightly better performance because that they don't
have to be loaded everytime, but don't think than in seconds, just parts
of seconds.
>
There are some advantages for the SP but that is for the oposite as well.
However, in common it are fairly tails.
>
Cor
>
"vovan" <someone@vovan. comschreef in bericht
news:uzbSwcCgHH A.3412@TK2MSFTN GP02.phx.gbl...

>As I know from my VB6/SQL Server experience there is a huge difference in
>performance between SPs and build in code.
>The same body of some procedures and the code imbedded into VB
>application. The time of execution for an SP is a portion of a second,
>the code from VB takes 10 seconds. It's due to the need to compile the
>embedded code first. SP is already compiled.
>Maybe it works differently with VB2005? I don't know.
>>
>vovan
>>
>"Cor Ligthert [MVP]" <notmyfirstname @planet.nlwrote in message
>news:%23GMjORB gHHA.2396@TK2MS FTNGP04.phx.gbl ...

>>Vovan,
>>>
>>It is almost impossible to show samples with stored procedures.
>>>
>>However an text procedure is good written nowhere different from a
>>stored procedure while such a procedure is just by copy and paste to
>>bring to a stored procedure and than the only thing that has be changed
>>is the adding of the property
>>>
>>http://msdn2.microsoft.com/en-us/lib...pe(vs.80).aspx
>>>
>>Cor
>>>
>>"vovan" <someone@vovan. comschreef in bericht
>>news:O9ub8u7f HHA.4596@TK2MSF TNGP05.phx.gbl. ..
>>>Thank you Cor
>>>First of all, I need to use ExecuteNoneQuer y because I'm working on
>>>upgrade of VB6 application which uses tons of existing Stored
>>>Procedures and I was thinking that using existing SPs will decrease the
>>>time of developing.
>>>The second reason is I couldn't find any sample which uses your
>>>approach and SPs at the same time. Everything I found so far with
>>>Update/Insert/Delete operations was with SQL codes in the body of the
>>>program with some question marks in the bodies of statements.
>>>Unfortunatel y I couldn't understand those codes.
>>>>
>>>vovan
>>>>
>>>"Cor Ligthert [MVP]" <notmyfirstname @planet.nlwrote in message
>>>news:OEPJJn7 fHHA.4692@TK2MS FTNGP03.phx.gbl ...
>>>>Vovan,
>>>>>
>>>>I cannot find a nice sample at the moment, however you need the
>>>>datarowstat e to get the changed rows per table in a copy of your
>>>>dataset
>>>>>
>>>>Those you update to your database in the sequence
>>>>childs deleted
>>>>parents deleted
>>>>parents added
>>>>childs added
>>>>parents updated
>>>>childs updated
>>>>>
>>>>However you use for that the dataadapter and not the executenonquery
>>>>as I get the idea you want to do.
>>>>>
>>>>If everything goes right than you have to do an acceptchanges at the
>>>>end.
>>>>>
>>>>Quickly written in this messages so watch typos or whatever.
>>>>>
>>>>Cor
>>>>>
>>>>>
>>>>>
>>>>>
>>>>"vovan" <someone@vovan. comschreef in bericht
>>>>news:eThkkN 7fHHA.588@TK2MS FTNGP06.phx.gbl ...
>>>>>I'm creating DataSet, then 2 DataTables, then DataRelation between
>>>>>those DataTables.
>>>>>I populate DataTables with DataAdapters. Data from each table is
>>>>>displaye d in Grids.
>>>>>For display everything works fine - if I change the current record in
>>>>>the Parent grid then the Child grid displays records related to the
>>>>>Parent.
>>>>>In order to update any record in both Parent and Child underlying
>>>>>datasource s (SQL Server tables) I need to know ID of the record.
>>>>>What is the proper way to get an ID (it exists in the DataTable, in
>>>>>BindingSou rce)? I just do not know how to get it? The only way I
>>>>>found (I don't like it) is to bind ID field to TextBox control and
>>>>>then when I need ID I get it from the bound TextBox.
>>>>>>
>>>>>Thank you
>>>>>vovan
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>

>>
>>

>
>

**RobinS** · Apr 17 '07, 07:15 AM

Re: Get column value

Are you talking about identity columns? You have identity columns in your
parent table, and it is stored in the child table as well? How are you
doing your updates? Are you updating the parent first, and then the child
table? Do you have cascading changes turned on from the parent to the
child?

Robin S.
--------------------
"vovan" <someone@vovan. comwrote in message
news:eThkkN7fHH A.588@TK2MSFTNG P06.phx.gbl...

I'm creating DataSet, then 2 DataTables, then DataRelation between those
DataTables.
I populate DataTables with DataAdapters. Data from each table is
displayed in Grids.
For display everything works fine - if I change the current record in the
Parent grid then the Child grid displays records related to the Parent.
In order to update any record in both Parent and Child underlying
datasources (SQL Server tables) I need to know ID of the record.
What is the proper way to get an ID (it exists in the DataTable, in
BindingSource)? I just do not know how to get it? The only way I found (I
don't like it) is to bind ID field to TextBox control and then when I
need ID I get it from the bound TextBox.
>
Thank you
vovan
>
>
>

Get column value

Get column value

Comment

Comment

Comment

Comment

Comment

Comment

Comment