code
https://gist.github.com/zerowapo/8c80b9cef3fb2fab9e349608ca3443cb
https://gist.github.com/zerowapo/8c80b9cef3fb2fab9e349608ca3443cb
int counter = 1; | |
string line; | |
string t=""; | |
// Read the file and display it line by line. | |
System.IO.StreamReader file = | |
new System.IO.StreamReader(@"C:\Users\HP\Downloads\index.txt"); | |
while ((line = file.ReadLine()) != null) | |
{ | |
// MessageBox.Show(counter + 1 + ":" + line + "\n"); | |
t = "Insert Into word_arabic2 (id,Name) values ('"+counter+"','"+line+"');"; | |
string path=@"C:\Users\HP\Documents\visual studio 2012\Projects\insert_line_DB\insert_line_DB\Db_word.txt"; | |
using (System.IO.StreamWriter ts = | |
new System.IO.StreamWriter(path, true)) | |
{ | |
ts.WriteLine(t); | |
ts.Close(); | |
//File.WriteAllText(path, String.Empty); | |
} | |
counter++; | |
} | |
file.Close(); | |
richTextBox1.Text = t; |