Selecting dataGrid row and print row data

Question

5.00/5 (1 vote)

See more:

, +

There are some rows in my dataGrid, when i select one of them and print it's data, only first image of database will print while i only need to print selected row image.

XML

<Image VerticalAlignment="Center" HorizontalAlignment="Center" Stretch="Fill" Name="PictureBox"
                       Source="{Binding Picture}" DataContext="{Binding Path=SelectedItem, ElementName=grdPersonnel1}" Opacity="2">
	</Image>

C#

private void Print_Click(object sender, RoutedEventArgs e)
        {
            System.Windows.Controls.PrintDialog printDialog = new System.Windows.Controls.PrintDialog();
            if (printDialog.ShowDialog() == true)
            {
                
                DrawingVisual dv = new DrawingVisual();
                var dc = dv.RenderOpen();
              
                SqlConnection con = new SqlConnection();
                con.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\Database\Data.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
                SqlCommand cmd = new SqlCommand();
                BitmapImage bmp = new BitmapImage();
                cmd.CommandText = "SELECT Picture FROM DataBase";
                cmd.Connection = con;
                con.Open();
                bmp.CacheOption = BitmapCacheOption.OnLoad;
                bmp.BeginInit();
                bmp.StreamSource = new System.IO.MemoryStream((Byte[])cmd.ExecuteScalar());
                bmp.EndInit();
                dc.DrawImage(bmp, new Rect(140, 170, 150, 150));
-

                dc.DrawText(new FormattedText("Name:", CultureInfo.GetCultureInfo("en-us"), FlowDirection,
                     new Typeface(new System.Windows.Media.FontFamily("Courier New"), FontStyles.Normal, FontWeights.Bold,
                         FontStretches.Normal), 12, System.Windows.Media.Brushes.Black), new System.Windows.Point(700, 180));
                dc.DrawText(new FormattedText(txtName.Text, CultureInfo.GetCultureInfo("en-us"), FlowDirection,
                      new Typeface(new System.Windows.Media.FontFamily("Courier New"), FontStyles.Normal, FontWeights.Normal,
                          FontStretches.Normal), 11, System.Windows.Media.Brushes.Black), new System.Windows.Point(550, 180));

                dc.Close();             
                printDialog.PrintVisual(dv, "Print");
            }
		}

Posted 15-Aug-12 6:00am

M.H. Shojaei

Updated 15-Aug-12 6:01am

v2

Add a Solution

Comments

[no name] 15-Aug-12 12:04pm

You are not selecting your image based on any kind of identifier.

M.H. Shojaei 15-Aug-12 12:07pm

What type of identifier?

[no name] 15-Aug-12 12:12pm

Any kind. Name, number, index. Whatever you are using in your database.

M.H. Shojaei 15-Aug-12 12:15pm

If I use Name or ID, have you guidance or link?

[no name] 15-Aug-12 12:17pm

http://www.w3schools.com/sql/sql_where.asp

M.H. Shojaei 15-Aug-12 12:28pm

I used this:
cmd.CommandText = "SELECT Picture FROM Database Where Name=@Name";

But error: Must declare the scalar variable "@Name".

[no name] 15-Aug-12 12:32pm

"SELECT Picture FROM Database Where Name='" + whereeveritisthatNameiscomingfrom + "'" and you might want to do some research on parameterized queries.

M.H. Shojaei 15-Aug-12 12:44pm

I found this:
...= "SELECT Picture FROM DataBase" + " where Name=" + (MyClass(grdPersonnel.SelectedItem)).Name;

but it's don't work!

[no name] 15-Aug-12 12:45pm

You have to use single quotes for text items in SQL

Kenneth Haugland 15-Aug-12 12:18pm

When I read the title it though ok, but when I saw the code I was lost... What are you trying to achive?

M.H. Shojaei 15-Aug-12 13:49pm

As i said: When i select one of DataGrid rows and print it's data, only first image of database will print while i only need to print selected DataGrid row image.

1 solution

Add a Solution

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)

M.H. Shojaei · Answer 1 · 2012-08-19T04:55:00

I solved it.

C#

private void Print_Click(object sender, RoutedEventArgs e)
{
    System.Windows.Controls.PrintDialog printDialog = new System.Windows.Controls.PrintDialog();
    if (printDialog.ShowDialog() == true)
    {                
        DrawingVisual dv = new DrawingVisual();
        var dc = dv.RenderOpen();

         SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\Database\Database.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
            SqlCommand cmd = new SqlCommand();

            BitmapImage bmp = new BitmapImage();
            cmd.CommandText = "Select Picture from Database where Code=@Code";
            cmd.Parameters.Add("@Code", SqlDbType.NVarChar, 30);
            cmd.Parameters["@Code"].Value = this.txtCode.Text;
            cmd.Connection = con;
            con.Open();

            bmp.CacheOption = BitmapCacheOption.OnLoad;
            bmp.BeginInit();
            bmp.StreamSource = new System.IO.MemoryStream((Byte[])cmd.ExecuteScalar());
            bmp.EndInit();
            dc.DrawImage(bmp, new Rect(140, 170, 150, 150));

        dc.DrawText(new FormattedText("Name:", CultureInfo.GetCultureInfo("en-us"), FlowDirection,
             new Typeface(new System.Windows.Media.FontFamily("Courier New"), FontStyles.Normal, FontWeights.Bold,
                 FontStretches.Normal), 12, System.Windows.Media.Brushes.Black), new System.Windows.Point(700, 180));
        dc.DrawText(new FormattedText(txtName.Text, CultureInfo.GetCultureInfo("en-us"), FlowDirection,
              new Typeface(new System.Windows.Media.FontFamily("Courier New"), FontStyles.Normal, FontWeights.Normal,
                  FontStretches.Normal), 11, System.Windows.Media.Brushes.Black), new System.Windows.Point(550, 180));


        dc.Close();

        printDialog.PrintVisual(dv, "Print");
    }