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
Visual Studio Developers
Sunday, November 17, 2013
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
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.
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 27, 2013
Microsoft Report Viewer with MySQL - VB.net
You can see this tutorial at youtube :
Part 1 :
http://www.youtube.com/watch?v=tuwZNSwTjEI
Part 2 :
http://www.youtube.com/watch?v=-Ic64qxWf0k
Part 1 :
http://www.youtube.com/watch?v=tuwZNSwTjEI
Part 2 :
http://www.youtube.com/watch?v=-Ic64qxWf0k
Sunday, October 20, 2013
RDLC Reporting Example
If you want create RDLC Reporting example, you can see in youtube :
http://www.youtube.com/watch?v=NVImPdRbVAs
http://www.youtube.com/watch?v=NVImPdRbVAs
Tuesday, October 15, 2013
Rdlc
Rdlc, yes. This name for pure report from Visual Studio.
Report Designer (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
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”
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
Source : http://scn.sap.com/docs/DOC-35074
Subscribe to:
Posts (Atom)