Comments by abdujalilc (Top 13 by date)

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?

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();
}
}
}
}

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

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?

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

It's blob.

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;
}

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