Set Default Page Setup in ReportViewer

Dim pg As New System.Drawing.Printing.PageSettings()    pg.Margins.Top = 0    pg.Margins.Bottom = 0.25                pg.Margins.Left = 0                pg.Margins.Right = 0 Dim size As System.Drawing.Printing.PaperSize = New PaperSize(“custom”,…

Read More

Combo box with value and text in VB 6

VB 6 Combo box with value and text1. Add component Microsoft Forms 2.02. EngMatchFrm.CmbEngComponent.Clear    EngMatchFrm.CmbEngComponent.ColumnCount = 2    EngMatchFrm.CmbEngComponent.ColumnWidths = “0 in; 2 in”    Dim i…

Read More

Calculate Total Hour and Minute in SQL

SELECT ((DATEDIFF(minute, ‘2013-06-30 08:30:00.0000000’, ‘2013-06-30 10:45:00.0000000’))/60) AS TotalHour,        ((DATEDIFF(minute, ‘2013-06-30 08:30:00.0000000’, ‘2013-07-30 10:45:00.0000000’))%60) AS TotalMinute The result of the above query is: TotalHour    TotalMinute      …

Read More