PrintPreviewDialog C# Example

C# > Print  > PrintPreviewDialog

PrintPreviewDialog is a dialog box form for printing from a Windows Forms application.






Example

In this example we will create a print document and print using PrintPreviewDialog. We will print some text on Print Page event

using System;

using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Drawing.Printing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApplication3

{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        private void btnPrint_Click(object sender, EventArgs e)
        {
            PrintDocument document = new System.Drawing.Printing.PrintDocument();
            PrintPreviewDialog ppd = new PrintPreviewDialog();
            ppd.ClientSize = new System.Drawing.Size(500, 400);
            ppd.Location = new System.Drawing.Point(0, 0);
            document.PrintPage += new PrintPageEventHandler(Doc_PrintPage);
            ppd.Document  = document;
            ppd.ShowDialog();
        }
        private void Doc_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
        {
            string text = "Header";
            Font printFont = new  Font("Tahoma", 40, System.Drawing.FontStyle.Bold );
            e.Graphics.DrawString(text, printFont, Brushes.Blue, 0, 0);
            text = "Text";
            printFont = new Font("Tahoma", 30, System.Drawing.FontStyle.Regular);
            e.Graphics.DrawString(text, printFont, Brushes.Black , 0, 100);
        }
    }
}

Add operator SQL Server Example

SQL Server > Operators > Add

+ Operator adds two numbers.





Example

1. Add values from 2 numeric columns

create table #test(value int, fee int)
insert into #test(value, fee) values (500,50),(100,10)
  select
   value + fee as 'Total'
  from
   #test
drop table #test

Result:
 Total
   550
   110

2. Add values from 1 numeric value and 1 char value

DECLARE @int_value int = 100
DECLARE @str_value varchar(10) = '10'

SELECT @str_value + @int_value

Result:
(No column name)
110

3. Using + operator to concatenate string

DECLARE @str1 varchar(10) = 'Microsoft'
DECLARE @str2 varchar(10) = 'SQL Server'

SELECT @str1 + ' ' + @str2

Result:
(No column name)
Microsoft SQL Server

Rank DataTable with LINQ C# Example

C# > LINQ > Rank

Example: Using LINQ to implement RANK function with DataTable.

using System;

using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApplication3

{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        public  DataTable RankDt(DataTable dt, string fld)
        {
            var rankDt = (from row in dt.AsEnumerable()
                            orderby row.Field<int>(fld) descending
                            select row).CopyToDataTable();

            rankDt.Columns.Add("Rank");

            int rank = 1;
            for (int i = 0; i < rankDt.Rows.Count - 1; i++)
            {
                rankDt.Rows[i]["Rank"] = rank;
                if (rankDt.Rows[i][fld].ToString() != rankDt.Rows[i + 1][fld].ToString())
                    rank++;
            }
            rankDt.Rows[rankDt.Rows.Count - 1]["Rank"] = rank;
            return rankDt;
        }

        private void Form1_Load(object sender, EventArgs e)

        {
            DataSet ds = new DataSet();
            ds.Tables.Add("Product");
            DataTable dt = ds.Tables[0];
            dt.Columns.Add("name", typeof(string));
            dt.Columns.Add("quantity", typeof(Int32));
 
            DataRow dr = dt.NewRow();
            dr[0] = "Product 1" ;
            dr[1] = 500;
            dt.Rows.Add(dr);
            dr = dt.NewRow();

            dr[0] = "Product 2";

            dr[1] = 500;
            dt.Rows.Add(dr);

            dr = dt.NewRow();

            dr[0] = "Product 3";
            dr[1] = 50;
            dt.Rows.Add(dr);

            dr = dt.NewRow();

            dr[0] = "Product 4";
            dr[1] = 100;
            dt.Rows.Add(dr);

            dataGridView1.DataSource = RankDt(dt, "quantity");

        }
     }
}

 

Visual Basic Statements

VB.NET > Statements

AddHandler	Call	Class	Const
Continue	Declare	Delegate	Dim
Do...Loop	Else	End	End
Enum	Erase	Error	Event
Exit

RaiseEvent	ReDim	REM	RemoveHandler
Resume	Return	Select...Case	Set
Stop	Structure	Sub	SyncLock
Then	Throw	Try...Catch...Finally	Using
While...End While	With...End With	Yield

Generics and Arrays Example in C#

C# > Generics > Generics and Arrays

Example: Use a single generic method that takes an IList<T> input parameter and iterate through both a list of integers and an array of string.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApplication2

{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)

        {
            string[] str = { "0", "1", "2", "3", "4" };
            List<int> intL = new List<int>();
            for (int x = 0; x < 5; x++)
            {
                intL.Add(x);
            }
            ProcessList<string>(str);
            ProcessList<int>(intL);
        }
        static void ProcessList<T>(IList coll)
        {
            foreach (T item in coll)
            {
                MessageBox.Show(item.ToString());
            }
        }
    }
}

Form VB.NET

VB.NET > Form

Form

Is a representation of any window displayed in an application.

Type

• standard
• tool
• borderless
• floating

Example

Create dialog box in runtime

Dim form1 As New Form()

Dim btnYes As New Button()

Dim btnNo As New Button()
btnYes.Text = "Yes"
btnYes.Location = New Point(5, 5)
btnNo.Text = "No"
btnNo.Location = New Point(btnYes.Left, btnYes.Top + 30)

form1.Controls.Add(btnYes)

form1.Controls.Add(btnNo)

form1.Text = "Confirm Dialog Box"

form1.FormBorderStyle = FormBorderStyle.FixedDialog
form1.MaximizeBox = False
form1.MinimizeBox = False
form1.AcceptButton = btnYes
form1.CancelButton = btnNo
form1.StartPosition = FormStartPosition.CenterScreen

form1.ShowDialog()