Form Main

FORM MAIN
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace Modul_9_10
{
    public partial class frmMain : Form
    {
        public frmMain()
        {
            InitializeComponent();
        }

        SqlConnection con;
        string constr;
        SqlDataAdapter da;
        SqlCommand cmd;
        string query;
        DataSet ds;

        private void Koneksi()
        {
            constr = "Data Source = localhost; Initial Catalog = Logistic; Integrated Security = true";
            con = new SqlConnection(constr);
            con.Open();
        }

        private void LoadDataProduct()
        {
            ds = new DataSet();
            query = "SELECT * FROM Product";
            cmd = new SqlCommand(query, con);
            da = new SqlDataAdapter(cmd);
            da.Fill(ds, "Product");
        }

        private void frmMain_Load(object sender, EventArgs e)
        {
            this.IsMdiContainer = true;
            this.WindowState = FormWindowState.Maximized;
            stbWaktu.Text = DateTime.Now.ToString();
            timWaktu.Interval = 1000;
            timWaktu.Enabled = true;
            Koneksi();
        }

        private void timWaktu_Tick(object sender, EventArgs e)
        {
            stbWaktu.Text = DateTime.Now.ToString();
        }

        private void mnuMasterProduct_Click(object sender, EventArgs e)
        {
            Master.frmProduct mstProduct = new Master.frmProduct();
            mstProduct.MdiParent = this;
            mstProduct.Show();
        }

        private void mnuMasterVendor_Click(object sender, EventArgs e)
        {
            Master.frmVendor mstVendor = new Master.frmVendor();
            mstVendor.MdiParent = this;
            mstVendor.Show();
        }

        private void mnuTransactionPurchasing_Click(object sender, EventArgs e)
        {
            Transaction.frmPurchasing tscPurchasing = new Transaction.frmPurchasing();
            tscPurchasing.MdiParent = this;
            tscPurchasing.Show();
        }

        private void mnuTransactionSales_Click(object sender, EventArgs e)
        {
            Transaction.frmSales tscSales = new Transaction.frmSales();
            tscSales.MdiParent = this;
            tscSales.Show();
        }

        private void mnuTransactionInventory_Click(object sender, EventArgs e)
        {
            Transaction.frmInventory tscInventory = new Transaction.frmInventory();
            tscInventory.MdiParent = this;
            tscInventory.Show();
        }

        private void mnuReportProduct_Click(object sender, EventArgs e)
        {
            Report.crProduct cr = new Report.crProduct();
            Report.frmViewer viewer = new Report.frmViewer();
            LoadDataProduct();
            cr.SetDataSource(ds);
            viewer.crystalReportViewer1.ReportSource = cr;
            viewer.WindowState = FormWindowState.Maximized;
            viewer.Show();
        }
    }
}