how i can insert more than one rows into more than one tables?? ( in one mehtod ) when user click 'Send Message Button'
hi all , i want to know how i can insert many rows into many tables in one method , such as the following Scenario :
1 - if u want to send compose message to more than one Receiver , u select more than receiver( Receiver table) , and attach more than Files ( File Table) ...... etc , in one method .
how ?? any example? plz im new programmer
Kirtan PatelPosted Aug 8, 2009, 4:37 PM
in Array or generic collection like List
in Most of code i have explained what the code does but if you still not get you are welcome to ask Question :)
abas shahenPosted Aug 8, 2009, 5:00 PM
Kirtan PatelPosted Aug 8, 2009, 4:55 PM
It depends on situation what to use From DataReader , Dataset
Data Reader just Goes into One Direction when iterating through record and need Database Connection Open when Performing Operation while data set has several advantages over data reader like
it can move in both direction in records Forward and backward and no need Database Connection once after data set is filled
But When you have to do small task like no more operation that can round trip the Database you can use DataReader
But When Performing Search on Database You should avoid using DataReaders
Thank you :)
abas shahenPosted Aug 8, 2009, 4:45 PM