/// <summary> /// Loads an Item from Database /// </summary> /// <param name="connection">MySqlConnection</param> /// <param name="itemKeyname">Id_nb of the Item</param> /// <param name="databaseName">The name of the Database</param> /// <returns></returns> public ItemTemplates.ItemTemplateRow loadRowFromDatabase(MySqlConnection connection, string itemKeyname, string databaseName) { try { connection.Open(); string columnsSQL = ""; for (int i = 0; i < this.ItemTemplate.Columns.Count; i++) { if (i != 0) { columnsSQL += ", "; } columnsSQL += "`" + this.ItemTemplate.Columns[i].ColumnName + "`"; } string SQL = "SELECT " + columnsSQL + " FROM " + databaseName + " WHERE Id_nb = '" + itemKeyname + "' LIMIT 0,1"; MySqlDataAdapter adapter = new MySqlDataAdapter(); MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = SQL; cmd.Connection = connection; adapter.SelectCommand = cmd; ItemTemplates tmp = new ItemTemplates(); adapter.Fill(tmp.ItemTemplate); return((ItemTemplates.ItemTemplateRow)tmp.ItemTemplate.Rows[0]); } catch (System.Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message); } finally { connection.Close(); } return(this.ItemTemplate.NewItemTemplateRow()); }
/// <summary> /// Loads an Item from Database /// </summary> /// <param name="connection">MySqlConnection</param> /// <param name="itemKeyname">Id_nb of the Item</param> /// <param name="databaseName">The name of the Database</param> /// <returns></returns> public ItemTemplates.ItemTemplateRow loadRowFromDatabase(MySqlConnection connection, string itemKeyname, string databaseName) { try { connection.Open(); string columnsSQL = ""; for (int i = 0; i < this.ItemTemplate.Columns.Count; i++) { if (i != 0) columnsSQL += ", "; columnsSQL += "`" + this.ItemTemplate.Columns[i].ColumnName + "`"; } string SQL = "SELECT " + columnsSQL + " FROM " + databaseName + " WHERE Id_nb = '" + itemKeyname + "' LIMIT 0,1"; MySqlDataAdapter adapter = new MySqlDataAdapter(); MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = SQL; cmd.Connection = connection; adapter.SelectCommand = cmd; ItemTemplates tmp = new ItemTemplates(); adapter.Fill(tmp.ItemTemplate); return (ItemTemplates.ItemTemplateRow)tmp.ItemTemplate.Rows[0]; } catch (System.Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message); } finally { connection.Close(); } return this.ItemTemplate.NewItemTemplateRow(); }