Auto print without dialog

Question

I found code for printing. But I want to sent to printer automaticaly without dialog box. I know printername. I get printer name from SQL table. How can I do it ?

// select printer and get printer settings
PrintDialog pd = new PrintDialog();
if (pd.ShowDialog() != true) 
{
    return; 
}
        
// create a document
FixedDocument document = new FixedDocument();
document.DocumentPaginator.PageSize = new Size(pd.PrintableAreaWidth, pd.PrintableAreaHeight);

// create a page
FixedPage page1 = new FixedPage();
page1.Width = document.DocumentPaginator.PageSize.Width;
page1.Height = document.DocumentPaginator.PageSize.Height;

// add some text to the page
TextBlock page1Text = new TextBlock();
page1Text.Text = "This is a text"
page1Text.FontSize = 12; // 30pt text
page1Text.Margin = new Thickness(50); // 1 inch margin
page1.Children.Add(page1Text);

// add the page to the document
PageContent page1Content = new PageContent();
((IAddChild)page1Content).AddChild(page1);
document.Pages.Add(page1Content);

// and print
pd.PrintDocument(document.DocumentPaginator, "Print");

Answer 1

Instead of the PrintDialog class, try using the PrintDocument class directly, where you can set the printer by the name:

using System.Drawing.Printing;

PrintDocument pd = new PrintDocument();
pd.PrinterSettings.PrinterName = "my printer";

To loop through the available printer names:

foreach (string s in PrinterSettings.InstalledPrinters) {
  //
}

Answer 2

I remove if (pd.ShowDialog() != true) return; and add this code pd.PrintQueue = new PrintQueue(new PrintServer(), "printer name" ); to print my choose printer.