Re: bulk update in the database

Abhishake wrote:
hi All,
I have a table 'TableA' with columns suppose A,B,C,D,E,F,G,H. and
columns J,I,K,L are created at the runtime through a stored
procedure.

What database type and version?

Columns A,B,C,D are composite keys ,E,F,G, have data and columns
J,I,K,L are calculated on bases of columns E,F,G.eg J=E+F , I = (E-F)
*G and so on
I have created a dataset 'dsBlank' with columns A,B,C,D,J,I,K,L

"dataset"? Are you using ado.net? If so:
There was no way for you to know it (except maybe by browsing through some
of the previous questions in this newsgroup before posting yours - always a
recommended practice) , but this is a classic ADO newsgroup. ADO.Net bears
very little resemblance to classic ADO so, while you may be lucky enough to
find a dotnet-knowledgeable person here who can answer your question, you
can eliminate the luck factor by posting your question to a group where
those dotnet-knowledgeable people hang out. I suggest
microsoft.public.dotnet.framework.adonet.


which have the no values in J,I,K,L but the value exist in A,B,C,D.
I filled another dataset 'dsfilled ' with columns A,B,C,D,J,I,K,L
from the table 'TableA' using the following query " select A,B,C,D
,E+F as J, (E-F) *G as I from table TableA". The above query is not
the exact one which I have written but instead I have given all the
definition to the columns (J,I,K,L)

Now here is my question to all

How can I update the values from dataset 'dsfilled' into the table
TableA' of database
NOTE: - numbers of rows are too much so I want a method of bulk
insert and no single row updation.

Probably not. You will need to write the update statements and batch them.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Loading