1.For your current database table, it is not possible to insert multiple value for only one fields into the same record.
2.You have to refine your database by using a second table (named Images) for storing the images associated with the record from your first table:
-change your first table to have the next fields:
SId, SName, City
-create a 2nd table named Images with the next fields:
ID (Autonumber, PK), SId (integer FK), ImageFileName (varchar), Image (Image)
-create a FK link between these two tables by using
SId from both tables;
3.For details about multiple file upload controls you could read the next articles:
http://www.itorian.com/2014/01/single-file-upload-to-multiple-file.html[
^]
http://www.asp.net/ajaxlibrary/ajaxcontroltoolkitsamplesite/ajaxfileupload/ajaxfileupload.aspx[
^]
4.Regarding the saving the data into the SQL tables, first your have to insert the data into your first table ==>
SId, then you should iterate all files and insert a new row in the
Images table by using the
SId . If you want to execute all this INSERT command together you could use transaction. See details:
Using Transactions in ADO.NET[
^]
Submit an article or tip