insert selected image from datagrid in wpf

Question

1.00/5 (1 vote)

See more:

There is a DataGrid with bunch of images in my wpf application.
I have to select an image from my DataGrid and insert that image into mysql DB.
My code is not working properly. I need help. My code is below.

C#

private void btnImage_Click(object sender, RoutedEventArgs e)
        {            
            {
		string constr = "Data Source=localhost;port=3306;Initial Catalog=MyCollege;User Id=root;password=2525";
                MySqlConnection con = new MySqlConnection(constr);
                MySqlCommand cmd = new MySqlCommand("INSERT INTO images(Image) VALUES ('" + dataGrid1.SelectedValue + "')", con);
                con.Open();
                int s1 = cmd.ExecuteNonQuery();
                if (s1 > 0)
                {
                    lbl1.Content = "Image inserted succesfully";
                }
                con.Close();
            }
        }

Posted 17-Oct-15 6:14am

abdujalilc

Updated 18-Oct-15 20:11pm

VR Karthikeyan

v3

Add a Solution

Comments

VR Karthikeyan 19-Oct-15 0:43am

Cast the SelectedValue to BitmapImage and Convert it into bytes array and save it in database.

abdujalilc 19-Oct-15 1:45am

Example code would be much appreciated if possible. As I am new on wpf. Thanks.

VR Karthikeyan 19-Oct-15 2:28am

How you are assign Images to DataGrid? by using DataTable or? Show the code pls.

abdujalilc 19-Oct-15 4:13am

private void BindGrid1()
{
MySqlConnection con = new MySqlConnection(constr);
MySqlCommand cmd = new MySqlCommand("SELECT Image FROM images)", con);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
dataGrid1.ItemsSource = dt.DefaultView;
}

VR Karthikeyan 19-Oct-15 5:54am

What is the DataType you have used for Image column in images Table?

abdujalilc 19-Oct-15 12:00pm

It's blob.

VR Karthikeyan 20-Oct-15 2:10am

Hi, Refer this code, this will insert your selected image in database.

DataRowView SelectedRowValue = (DataRowView)dataGrid1.SelectedValue;
byte[] ImageBytes = (byte[])SelectedRowValue.Row.ItemArray[0];

string stringConnectionString = "Data Source=localhost;port=3306;Initial Catalog=MyCollege;User Id=root;password=2525";

MySqlConnection objConnection = new MySqlConnection(stringConnectionString);
string CommandText = "INSERT INTO images(Image) VALUES (@ImageSource)";
MySqlCommand objCommand = new MySqlCommand(CommandText, objConnection);
objCommand.Parameters.Add("@ImageSource", MySqlDbType.Blob, objImgBytes.Length).Value = objImgBytes;
objConnection.Open();
objCommand.ExecuteNonQuery();
objConnection.Close();

abdujalilc 20-Oct-15 8:27am

Thanks for your help . There is a tiny problem I have. It says "The name 'objImgBytes' does not exist in the current context ".

VR Karthikeyan 20-Oct-15 8:29am

change objImgBytes to ImageBytes

abdujalilc 20-Oct-15 10:22am

ImageBytes=(byte[])Selected.RowValue.Row.ItemArray[0];--->
Null reference exception was unhandled.
Object reference not set to an instance of an object. How can I solve this one?

VR Karthikeyan 22-Oct-15 0:59am

Correct this, Selected.RowValue to SelectedRowValue
ImageBytes=(byte[])Selected.RowValue.Row.ItemArray[0]; into
ImageBytes=(byte[])SelectedRowValue.Row.ItemArray[0]; Try this, again you got error, please show me your full code.

abdujalilc 22-Oct-15 14:04pm

Thanks a lot for your help again.
My wpf and C# codes are given below:
<window x:class="PupilReg.MainWindow"
="" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" title="Binding To Ado.net" height="644.351" width="674.234" fontsize="15" fontweight="Bold" resizemode="CanResizeWithGrip">
<grid>
<datagrid name="dataGrid1" height="565" width="435" autogeneratecolumns="False" margin="188,10,43,38">
<datagrid.itembindinggroup>
<bindinggroup>

<datagrid.columns>
<datagridtextcolumn header="Image_ID" binding="{Binding Path=Image_ID}" width="80">
<datagridtemplatecolumn header="Image_BLOB" width="200" isreadonly="True">
<datagridtemplatecolumn.celltemplate>
<datatemplate>
<Image Source="{Binding Path=Image_BLOB}" Width="160" Height="160" />

<Button x:Name="InsertImage" Content="Insert" Click="InsertImage_Click" Margin="31,39,583,541"/>

C# is the following:
<window x:class="PupilReg.MainWindow"
="" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" title="Binding To Ado.net" height="644.351" width="674.234" fontsize="15" fontweight="Bold" resizemode="CanResizeWithGrip">
<grid>
<datagrid name="dataGrid1" height="565" width="435" autogeneratecolumns="False" margin="188,10,43,38">
<datagrid.itembindinggroup>
<bindinggroup>

<datagrid.columns>
<datagridtextcolumn header="Image_ID" binding="{Binding Path=Image_ID}" width="80">
<datagridtemplatecolumn header="Image_BLOB" width="200" isreadonly="True">
<datagridtemplatecolumn.celltemplate>
<datatemplate>
<Image Source="{Binding Path=Image_BLOB}" Width="160" Height="160" />

<Button x:Name="InsertImage" Content="Insert" Click="InsertImage_Click" Margin="31,39,583,541"/>

C# is the following:
using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;

namespace PupilReg
{
public partial class MainWindow : Window
{
string constr = "Data Source=localhost;port=3306;Initial Catalog=test;User Id=root;password=2525";
public MainWindow()
{
InitializeComponent();
BindGrid1();
}

private void BindGrid1()
{
MySqlConnection con = new MySqlConnection(constr);
MySqlCommand cmd = new MySqlCommand("SELECT * FROM images", con);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
dataGrid1.ItemsSource = dt.DefaultView;

}
private void InsertImage_Click(object sender, RoutedEventArgs e)
{
{
DataRowView SelectedRowValue = (DataRowView)dataGrid1.Selecte

abdujalilc 22-Oct-15 14:09pm

Thanks a lot for your help again.
My wpf and C# codes are given below:
<window x:class="PupilReg.MainWindow"
="" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" title="Binding To Ado.net" height="644.351" width="674.234" fontsize="15" fontweight="Bold" resizemode="CanResizeWithGrip">
<grid>
<datagrid name="dataGrid1" height="565" width="435" autogeneratecolumns="False" margin="188,10,43,38">
<datagrid.itembindinggroup>
<bindinggroup>

<datagrid.columns>
<datagridtextcolumn header="Image_ID" binding="{Binding Path=Image_ID}" width="80">
<datagridtemplatecolumn header="Image_BLOB" width="200" isreadonly="True">
<datagridtemplatecolumn.celltemplate>
<datatemplate>
<Image Source="{Binding Path=Image_BLOB}" Width="160" Height="160" />

<Button x:Name="InsertImage" Content="Insert" Click="InsertImage_Click" Margin="31,39,583,541"/>

using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;

namespace PupilReg
{
public partial class MainWindow : Window
{
string constr = "Data Source=localhost;port=3306;Initial Catalog=test;User Id=root;password=2525";
public MainWindow()
{
InitializeComponent();
BindGrid1();
}

private void BindGrid1()
{
MySqlConnection con = new MySqlConnection(constr);
MySqlCommand cmd = new MySqlCommand("SELECT * FROM images", con);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
dataGrid1.ItemsSource = dt.DefaultView;

}
private void InsertImage_Click(object sender, RoutedEventArgs e)
{
{
DataRowView SelectedRowValue = (DataRowView)dataGrid1.SelectedValue;
byte[] ImageBytes = (byte[])SelectedRowValue.Row.ItemArray[0];
MySqlConnection objConnection = new MySqlConnection(constr);
string CommandText = "INSERT INTO images (Image) VALUES (@ImageSource)";
MySqlCommand objCommand = new MySqlCommand(CommandText, objConnection);
objCommand.Parameters.Add("@ImageSource", MySqlDbType.Blob, ImageBytes.Length).Value = ImageBytes;
objConnection.Open();
objCommand.ExecuteNonQuery();
objConnection.Close();
}
}
}
}

VR Karthikeyan 23-Oct-15 0:10am

Hello Brother, Are you binding the Images to DataGrid?

abdujalilc 23-Oct-15 2:44am

Hi friend, first I bind images to datagrid, then I select an image from datagrid and insert that selected image to the same database. I just simplified my real project in order to be understandable. So is my purpose achievable?

abdujalilc 23-Oct-15 12:05pm

Problem solved . I couldn't finish this project without your help. I appreciate, thanks.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)