I need a solution to modify the data in the row consists of the name and image but sometimes I need to modify the name only with the survival of the same image
sql table
ID | Name | Image
//Insert Item SP
CREATE proc [dbo].[SP_AddNewItem]
@Name nvarchar(50),
@photo image
as
insert into regions(name,photo)
values
(@Name,@photo)
return @@identity
********************************************************
//Update Item SP
CREATE proc [dbo].[SP_UpdateItem]
@Id int,
@Name nvarchar(50),
@photo image,
as
update regions
set
Name=@Name,
photo=@photo,
where
ID=@id
and i'm using asp controls to insert date like
textBox and FileUpload to insert an image
and when retrive date it retrived in gridview
and when click update button and update name in textbox and save data i'm going to database and i don' find the image in updated row
What is the solution?
Thank you very much
Marwan Alshemy