No, we can't! We don't know what database you are using, what tables you have, what fields in the tables, etc..
What we can do is suggest:
1) Read the file:
string[] lines = File.ReadAllLines(path);
2) Loop through each line, and proccess it into components:
foreach (string line in lines)
{
string[] components = line.Split('|');
...
}
3) Construct a database connection, and a command, and write your fragments. Assuming SQL Server:
SqlConnection con = new SqlConnection(connectionString);
con.Open();
SqlCommand com = new SqlCommand("INSERT INTO myTable (myField1, myField2) VALUES (@MF1, @MF2)", con);
com.Parameters.AddWithValue("@MF1", components[0]);
com.Parameters.AddWithValue("@MF2", components[1]);
com.ExecuteNonQuery();
The rest is up to you!
Submit an article or tip