C#

// get the selected row<br />
<br />
DataRow selectedRow = contacts.Tables[0].Rows[contactlist.SelectedIndex];<br />
// Begin an edit transaction on the row.<br />
selectedRow.BeginEdit();<br />
selectedRow["Service_Release_SQL"] =sr_sql.Text;<br />
selectedRow.EndEdit();<br />
contacts.WriteXml(@"contacts.xml");

<br />
    public partial class PTAnalyzer : Form<br />
    {<br />
        // DATA ACCESS CODE<br />
        public OleDbConnection conn;<br />
        public OleDbDataAdapter dAdapter;<br />
        public DataSet dSet;<br />
        public string conString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\\..\\ptrack6.mdb";<br />
        <br />
        public PTAnalyzer()<br />
        {<br />
            InitializeComponent();<br />
<br />
            // DATA ACCESS INITIALIZATION<br />
            try<br />
            {<br />
                conn = new OleDbConnection(conString);<br />
                dAdapter = new OleDbDataAdapter("SELECT * FROM game WHERE player_id = 11", conn);<br />
                dSet = new DataSet();<br />
                //refreshes rows in the DataSet 			<br />
                dAdapter.Fill(dataSetPT, "game");<br />
            }<br />
            catch (Exception ex)<br />
            {<br />
                MessageBox.Show("Error : " + ex.Message);<br />
            } //try-catch	   <br />
        }<br />
    }<br />
<br />