Monthly Archives: January 2020

How pass data to crystal Report

With ReportViewerSale Dim rpt_Document As New ReportDocument Dim ParamCollection As New CrystalDecisions.Shared.ParameterValues rpt_Document.Load(Application.StartupPath & “\Reports\GSTBill-Half.rpt”) ‘ RPT put in bin folder. Dim My_Connection As SqlConnection Dim my_Command As New SqlCommand Dim my_DataAdapter As New SqlDataAdapter Dim my_DataSource As New dsBillingSoft ‘XSD file Name here Dim ds As DataSet = New DataSet My_Connection = New SqlConnection(CnString)

Read More

MS-SQL Date Formats

Standard Date Formats Date Format Standard SQL Statement Sample Output Mon DD YYYY 1 HH:MIAM (or PM) Default SELECT CONVERT(VARCHAR(20), GETDATE(), 100) Jan 1 2005 1:29PM 1 MM/DD/YY USA SELECT CONVERT(VARCHAR(8), GETDATE(), 1) AS [MM/DD/YY] 11/23/98 MM/DD/YYYY USA SELECT CONVERT(VARCHAR(10), GETDATE(), 101) AS [MM/DD/YYYY] 11/23/1998 YY.MM.DD ANSI SELECT CONVERT(VARCHAR(8), GETDATE(), 2) AS [YY.MM.DD] 72.01.01 YYYY.MM.DD

Read More