Print the File Stored along with its Data in the database

See more:

C#

SQL-Server

C#4.0

I have a MS SQL DB Table which stores the File Name and the Data of that file. In the Client-Side I want the client to fetch the file from the database and print it with the Printer Selected from the List of Installed Printers from the Dropdownlist, I had tried in many options and Code snippets for reading the file and printing it but it is not working Can anyone help me out with this ?

I tried with the Following Code,

protected void ggvqpdetail_RowCommand(object sender, GridViewCommandEventArgs e)
       {
           if (e.CommandName.ToUpper().ToString() == "PRINTREC")
           {
               try
               {
                   // Set the printer to a printer in the dropdown box when the selection changes.
                   PrintDocument printDoc = new PrintDocument();
                   string a = TextBox1.Text + TextBox2.Text + TextBox3.Text;
                   DataTable dt = new DataTable();
                   IDataReader dr = ExamManagement.SP.Eval_QP_PrintSelect(a).GetReader();
                   dt.Load(dr);
                   dr.Close();
                   dr.Dispose();
                   if (ddlprint.SelectedIndex != -1 && dt.Rows.Count > 0)
                   {
                       // The dropdown box's Text property returns the selected item's text, which is the printer name.
                       printDoc.PrinterSettings.PrinterName = ddlprint.Text;

                       ProcessStartInfo printJob = new ProcessStartInfo();
                       printJob.FileName = dt.Rows[0]["Filename"].ToString();

                       printJob.UseShellExecute = true;
                       printJob.Verb = "printto";
                       printJob.CreateNoWindow = true;
                       printJob.WindowStyle = ProcessWindowStyle.Hidden;
                       printJob.Arguments = ddlprint.Text;//Getting Which Printer

                       Process.Start(printJob);
                       if(dr.Read())
                       {

                       }

                   }
               }
               catch(Exception ex)
               {
                   Lblmsg.Visible = true;
                   Lblmsg.Text = ex.Message;
               }
           }
       }