How to save each ArrayList value?

Abhilash J A

Hello Everyone,

I am trying to each save filepath and filename from Arralist.

In the 'Images' folder have 3 .jpg file. Like that, 'E:\File\Images\A_001.jpg' , E:\File\Images\A_002.jpg ect. I want to save each filepath and

filename (A_001), here 'A' is parrentName and childName is 001,002 ect. childName want to save under the parrentName. How to save each filepath and filename?

string[] jpgFilePath = Directory.GetFiles(@"E:\File\Images", "*.jpg").ToArray();
string[] jpgFilesNames = Directory.GetFiles(@"E:\File\Images", "*.jpg")
.Select(path => Path.GetFileName(path))
.ToArray();
objTble_Documents.CreatedDate = Convert.ToDateTime(DateTime.Now);
objTble_Documents.IsActive = true;
objTble_Documents.CreatedBy = 1;
objTble_Documents.UserId = 1;
foreach (var item in jpgFilePath)
{
foreach (var item1 in jpgFilesNames)
{
string parrentName = item1.Split('_')[0];
string childName = item1.Split('_')[1];
objTble_Documents.FilePath = item;
objTble_Documents.Parent_File_Name = parrentName;
objTble_Documents.Child_File_Name = childName;
service.ObjDocuments = Mapper.Map(objTble_Documents);
service.AddScanDocuments();
}
}

6 Replies

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

Manas Mohapatra10y ago
Accepted answer
For file names:A_001.jpg,A_002.jpg,A_003.jpg
You will have multiple records in your database or it will be one records with child nameswill be comma separated..
Bikesh Srivastava10y ago
you can use insert query inside foreach loop.
Abhilash J A10y ago
Hello Bikesh Srivastava,

This is insert query.
  public void AddScanDocuments(Model.Tble_Documents Doc)
        {
SQLiteCommand insertSQL = new SQLiteCommand("INSERT INTO Tble_Documents (FilePath, Parent_File_Name, Child_File_Name, UserId, CreatedBy, CreatedDate,IsActive) VALUES (@FilePath, @Parent_File_Name, @Child_File_Name, @UserId, @CreatedBy, @CreatedDate,@IsActive)", dbConnection);
}
Delpin Susai Raj10y ago
https://m.youtube.com/watch?v=W_cOlBBlFGM
Delpin Susai Raj10y ago
http://www.c-sharpcorner.com/uploadfile/e628d9/inserting-retrieving-images-from-sql-server-database-without-using-stored-procedures/
Bikesh Srivastava10y ago
Hi,
You are doing good .but whats your query.