Author Archives: Nilesh

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

SMART OPD C# Windows Application

C# Windows Application SQL Server Visual Studio 10 Crystal Report Video SMART OPD C# Windows Application Expenses Management Medicine / Prescription Dosage Time and Days Patient Details Patient Bill Total Today’s patients Summery By Date Patient Report Expenses Report Patient Certificates Database Backup Facility Unicode Language Support Change Theme Hide / Show Summery  


Open the android manifest file (android/app/src/main/AndroidManifest.xml) and add android:usesCleartextTraffic=”true” to the application tag <application android:name=”io.flutter.app.FlutterApplication” android:label=”tangerine_ui” android:icon=”@mipmap/ic_launcher” android:usesCleartextTraffic=”true”>