private void TSB_AddTag_Click(object sender, EventArgs e) { AddTag addTag = new AddTag(); addTag.settings = Settings; if (addTag.ShowDialog() == DialogResult.OK) { LoadPictureTags(); PictureTags buf; if (G_I_listView.SelectedItems.Count > 0) { buf = new PictureTags { IdTags = addTag.S_Tags, URL = G_I_listView.SelectedItems[0].Text }; } else { buf = new PictureTags { IdTags = addTag.S_Tags, URL = G_I_TreeView.SelectedNode.FullPath }; } PictureTags.Add(buf); string query = "insert into PictureTags (URL,IdTag) values(@URL,@IdTag)"; connection.Open(); SqlCommand cmd = new SqlCommand(query, connection); cmd.Parameters.Add("@URL", SqlDbType.NVarChar, 50).Value = buf.URL;; cmd.Parameters.Add("@IdTag", SqlDbType.NVarChar, 50).Value = buf.IdTags; cmd.ExecuteNonQuery(); MessageBox.Show("Тег успешно добавлен"); connection.Close(); } }
private void LoadPictureTags() { LoadTags(); string query = "select * from PictureTags"; connection.Open(); SqlCommand cmd = new SqlCommand(query, connection); SqlDataReader reader = cmd.ExecuteReader(); PictureTags.Clear(); while (reader.Read()) { PictureTags c = new PictureTags() { Id = (int)reader["Id"], IdTags = (int)reader["IdTag"], URL = (string)reader["URL"] }; PictureTags.Add(c); } connection.Close(); }