gistfile1.cs

private IEnumerable<DataRow> RetrieveVendor(string table, string system, string region, params string[] fields)
{
	var table = new DataTable();
	var databaseFile = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), "inu.db3");

	if (!System.IO.File.Exists(databaseFile))
	{
		MessageBox.Show(string.Format("I couldn't find the file `{0}'!", databaseFile));
	}

	var connectionString = string.Format("Data Source={0}", databaseFile);

	try
	{
		using (var connection = new SQLiteConnection(connectionString))
		{
			var query = string.Format("SELECT {0}, vpn FROM {1} WHERE system = ? AND region = ?", string.Join(", ", fields), table);

			using (var command = connection.CreateCommand(query))
			using (var adapter = new SQLiteDataAdapter(command))
			{
				command.Parameters.AddWithValue("@system", system);
				command.Parameters.AddWithValue("@region", region);

				connection.Open();

				adapter.Fill(table);

				connection.Close();
			}
		}
	}
	catch (SQLiteException exception)
	{
		MessageBox.Show(exception.ToString());
	}

	return table.Rows;
}