Select from DataTable

[maylortaylor]

I have a database table that I'm trying to select from. THe table looks like this:

ID | Rule | RuleName | RuleID
(autonumber) (xmlstring) FakeName a984kjg9

(autonumber) (xmlstring) FakeName1 a4844asdf

You get the picture....ok, so my problem is that I know nothing of C#.

I have this so far.

DataTable dtWebRules = new DataTable();
            dtWebRules = LoadRuleXmlFromDB(dtWebRules);

and *I am trying to grab the Rule (xmlstring) from the DB table. *

So far, I have this, but i know it's wrong.

int dtRow = 0;
foreach (DataRow row in dtWebRules.Row)
{
string xmlstring = dtWebRules.Select("Rule").ToString();
dtRow = dtRow + 1;
}

Any help?