/// <summary> /// Saves relations between TAGs and XML rows /// </summary> /// <param name="relationsArray">List with TAG IDs and XML FIELD IDs</param> /// <returns>True if success</returns> public bool SaveRelations(XmlTagRelation[] relationsArray) { string strSQL; ADODB.Connection con = new ADODB.Connection(); object obj = new object(); try { con.Open(GenerateConnectionString(), "", "", 0); } catch (Exception) { //TODO: Error logging return false; } for (int i = 0; i < relationsArray.Length; i++) { strSQL = string.Format(NEW_XML_TAG_RELATION, relationsArray[i].TagID, relationsArray[i].XmlFileID); try { con.Execute(strSQL, out obj, 0); } catch (Exception) { //TODO: Error logging con.Close(); return false; } } con.Close(); return true; }
public List<XmlTagRelation> LoadRelationArray() { string strAccessConn = GenerateConnectionString(); string strAccessSelect = "SELECT * FROM XML_TAG_RELATION"; // Create the dataset and add the Categories table to it: DataSet myDataSet = new DataSet(); OleDbConnection myAccessConn = null; try { myAccessConn = new OleDbConnection(strAccessConn); } catch (Exception) { return null; } try { OleDbCommand myAccessCommand = new OleDbCommand(strAccessSelect, myAccessConn); OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(myAccessCommand); myAccessConn.Open(); myDataAdapter.Fill(myDataSet, "XML_TAG_RELATION"); } catch (Exception) { return null; } finally { myAccessConn.Close(); } DataRowCollection dra = myDataSet.Tables["XML_TAG_RELATION"].Rows; List<XmlTagRelation> array = new List<XmlTagRelation>(); for (int i = 0; i < dra.Count; i++) { DataRow dr = dra[i]; XmlTagRelation item = new XmlTagRelation(); item.TagID = (int)(dr.ItemArray[0]); item.XmlFileID = (int)(dr.ItemArray[1]); array.Add(item); } return array; }