Database

<br />
CDatabase db;<br />
MyCRecordSet(&db);<br />
<br />
BOOL bSuccess = db.Open(mdsn, FALSE, FALSE, "ODBC;",FALSE);<br />
tablename = "table1";<br />
rs.Open(CRecordset::forwardOnly,tablename);	<br />
//arr is an array that contains string.<br />
for(int i=0;i<5;i++)<br />
{<br />
  CString qstr = "Update " + tablename + " set data2 = '" + arr(i) + "' where data3=1";<br />
rs.m_pDataBase->ExecuteSQL(qstr);<br />
rs.Requery();<br />
<br />
 }<br />
db.Close();<br />

		private bool Add(string extention, Type castType)<br />
		{<br />
			//Get Table<br />
			DataTable currentTable = ds_Data.Tables["Table"];<br />
			<br />
			//Get new row for table<br />
			DataRow newRow = currentTable.NewRow();<br />
<br />
			//Fill new row<br />
			newRow["File_Extention"] = extention;<br />
			newRow["File_Type"]		 = castType;<br />
<br />
			//Add Row<br />
			currentTable.Rows.Add(newRow);<br />
<br />
			ds_Data.AcceptChanges();<br />
<br />
			//Update database<br />
			adapter.Update(currentTable);<br />
<br />
			return true;<br />
		}