private void AddPhotoClicked(object sender, EventArgs e) { if (_loadedImage == null) { return; } var imageData = ImageToByteArray(_loadedImage); var constring = DBRequests.AddPhoto(PhotoNameTextBox.Text, imageData, (AlbumListBox.SelectedItems[0] as TextInstance).ID, (CategoryListBox.SelectedItems[0] as TextInstance).ID, LoginPage.LoggedUser, PhotoDescTextBox.Text, _tags.Select((instance, i) => instance.Name).ToArray(), _loadedImageExtension, _loadedImage.Size, imageData.Length); using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["HMatuszewski.PhotoAlbum.Properties.Settings.BDFotoConnectionString"].ConnectionString)) { using (var command = new SqlCommand(constring, connection)) { command.Parameters.Add("@image", SqlDbType.Binary).Value = imageData; connection.Open(); command.ExecuteNonQuery(); connection.Close(); } } }