----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Arabinda_dotnet Message 3 in Discussion Hi, If you are using 2.0 framework you can try for bulk update feature else you can do it by passing the xml to the SP and using the xml in the stored procedure to do bulk insert. hope this will help. rgds, Arabinda >From: "BDOTNET" <[email protected]> >Reply-To: "BDOTNET" <[email protected]> >To: "BDOTNET" <[email protected]> >Subject: Update multi-columns using SP >Date: Wed, 22 Mar 2006 16:58:37 -0800 > > > > > > > > > > > > > New Message on BDOTNET > > > > > > > > Update multi-columns using SP > > > > > Reply > > > > > Recommend > > Message 1 in Discussion > > > > > > > > From: > PraveenReddy > > > > > Hi there, I would like to know how to update multi-column >data using stored procedure. Table example: Table1: Emp fieldname, type >EmpID, int EmpName, nvarchar Tagsid, int Table2: Tags Fieldname, type >Tagsid, int Tagname, nvarchar Table3: SelectedTags Fieldname, type >STagsID, int EmpID, int Tagsid, int Now, the issue is the employee, can >select multiple tags, however, in the code, how am i supposed to pass the >same info to SP, so that i can update emp details, and mulit-tag details in >selectedtags table. Note: Tags table is master table Regards, Praveen > > > > > > > View other groups in this category. > > > > > > > > > > > > > >Also on MSN: >Start Chatting | Listen to Music | House & Home | Try Online Dating | Daily >Horoscopes > > > > > > > > > > > To stop getting this e-mail, or change how often it >arrives, go to your E-mail Settings. > > > Need help? If you've forgotten your password, > please go >to Passport Member Services. > > For other questions or feedback, go to our > Contact Us >page. > > > 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. > > > Remove my e-mail address from BDOTNET. > > > > > > > _________________________________________________________________ One and only Ash. Find out all about her. Only on MSN Search http://server1.msn.co.in/profile/aishwarya.asp ----------------------------------------------------------- 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]
