Sunday, November 17, 2013

IsDBNull

        If IsDBNull(DataGridView1.CurrentRow.Cells(0).Value) Then
            txtKd_Aktiva.Text = ""
            txtKd_Dept.Text = ""

        Else
            txtKd_Aktiva.Text = DataGridView1.CurrentRow.Cells(0).Value
            txtKd_Dept.Text = DataGridView1.CurrentRow.Cells(1).Value
        End If

Wednesday, November 13, 2013

ToolStrip Collect Command

-- save
    Private Sub SaveToolStripButton_Click(sender As Object, e As EventArgs) Handles SaveToolStripButton.Click
        Dim frm As Object = Me.ActiveMdiChild
        If frm Is Nothing Then Return
        Call frm.save()
    End Sub

--delete

    Private Sub DeleteToolStripButton_Click(sender As Object, e As EventArgs) Handles DeleteToolStripButton.Click
        If MsgBox("Are you sure want to Delete?", MsgBoxStyle.YesNo, "Delete") = MsgBoxResult.Yes Then
            Dim frm As Object = Me.ActiveMdiChild
            If frm Is Nothing Then Return
            Call frm.delete()
        Else
            MsgBox("You aren't deleted")
        End If
    End Sub

--filter
    Private Sub FilterToolStripButton_Click(sender As Object, e As EventArgs) Handles FilterToolStripButton.Click
        Dim frm As Object = Me.ActiveMdiChild
        If frm Is Nothing Then Return
        Call frm.Filter()
    End Sub

Saturday, November 2, 2013

Convert Dbf to MySQL

Step by step for convert Dbf to MySql

1. Convert Dbf to Xls with Foxpro command. Example for copy file ledger.dbf to ledger.xls, you can used this script "Copy to ledger type xls".
2. Convert Xls to Mdb Online with zamzar.com.
3. Convert Mdb to Sql with MySQL Migration Toolkit.
4. Create table ledger in database  MySql.
5. Import table from step 3.


Sunday, October 20, 2013

Tuesday, October 15, 2013

Rdlc

Rdlc, yes. This name for pure report from Visual Studio.

Report Designer (Visual Studio)


The Visual Studio Report Designer provides a user-friendly interface for creating robust reports that include data from multiple types of data sources.
In Visual Studio, reports are saved as client report definition (.rdlc) files. These files are based on the same schema as report definition (.rdl) files published on SQL Server Reporting Services report servers, but they are stored and processed differently than .rdl files. At run time, the .rdlc files are processed locally, and the .rdl files are processed remotely.

Source : http://msdn.microsoft.com/en-us/library/bb558708.aspx

SAP Crystal Reports, developer version for Microsoft Visual Studio - 2012 Now Available for Download

New In This Release

        New branding for the product; 
      Now called “SAP Crystal Reports, developer version for Microsoft Visual Studio”
    
      Support integration with Visual Studio 2012 and 4.5 .NET Framework runtime.
        Added support for following platforms:
a.        OS:  Windows 7 SP1, Windows 8, Windows 2012
b.       Database: SQL Server 2012, HANA SP5
c.        Web Browser:  Firefox 16, IE10 (limited support; more information forthcoming soon)
d.       Other technology: IIS 8, Flash 11

Download Locations





PLEASE NOTE:
Any queries, issues, problems, etc., should be posted as a Discussion in the SAP Crystal Reports, version for Visual Studio Space. Queries posted as Comments will not be answered.

Source : http://scn.sap.com/docs/DOC-35074