This ought to be an easy one, but I am a beginner with C#.

Given a reference list within the following format:

aptitude  
ability, skill, gift, talent

aqueous  
watery

arguably  
maybe, perhaps, possibly, could be

How do i parse this, and place right into a database table within the format:

TABLE: Term_Glossary
================================================
Term_Name  | Term_Definition                   |
================================================
aptitude   | ability, skill, gift, talent      |
------------------------------------------------
aqueous    | watery                            |
------------------------------------------------
arguably   | maybe, perhaps, possibly, could be|
================================================

Any help could be appreciated - thanks.

Update I recognize the database structure is straightforwardOrineffective - however ,, the purpose of my real question is the code to parse the type of text based in the first example, using C#. Thanks.

It might appear more complicated in the beginning, but its a great deal simpler within the lengthy-term to consider when it comes to two tables:

===========================================
Term_ID     | Term_Name                   |
===========================================
1           | aptitude                    |
2           | aqueous                     |
3           | arguably                    |
===========================================

===============================================
Definition_ID  | Term_ID   | Definition_Name  |
===============================================
1              | 1         | ability          |
2              | 1         | skill            |
3              | 1         | gift             |
4              | 1         | talent           |
5              | 2         | watery           |
6              | 3         | maybe            |
7              | etc.etc.etc

Possibly think if you're able to normalise this by getting one table of words with IDs along with a table of associations.

It appears in my experience as if you would browse the first line, save it to some variable, browse the second line, save it to some second variable, then place in to the table where Term_Title = first variable, and Term_Definition = second variable.

So that your logic could be like:

StreamReader SR;
string Term_Name;
string Term_Definition

SR = File.OpenText(filename);
Term_Name = SR.ReadLine();
while(Term_Name != null)
{
    Term_Definition = SR.ReadLine();
    // make your database call here to insert with these two variables.  I don't know what DB you are using.
    Term_Name = SR.ReadLine();
}
SR.Close();