i have a table the Includ any row.Names Rows my Table is:ID_ImgPhoto(PK),IDPhoto(FK),Title,Small,Larg,AddedDate,AddedIp,Status.i want read at the DataReader in asp.net and change string the String.replace() many Values Small And Larg row in my table.i want Insert Multiple Rows to table after select and change The Same Values rows.i want select many row With a Condition.My select Code Is:\[code\]ALTER Procedure [dbo].[sp_Tbl_ImagePhotoGraphy_SelectRow] @IDPhoto intAsBegin Select [ID_ImgPhoto], [IDPhoto], [Title], [Small], [Larg], [AddedDate], [AddedIp], [Status] From Tbl_ImagePhotoGraphy Where [IDPhoto] = @IDPhotoEnd\[/code\]i Want changed value many rows after the give Value @IDPhoto And select Many Row my table and FOR EXAMPLE :\[code\] /*OLD DATA*/ID_ImgPhoto IDPhoto Small Larg1 1 OLD/1S.jpg OLD/1L.jpg2 1 OLD/2S.jpg OLD/2L.jpg3 1 OLD/3S.jpg OLD/3L.jpg4 2 Oldsmall/1S.jpg OldLarg/1L.jpg5 2 Oldsmall/1S.jpg OldLarg/1L.jpg5 2 Oldsmall/1S.jpg OldLarg/1L.jpg5 2 Oldsmall/1S.jpg OldLarg/1L.jpg____________________________________________________________________/*NEW DATA Afetr Select And Chnage Rows Value*/ID_ImgPhoto IDPhoto Small Larg1 1 NEW/1S.jpg NEW/1L.jpg2 1 NEW/2S.jpg NEW/2L.jpg3 1 NEW/3S.jpg NEW/3L.jpg4 2 Oldsmall-2/1S.jpg OldLarg-2/1L.jpg5 2 Oldsmall-2/1S.jpg OldLarg-2/1L.jpg5 2 Oldsmall-2/1S.jpg OldLarg-2/1L.jpg5 2 Oldsmall-2/1S.jpg OldLarg-2/1L.jpg\[/code\]
Insert Multiple Rows to table after select and change Values rows
- Thread starter MuMCrymn
- Start date
i have a table the Includ any row.Names Rows my Table is:ID_ImgPhoto(PK),IDPhoto(FK),Title,Small,Larg,AddedDate,AddedIp,Status.i want read at the DataReader in asp.net and change string the String.replace() many Values Small And Larg row in my table.i want Insert Multiple Rows to table after select and change The Same Values rows.i want select many row With a Condition.My select Code Is:\[code\]ALTER Procedure [dbo].[sp_Tbl_ImagePhotoGraphy_SelectRow] @IDPhoto intAsBegin Select [ID_ImgPhoto], [IDPhoto], [Title], [Small], [Larg], [AddedDate], [AddedIp], [Status] From Tbl_ImagePhotoGraphy Where [IDPhoto] = @IDPhotoEnd\[/code\]i Want changed value many rows after the give Value @IDPhoto And select Many Row my table and FOR EXAMPLE :\[code\] /*OLD DATA*/ID_ImgPhoto IDPhoto Small Larg1 1 OLD/1S.jpg OLD/1L.jpg2 1 OLD/2S.jpg OLD/2L.jpg3 1 OLD/3S.jpg OLD/3L.jpg4 2 Oldsmall/1S.jpg OldLarg/1L.jpg5 2 Oldsmall/1S.jpg OldLarg/1L.jpg5 2 Oldsmall/1S.jpg OldLarg/1L.jpg5 2 Oldsmall/1S.jpg OldLarg/1L.jpg____________________________________________________________________/*NEW DATA Afetr Select And Chnage Rows Value*/ID_ImgPhoto IDPhoto Small Larg1 1 NEW/1S.jpg NEW/1L.jpg2 1 NEW/2S.jpg NEW/2L.jpg3 1 NEW/3S.jpg NEW/3L.jpg4 2 Oldsmall-2/1S.jpg OldLarg-2/1L.jpg5 2 Oldsmall-2/1S.jpg OldLarg-2/1L.jpg5 2 Oldsmall-2/1S.jpg OldLarg-2/1L.jpg5 2 Oldsmall-2/1S.jpg OldLarg-2/1L.jpg\[/code\]