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

KRayudu V

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 button,the four file names should save in single column

Please help me on this requirement

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Santhosh Kumar Jayaraman14y ago
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(';',@str,0)
While(CHARINDEX(';',@str,0) !=0)
BEGIn
insert into SchoolClass values(5,SUBSTRING(@str,0,charindex(';',@str,0)))
select @str=SUBSTRING(@str,charindex(';',@str,0)+1,LEN(@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 V14y ago
ya we can do like that.
But,the file names should save(DATABASE) in this way

MaterialOne         ID

kumar.jpg           101
santosh.jpg        101
rayud.jg             101
C#.doc              101
Santhosh Kumar Jayaraman14y ago
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 V14y ago
ya,it works
But,with 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 Jayaraman14y ago
Add everything into single variable separated by comma or colon