hi
Error - Process has exited so the requested information is not available on below line
process.CloseMainWindow();
static async Task Main(string[] args) { var datasource = @"MSSQLSERVER_2019"; var database = "Videos"; var username = "sa"; var password = "sa"; string connectionString = @"Data Source=" + datasource + ";Initial Catalog=" + database + ";Persist Security Info=True;User ID=" + username + ";Password=" + password; List<string> youtubevideoslinks = GetYouTubeVideoLinksFromDatabase(connectionString); foreach (var item in youtubevideoslinks) { RunVideo(item); } } public static List<string> GetYouTubeVideoLinksFromDatabase(string connectionString) { List<string> youtubevideoslinks = new List<string>(); string query = "SELECT videoid FROM videos"; //Replace table name and column name here using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { string videoLink = reader["videoid"].ToString(); youtubevideoslinks.Add(videoLink); } reader.Close(); } return youtubevideoslinks; } public static void RunVideo(string videoId) { string url = $"youtube.com/watch?v={videoId}"; var process = new Process(); var _process = new ProcessStartInfo(@"C:\Program Files (x86)\Microsoft\Edge\Application\msedge.exe", url); process.StartInfo = _process; process.Start(); Thread.Sleep(2000); process.CloseMainWindow(); process.Close(); }
Thanks