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();
        Button UpRec = new Button();
        BindingSource TR_Bind = new BindingSource();
        DataGridView TR_Grid = new DataGridView();
        Label AddRec_lbl = new Label();
        Label UpRec_lbl = new Label();
        private Add_TR addTR_frm = new Add_TR();
        DataSet wrtydataset = new DataSet();
        SqlDataAdapter TRadapter = new SqlDataAdapter();

        public FormMain()
        {

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

            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(UpRec);
            this.Controls.Add(sc);           
            this.Load +=new EventHandler(FormMain_Load);

            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");
            DataTable TR_tbl = wrtydataset.Tables.Add("TR_tbl");
            
            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)
        {
            this.Validate();
            this.TR_Bind.EndEdit();
            this.TRadapter.Update(wrtydataset.Tables[0]);
        }