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
Sunday, October 27, 2013
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
Monday, October 14, 2013
Insert, Update
Insert :
Insert myTable(myField1, myField2,myField3) values ('Value1','Value2','Value3')
Update :
Update myTable set myField = newValue where myKey = myKeyField
Insert myTable(myField1, myField2,myField3) values ('Value1','Value2','Value3')
Update :
Update myTable set myField = newValue where myKey = myKeyField
SaveToolStripButton
Save with SaveToolStripButton
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
In form mdiChild
Public Class frmChangePassword
Public Sub Save()
Dim Query As String
Dim sDB = New sqlDB
Query = "insert jnsbrg(kelomp_brg,nm_jns_brg) VALUES ('"
Query = Query + txtKelomp_Brg.Text + "','" + txtNm_Jns_Brg.Text + "')"
sDB.executeSQL(Query)
MDIParent1.SaveToolStripButton.Enabled = False
MDIParent1.NewToolStripButton.Enabled = True
End Sub
End Class
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
In form mdiChild
Public Class frmChangePassword
Public Sub Save()
Dim Query As String
Dim sDB = New sqlDB
Query = "insert jnsbrg(kelomp_brg,nm_jns_brg) VALUES ('"
Query = Query + txtKelomp_Brg.Text + "','" + txtNm_Jns_Brg.Text + "')"
sDB.executeSQL(Query)
MDIParent1.SaveToolStripButton.Enabled = False
MDIParent1.NewToolStripButton.Enabled = True
End Sub
End Class
Standardized Naming Conventions for Visual Basic .NET
When you’re programming, names are important. If you’re programming with Visual Basic .NET, the following table can be a major help in getting the names right. It gives the common prefix to use when naming objects so you can quickly tell your check boxes from your combo boxes and your radio buttons from your record sets.
| Prefix | Corresponding Object | Example | Prefix | Corresponding Object | Example |
|---|---|---|---|---|---|
| Acd | ActiveDoc | AcdMainPage | Hpl | HyperLink | HplURL |
| Chk | CheckBox | ChkBoldface | Lbl | Label | LblContents |
| Cbo | ComboBox | CboDropper | Lst | ListBox | LstNames |
| Cm | ADO command (database) | CmMyCommand | Pag | Page | PagTurn |
| Cmd | CommandButton | CmdExit | Pgf | PageFrame | PgfRule |
| Cmg | CommandGroup | CmgSelectOne | Prj | ProjectHook | PrjSuzerine |
| Cn | Connection (database) | CnMyConnex | Rb | RadioButton | RbBlueBackground |
| Con | Container | CntFramed | Rs | Recordset (database) | RsTotalSales |
| Ctr | Control | CtlSeeThis | Sep | Separator | SepZone |
| Fld | Field (database) | FldTitles | Spn | Spinner | SpnWatch |
| Frm | Form | FrmColors | Txt | TextBox | TxtAddress |
| Frs | FormSet | FrsTypeIn | Tmr | Timer | TmrAnimation |
| Grd | Grid | GrdGoods | Tbr | ToolBar | TbrDropThis |
| Grc | Column (in grid) | GrcQuantity | Tbl | Table (database) | TblTitles |
| Grh | Header (in grid) | GrhYearsResults |
Source : http://www.dummies.com/how-to/content/standardized-naming-conventions-for-visual-basic-n.html
Other link for naming conventions :
http://www.ssw.com.au/ssw/Standards/DeveloperdotNET/DotNetStandard_ObjectNaming.aspx
Other link for naming conventions :
http://www.ssw.com.au/ssw/Standards/DeveloperdotNET/DotNetStandard_ObjectNaming.aspx
Subscribe to:
Posts (Atom)