save csv file in database

6y953Visual Basic .NET

Hello and hi, why this got does not execute if condition ? it goes straight to else even though the file name already in database. I need to do if the csv file name already save in database, it will print out file exist. please help me

foreach(FileInfo file in filess) {
DateTime lastWriteTime = file.LastWriteTime;
Console.WriteLine("File list : " + file);
Console.WriteLine("Time last Edit : " + lastWriteTime);
if (File.Exists("file")) {
Console.WriteLine("File Name Exist!");
var sel = "select * from listfile where filename = @filename";
var cmd2 = new NpgsqlCommand(sel, conn);
conn.Open();
cmd2.Parameters.AddWithValue("@filename", file);
Console.WriteLine(file + " exist in database.");
cmd2.ExecuteNonQuery();
conn.Close();
}
else {
Console.WriteLine("File Name NOT Exist!");
var lf = "insert into listfile(filename)values(@filename)";
var cmd = new NpgsqlCommand(lf, conn);
conn.Open();
cmd.Parameters.AddWithValue("filename", Convert.ToString(file));
string filename1 = cmd.Parameters["@filename"].Value.ToString();
Console.WriteLine("Record inserted successfully. filename = " + file);
cmd.ExecuteNonQuery();
conn.Close();
}
}

4 Replies

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

Jay Krishna Reddy6y ago
Get the file name through query suppose here i am sharing the sample code to get and check the file.

Query to get the file name from Db.
var name = dbContext.Files.Where(c=>c.Filename == "yOUR FILE NAME").Select(d=>d.Filename).FirstOrDefault();
here you will get the file name and check with the path whether it exists or not.
This helps you..
6y ago
How about if the file is in the database, how to check the path ? thank you
Jay Krishna Reddy6y ago
Make sure to give correct file name or exact path to check the file in our project.

Below code helps you..
using System;
using System.IO;
class Demo {
   static void Main() {
      if (File.Exists("MyFile.txt")) {
         Console.WriteLine("File exists...");
      } else {
         Console.WriteLine("File does not exist in the current directory!");
      }
      if (File.Exists(@"D:\myfile.txt")) {
         Console.WriteLine("File exists...");
      } else {
         Console.WriteLine("File does not exist in the D directory!");
      }
   }
}
Farhan Ahmed6y ago
Visit this article it will help you https://www.c-sharpcorner.com/UploadFile/8c19e8/uploading-and-importing-csv-file-to-sql-server/