In your foreach you appear to be overwriting the term data with the subsequent row. You need to add a plus sign:
Code:
foreach (DataRow row in dt.Rows)
{
richTextBoxResult.Text = row["Meaning"].ToString() + ":" +
row["MeaningDetails"].ToString() + ", " + row["Example"].ToString() + "\n";
}
=>
Code:
foreach (DataRow row in dt.Rows)
{
richTextBoxResult.Text += row["Meaning"].ToString() + ":" +
row["MeaningDetails"].ToString() + ", " + row["Example"].ToString() + "\n";
}
--
Joe (
Microsoft MVP - XML)