private void UpRec_Click(object sender, EventArgs e)
        {
            if (wrtydataset.HasChanges(DataRowState.Modified))
            {
                this.Validate();
                this.TR_Bind.EndEdit();
                string connString =
                @"server=.\SQLExpress;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\warranty.mdf;Database=warranty;Trusted_Connection=Yes";
                using (SqlConnection connup = new SqlConnection(connString))
                {
                    SqlDataAdapter upadapter = new SqlDataAdapter("select * from TR", connup);

                    upadapter.UpdateCommand = new SqlCommand("update TR set TR_subject=@TR_subj, PFP = @PFP where UpInd = '1'", connup);

                    SqlParameter subjparameter = upadapter.UpdateCommand.Parameters.Add("@TR_subj", SqlDbType.Text);
                    subjparameter.SourceColumn = "TR_subject";
                    subjparameter.SourceVersion = DataRowVersion.Original;

                    SqlParameter pfpparameter = upadapter.UpdateCommand.Parameters.Add("@PFP", SqlDbType.Char);
                    pfpparameter.SourceColumn = "PFP";
                    pfpparameter.SourceVersion = DataRowVersion.Original;

                    DataTable TR_tbl = new DataTable();
                    upadapter.Fill(TR_tbl);

                    upadapter.Update(TR_tbl);
                    MessageBox.Show("Records succesfully updated");
                }
            }
            else
            {
                MessageBox.Show("No changes");
            }
        }