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.Data.SqlClient;

namespace WindowsFormsApplication1
{
    public partial class FormMain : Form
    {
        Button AddRec = new Button();
        BindingSource TR_Bind = new BindingSource();
        DataGridView TR_Grid = new DataGridView();
        Label AddRec_lbl = new Label();
        private Add_TR addTR_frm = new Add_TR();
        Button UpRec = new Button();
        Label UpRec_lbl = new Label();

        public FormMain()
        {
            AddRec = new Button();
            AddRec.Size = new Size(30, 30);
            AddRec.Location = new Point(10, 200);

            UpRec = new Button();
            UpRec.Size = new Size(30, 30);
            UpRec.Location = new Point(10, 400);

            AddRec_lbl = new Label();
            AddRec_lbl.Text = "Add new TR";
            AddRec_lbl.Location = new Point(60, 200);

            UpRec_lbl = new Label();
            UpRec_lbl.Text = "Update TR";
            UpRec_lbl.Location = new Point(60, 400);

            TR_Grid.Dock = DockStyle.Fill;

            SplitContainer sc = new SplitContainer();
            sc.Dock = DockStyle.Fill;
            sc.Orientation = Orientation.Horizontal;
            sc.Panel1.Controls.Add(TR_Grid);


            InitializeComponent();

            this.Controls.Add(AddRec);
            this.Controls.Add(AddRec_lbl);
            this.Controls.Add(sc);
            this.Controls.Add(UpRec);
            this.Controls.Add(UpRec_lbl);

            this.Load +=new EventHandler(FormMain_Load);

            AddRec.Click +=new EventHandler(AddRec_Click);
            AddOwnedForm(addTR_frm);

            UpRec.Click +=new EventHandler(UpRec_Click);

        }

        private void FormMain_Load(object sender, EventArgs e)
        {
            TR_Grid.DataSource = TR_Bind;
            string connString =
            @"server=.\SQLExpress;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\warranty.mdf;Database=warranty;Trusted_Connection=Yes";
            SqlConnection conn = new SqlConnection(connString);
            DataSet wrtydataset = new DataSet();

            SqlDataAdapter TRadapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand("select * from TR", conn);
            TRadapter.SelectCommand = command;
            TRadapter.Fill(wrtydataset, "TR");

            TR_Bind.DataSource = wrtydataset;
            TR_Bind.DataMember = "TR";
            TR_Grid.AutoResizeColumns();
        }

        private void AddRec_Click(object sender, EventArgs e)
        {
            addTR_frm.ShowDialog();
        }

        private void UpRec_Click(object sender, EventArgs e)
        {
            SqlCommandBuilder RecUpCom = new SqlCommandBuilder(TRadapter);

        }
    }
}

namespace WindowsFormsApplication1
{
    public partial class FormMain : Form
    {
        Button AddRec = new Button();
        BindingSource TR_Bind = new BindingSource();
        DataGridView TR_Grid = new DataGridView();
        Label AddRec_lbl = new Label();
        private Add_TR addTR_frm = new Add_TR();
        Button UpRec = new Button();
        Label UpRec_lbl = new Label();
        DataSet wrtydataset = new DataSet();
        SqlDataAdapter TRadapter = new SqlDataAdapter();