This tutorial is about how to read and write from/to a file (textual file).
First of all define the files that are for the input and output filenames.
NOTE: the { } are the begin and end of a code structure, e.g. While begin; do something; end;
string fileName = "country.txt";
string outFileName = "sqlcountry.txt";
//make sure that the file is present
if (File.Exists(fileName))
{
//Setup the output file object, using a StreamWriter to write to files.
using (StreamWriter SWriter = new StreamWriter(outFileName))
{
//Setup the input file object,
using (StreamReader SReader = new StreamReader(fileName))
{
//The line is the input line from the input file.
String line;
//While assigning the line from the input file is valid
while ((line = SReader.ReadLine()) != null){
//Write to the output file some different text.
SWriter.WriteLine("insert into country(place) values(\"" + line + "\");");
}
I have attached all of the required files to be able to test this tutorial.