How to upload four file names in single column and with same ID in Sqlserver database

Question

Hi Friends Im trying to upload a four files names in database.But we have to use only one column in database Requirement : we have to take four upload controls in aspx page.when we click on submit buttonthe four file names should save in single column Please help me on this requirement

Santhosh Kumar Jayaraman · Answer

get all filenames into single string and pass to stored proc.. Inside stored proc try the same logic declare @str varchar(100) set @str='pw.jpeg;ex.jpeg;kk.doc' --select @str select CHARINDEX(';'@str0) While(CHARINDEX(';'@str0) !=0) BEGIn insert into SchoolClass values(5SUBSTRING(@str0charindex(';'@str0))) select @str=SUBSTRING(@strcharindex(';'@str0)+1LEN(@str)-1) print @str END insert into SchoolClass values(5@str) select * from schoolclass My table is schoolclass and columns are Id and name

KRayudu V · Answer

ya we can do like that. Butthe file names should save(DATABASE) in this way MaterialOne ID kumar.jpg 101 santosh.jpg 101 rayud.jg 101 C#.doc 101

Santhosh Kumar Jayaraman · Answer

join all the files as single string string str= filename1 + ; +filename2 +; +filename3 + ; ; Now pass this string to database. So your table will look like pw.jpeg; ex.jpeg;kk.doc 101

KRayudu V · Answer

yait works Butwith same id it should saved in four rows(DATABASE) Example MaterialOne ID pw.jpeg 101 ex.jpeg 101 kk.doc 101 ww.doc 101

Santhosh Kumar Jayaraman · Answer

Add everything into single variable separated by comma or colon