Selasa, 15 Desember 2015

Create a TreeView from a Database in Windows Forms and C#

Introduction

A TreeView control provides a way to display information in a hierarchical structure using nodes.

Root Node (Parent Node)

The top level nodes in a TreeView is called the Root nodes.

Child nodes

The root nodes (also known as parent nodes) can have nodes that can be viewed when they are expanded. These nodes are called child nodes. The user can expand a root node by clicking the plus sign (+) button.

Table Definitions

Parent Nodes

CREATE TABLE [dbo].[MNUPARENT](
               [MAINMNU] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
               [STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
               [MENUPARVAL] [int] IDENTITY(1,1) NOT NULL,
 CONSTRAINT [PK_MNUPARENT] PRIMARY KEY CLUSTERED
(
               [MENUPARVAL] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]Insert Sample Hierarchical Data
 
SET IDENTITY_INSERT MNUPARENT ON
GO

INSERT INTO MNUPARENT(MAINMNU, STATUS, MENUPARVAL) VALUES('Finanace','Y',1)
INSERT INTO MNUPARENT(MAINMNU, STATUS, MENUPARVAL) VALUES('Inventory','Y',2)

GO
SET IDENTITY_INSERT MNUPARENT OFF
GO

Child Nodes
 
CREATE TABLE [dbo].[MNUSUBMENU](
               [MENUPARVAL] [int] NOT NULL,
               [FRM_CODE] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
               [FRM_NAME] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
               [MNUSUBMENU] [int] NOT NULL,
               [STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
PRIMARY KEY CLUSTERED
(
               [MNUSUBMENU] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
N [PRIMARY]

Sample Insert Statements
 
INSERT INTO MNUSUBMENU(MENUPARVAL,FRM_NAME,MNUSUBMENU,STATUS) VALUES(1,'Child Finance',10,'Y')
INSERT INTO MNUSUBMENU(MENUPARVAL,FRM_NAME,MNUSUBMENU,STATUS) VALUES(1,'Accounting',20,'Y')
INSERT INTO MNUSUBMENU(MENUPARVAL,FRM_NAME,MNUSUBMENU,STATUS) VALUES(20,'Audit',30,'Y')
INSERT INTO MNUSUBMENU(MENUPARVAL,FRM_NAME,MNUSUBMENU,STATUS) VALUES(30,'Acc. Standards',40,'Y')

Alternatively, you can have a single table to maintain this data of parent and child nodes.

Now let us start a new project and populate the TreeView.
  1. Create a new project and name it LoadTreeView.

    Image1.jpg
     
  2. Set the form's Name Property to FrmTreeView and its Text Property to Populate TreeView.
  3. Add a tree view control to the form and set its dock property to Left
  4. To configure the connection settings of the Data Source add an application configuration File

    From Project -> "Add" -> "New Item..."

    Image2.jpg
     
  5. Paste the code below into the App.config File:<?xml version="1.0" encoding="utf-8" ?><configuration>
      <
    connectionStrings>
        <
    add name ="ConnString" connectionString ="Data Source=yourServerName; User Id =yourUserName; Password =yourPwd;" providerName ="System.Data.SqlClient"/>  </connectionStrings></configuration>

  6. To access the connection string from code add a reference to System.Configuration and add the namespace using System.Configuration.

    Image3.jpg
     
  7. In the form's Load Event paste the following code:
     
    String connectionString;
    connectionString = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;
    conn = new SqlConnection(connectionString);
    String Sequel = "SELECT MAINMNU,MENUPARVAL,STATUS FROM MNUPARENT";
    SqlDataAdapter da = new SqlDataAdapter(Sequel, conn);
    DataTable dt = new DataTable();
    conn.Open();
    da.Fill(dt);

    foreach (DataRow dr in dt.Rows)
    {
        parentNode = treeView1.Nodes.Add(dr["MAINMNU"].ToString());
        PopulateTreeView(Convert.ToInt32(dr["MENUPARVAL"].ToString()), parentNode);
    }treeView1.ExpandAll();
  8. The Treeview is populated with its child nodes using the PopulateTreeView Method we have defined as in the following:
     
    private void PopulateTreeView(int parentId, TreeNode parentNode)
    {
        String Seqchildc = "SELECT MENUPARVAL,FRM_NAME,MNUSUBMENU FROM MNUSUBMENU WHERE MENUPARVAL=" + parentId + "";
        SqlDataAdapter dachildmnuc = new SqlDataAdapter(Seqchildc, conn);
        DataTable dtchildc = new DataTable();
        dachildmnuc.Fill(dtchildc);
        TreeNode childNode;
        foreach (DataRow dr in dtchildc.Rows)
        {
            if (parentNode == null)
                childNode = treeView1.Nodes.Add(dr["FRM_NAME"].ToString());
            else
                childNode = parentNode.Nodes.Add(dr["FRM_NAME"].ToString()); 
                PopulateTreeView(Convert.ToInt32(dr["MNUSUBMENU"].ToString()), childNode);
        }}
  9. Build and run the program that results in the output shown in the following:

    Image4.jpg
     
  10. Add the following piece of code to the treeview Double-Click Event:
     
    private void treeView1_DoubleClick(object sender, EventArgs e)
    {
        MessageBox.Show(treeView1.SelectedNode.FullPath.ToString());}
  11. When you double-click a node on the Treeview control a message is displayed with the fullpath to the node. Here I have clicked the Acc. Standards node.

    Image5.jpg

    Program
     
    using System;
    using System.Collections.Generic;
    using System.ComponentModel;
    using System.Data;
    using System.Drawing;
    using System.Linq;
    using System.Text;
    using System.Windows.Forms;
    using System.Configuration;
    using System.Data.SqlClient;

    namespace LoadTreeView
    {
        public partial class FrmTreeView : Form
        {
            SqlConnection conn;
            TreeNode parentNode = null;
            public FrmTreeView()
            {
                InitializeComponent();
            }

            private void FrmTreeView_Load(object sender, EventArgs e)
            {
                String connectionString;
                connectionString = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;
                conn = new SqlConnection(connectionString);
                String Sequel = "SELECT MAINMNU,MENUPARVAL,STATUS FROM MNUPARENT";
                SqlDataAdapter da = new SqlDataAdapter(Sequel, conn);
                DataTable dt = new DataTable();
                conn.Open();
                da.Fill(dt);

                foreach (DataRow dr in dt.Rows)
                {
                    parentNode = treeView1.Nodes.Add(dr["MAINMNU"].ToString());
                    PopulateTreeView(Convert.ToInt32(dr["MENUPARVAL"].ToString()), parentNode);
                }

                treeView1.ExpandAll();
            }

            private void PopulateTreeView(int parentId, TreeNode parentNode)
            {
                String Seqchildc = "SELECT MENUPARVAL,FRM_NAME,MNUSUBMENU FROM MNUSUBMENU WHERE MENUPARVAL=" + parentId + "";
                SqlDataAdapter dachildmnuc = new SqlDataAdapter(Seqchildc, conn);
                DataTable dtchildc = new DataTable();
                dachildmnuc.Fill(dtchildc);
                TreeNode childNode;
                foreach (DataRow dr in dtchildc.Rows)
                {
                    if (parentNode == null)
                        childNode = treeView1.Nodes.Add(dr["FRM_NAME"].ToString());
                    else
                        childNode = parentNode.Nodes.Add(dr["FRM_NAME"].ToString());

                    PopulateTreeView(Convert.ToInt32(dr["MNUSUBMENU"].ToString()), childNode);
                }
            }

            private void treeView1_DoubleClick(object sender, EventArgs e)
            {
                MessageBox.Show(treeView1.SelectedNode.FullPath.ToString());
            }

        }
    }
Conclusion

In this article we have discussed how to populate a treeview dynamically in a C# application and display the entire path to the node on an event.


Source: http://www.c-sharpcorner.com/UploadFile/c5c6e2/populate-a-treeview-dynamically/

Jumat, 11 Desember 2015

Cara Atasi No Sound (Suara Hilang) Setelah Upgrade Windows 10

 Hasil gambar untuk no sound after windows 10 update
Upgrade Windows 10 yang di berikan secara gratis selama 1 tahun dari pihak Microsoft membuat mereka berbondong bondong untuk segera menginstallnya. Perlu pengorbanan waktu untuk dapat menikmati windows terbaru ini. Untuk ukuran file windows 10 yang berukuran sekiar 2.7 GB terhitung merupakan ukuran yang sangat besar. Proses upgrade ini sangat mudah, kita hanya tinggal ke menu windows update, dan pastikan semua update penting telah kamu install terutama bagi kamu pengguna windows 8.1 harus menginstall terlebih dahulu dua update penting yakni KB 3035583 dan KB2976978. Sehingga nanti di bagian bawah layar laptop akan muncul ikon  kecil muncul bernama Get Windows 10.
Proses upgrade terkadang ada beberapa permasalahan seperti yang saya alami ketika selesai melakukan proses upgrade ke Windows 10. Awalnya sangat khawatir, ketika memutar lagu dan video seluruh aplikasi dan media player yang berhubungan dengan sound dan video tidak dapat memutar lagu dan video. Selalu saja muncul peringatan aneh yang memaksa video tidak dapat di putar. 
Volume coba saya naikkan sampai ke level maksimal, namun tetap saja laptop tidak dapat mengeluarkan suara ketika saya main game. Sempat frustasi di buatnya, alhasil saya cari forum-forum mengenai permasalahan no sound di laptop saya. Ternyata bukan saya saja yang mengalami tapi memang ada banyak di luar sana. Singkat cerita akhirnya saya nemu jurusnya yakni cukup gampang dan ampuh. Berikut tahap-tahapnya.
1. Klik gambar sound yang terdapat pada kanan bawah layar laptopmu
2. Kemudian pilihlah menu Playback Device
3. Pilih Playback Device yang biasanya telah terpilih..lanjutkan double click sampai muncul Properties
4. Pilihlah tab Advance dan cobalah ubah bite rate ke yang lainnya sebagai contoh dari 24bit/44100 Hz  ke 24bit/192000Hz, ini semua tergantung pada konfigurasi speaker laptop kamu

5. Disana terdapat banyak pilihan setting cobalah satu persatu sembari mengecek suaranya
Melalui cara tersebut suara yang tadinya hilang kini kembali ke semula lagi. Untuk memutar lagu, video dan main game sudah dapat mengeluarkan suara dan berjalan lancar. Bagi kamu yang mengalami hal serupa ada baiknya kamu mencoba salah satu tips ini.
 
source: http://tiyogunners.blogspot.co.id/2015/09/cara-atasi-no-sound-suara-hilang.html