multiple update

[sood_is_in]

how can i perform multiple update in one trip to the server love you all

[Colin Angus Mackay]

Put multiple statements in the SqlCommand. For example:

INSERT INTO MyTable(a,b,c) VALUES (@a1, @b1, @c1);
INSERT INTO MyTable(a,b,c) VALUES(@a2, @b2, @c2);

Just separate the statements with a semi-colon. ColinMackay.net "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius "If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell -- modified at 8:03 Tuesday 17th January, 2006