-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: shiva_prakash_k
Message 2 in Discussion
To store at the same time on one shot u can use stored procedure at the backend
side and also u can use the c# coding well.
At the backend :
It needs three stored procedures. Send all the information which is
needed to insert into the user table and address table and student table. For
first use, storedprocedure1 and send all the information and within that
storedprocedure1 insert the informations into the address table first with
neccessary informations and there u generate the id by u r self using newID( )
function in the stored procedure. then at the second step call another
storedprocedure named storedprocedure2 which inserts the informations into User
table. Along with the parameters u send the id generated by u. Within that
storedprocedure2 call storedprocedure3 by passing userid and addressid that
will insert the information into the student informaions.
We can do in single procedure bur from many experts i heard that we
should not insert the data into multiple tables within a single
storedprocedure. So at the back end u try this if u feel tough then go for
others answers.
At the C# coding :
Here also u need the three stored procedure. Generate the id's by u r self
at the storedprocedure. Instead of calling send the id back to the c# and using
that id call another storedprocedure and do the same thing.
This is my way if any thing wrong then please suggest me.
With Regards
K Shiva Prakash
Zealous Solutions Pvt Ltd.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDOTNET/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
