Save path in Database

Here are the steps on how to save the paths of your PDF files stored in a folder on Server in a database:

1. Open a database connection.
2. Create a table to store the file paths. The table should have the following columns:
   • file_path: The path to the PDF file.
   • file_name: The name of the PDF file.
3. Insert the file paths into the table. You can use a loop to iterate through the files in the folder and insert the paths into the table.
4. Close the database connection.

using (var connection = new SqlConnection("Data Source=localhost;Initial Catalog=MyDatabase;Integrated Security=True"))
{
    connection.Open();

    var sql = @"
    CREATE TABLE PdfFiles
    (
        file_path NVARCHAR(255) NOT NULL,
        file_name NVARCHAR(255) NOT NULL
    );
    ";

    var cmd = new SqlCommand(sql, connection);
    cmd.ExecuteNonQuery();

    var files = Directory.GetFiles(@"C:\path\to\pdf\files", "*.pdf");

    foreach (var file in files)
    {
        var sql = @"
        INSERT INTO PdfFiles (file_path, file_name)
        VALUES (@file_path, @file_name);
        ";

        var cmd = new SqlCommand(sql, connection);
        cmd.Parameters.AddWithValue("@file_path", file);
        cmd.Parameters.AddWithValue("@file_name", Path.GetFileName(file));
        cmd.ExecuteNonQuery();
    }

    connection.Close();
}

Once you have saved the file paths in the database, you can access them by querying the database. For example, you can use the following SQL query to get all of the file paths:

SELECT file_path, file_name
FROM PdfFiles;

Try this

string folderPath = @"C:\path\to\folder"; // Change the path to your server path
string[] filePaths = Directory.GetFiles(folderPath, "*.pdf");
using (SqlConnection sqlConnection = new SqlConnection("YourConnectionString"))
{
    sqlConnection.Open();
    foreach (string filePath in filePaths)
    {
        SqlCommand sqlCommand = new SqlCommand("INSERT INTO YourTable (FilePath) VALUES (@filePath)", sqlConnection);
        sqlCommand.Parameters.AddWithValue("@filePath", filePath);
        sqlCommand.ExecuteNonQuery();
    }
}