Master Detail - Simple Sample

Master Detail dibutuhkan untuk menyimpan data / informasi yang saling berhubungan antar beberapa Tabel dalam database. Biasanya informasi di Master/Header berisi informasi/data global, sedangkan untuk detailnya berisi informasi/data yang lebih terperinci.

Dalam contoh ini , saya hanya membuat sample program yang sangat sederhana tetapi setidaknya sudah menggambarkan dari Master Detail tersebut.
Beberapa hal yang penting disini adalah :
1. Membuat Table On The Fly
2. Menghubungkan antara control (TextBox) dengan gridview
3. Menampilkan Data ke Gridview dan manipulasi data di Grid
4. Mengambil nilai di GridView dan menampilkannya ke Control (TextBox)
5. Dan lainnya

Dalam contoh di atas, seperti permintaan dari beberapa rekan sekalian, yaitu bagaimana memasukkan TextBox (No Trans) kedalam GridView, kemudian menampilkan hasil Total di GridView (Value) ke dalam TextBox pada saat Runtime (seperti program POS / Cashier).


Mudah-mudahan dapat menjawab beberapa pertanyaan dari rekan-rekan sekalian.

Salam
Udin Sofyan


Download
MasterDetail

Microsoft® SQL Server® 2012 Evaluation

 Microsoft SQL Server 2012 enables a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization.

File name	Size
ENU\SQLFULL_ENU.iso	4.2 GB	Download
ENU\x64\SQLFULL_x64_ENU_Core.box	1.8 GB	Download
ENU\x64\SQLFULL_x64_ENU_Install.exe	94 KB	Download
ENU\x64\SQLFULL_x64_ENU_Lang.box	655.8 MB	Download
ENU\x86\SQLFULL_x86_ENU_Core.box	1.6 GB	Download
ENU\x86\SQLFULL_x86_ENU_Install.exe	94 KB	Download
ENU\x86\SQLFULL_x86_ENU_Lang.box	642.0 MB	Download

Overview

Microsoft SQL Server 2012 enables a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization as well as quickly build solutions and extend data across on-premises and public cloud backed by capabilities for mission critical confidence.

• Deliver required uptime and data protection with AlwaysOn
• Gain breakthrough & predictable performance with ColumnStore Index
• Help enable security and compliance with new User-defined Roles and Default Schema for Groups
• Enable rapid data discovery for deeper insights across the organization with ColumnStore Index
• Ensure more credible, consistent data with SSIS improvements, a Master Data Services add-in for Excel, and new Data Quality Services
• Optimize IT and developer productivity across server and cloud with Data-tier Application Component (DAC) parity with SQL Azure and SQL Server Data Tools for a unified dev experience across database, BI, and cloud functions

Microsoft SQL Server 2012 Documentation:

• What's new in Microsoft SQL Server 2012
• Microsoft SQL Server 2012 Privacy Statement
• Microsoft SQL Server 2012 License Terms
• Microsoft SQL Server 2012 Systems Requirements
• Microsoft SQL Server 2012 Release Notes
• Microsoft SQL Server 2012 Readme

Note:

1. This fully functional trial software will automatically expire after six months. You can obtain the fully licensed version at any time. For information about the different editions of Microsoft® SQL Server® 2012, see the see the Editions page.
2. Some components in this release have certain Internet-enabled features, including the Customer Experience Improvement Program and Error and Usage Reporting component, enabled by default to help us identify and address issues that you may encounter while using SQL Server. For more information and instructions on how to disable these features, see the Microsoft SQL Server 2012 Privacy Statement.
3. Some components in this software have two different methods to complete the installation process:
• Attended Installation – an interactive user interface will guide you through the set-up process and obtain all of the information and consent required to complete the installation. This includes displaying, acknowledgement, and archiving of the applicable SQL Server license terms.


• Unattend Installation – this is a command line set-up process that does not have an interactive user interface to guide you through the set-up process. In this case, you will be required to enter a parameter during installation that indicates your acceptance of the license terms 

System requirements

Supported operating systems: Windows 7, Windows Server 2008 R2, Windows Server 2008 Service Pack 2, Windows Vista Service Pack 2

• 32-bit systems
• Computer with Intel or compatible 1GHz or faster processor (2 GHz or faster is recommended.)
• 64-bit systems
• 1.4 GHz or faster processor
• Minimum of 1 GB of RAM (2 GB or more is recommended.)
• 2.2 GB of available hard disk space

Detail :
http://www.microsoft.com/download/en/details.aspx?id=29066
http://www.microsoft.com/sqlserver/en/us/sql-2012-editions.aspx

DevExpress 2011.2.11

FOR VISUAL STUDIO 2008/2010

After more than 30 releases in 180 countries, the next big thing for developers is here. We call it DXv2. Continuing the bridge from your technology position to where you want to be and taking a bold step into the

Touch-Enabled Bring your software to life with intelligent touch-based applications. Use your existing development skills to tap into the growing demand for stunning tablet & touch-enabled apps across all platforms, including WinForms, WPF and ASP.NET. Build for today as you begin to re-imagine business applications for the Windows 8 Metro design aesthetic. DXv2 delivers the gestures, themes, and controls to put Touch within your reach, right now.

Visually Stunning Today’s customers want smart, beautiful apps in every part of their lives, from work to home. Now, with the tools from DevExpress, you can build them better than ever. Apply sophisticated themes, create your own, and even integrate your corporate brand. Incorporate elegant office-inspired or business intelligence dashboard controls into your design so your users can view and manipulate data in more insightful and compelling ways. And do it all on the platforms you know best. DXv2 delivers the tools you need to inspire and be inspired by application design.

Productivity + Creativity Never sacrifice one for the other again. CodeRush helps you build and manage your complex code base allowing more time to focus on your business logic. Fewer keystrokes and clicks on the way to quickly building gorgeous, high-performance apps. The eXpressApp Framework (XAF) delivers a powerful, modular application framework that helps you bring robust enterprise applications to market, faster. These are the developer tools you expect from the company you know and trust. This is DXv2—designed to help you use your time, skills, and creativity for what truly matters.

Your free trial of the Enterprise Subscription

Named the Best Software Development Tool by judges at the 2011 TechEd Conference, this 30-day free trial includes over 300 individual controls, libraries, and extensions.

http://www.devexpress.com/

For VS2010 .NET Documentation Installer (498 Mb)
http://downloads.devexpress.com/Help/DXperienceHelp2010-11.2.11.exe

For VS2008 .NET Documentation Installer (422 Mb)
http://downloads.devexpress.com/Help/DXperienceHelp2008-11.2.11.exe


What's new
http://www.devexpress.com/Support/WhatsNew/DXperience/files/11.2.11.xml