C#

<br />
     this.bindingSource.DataSource = this.dataTable;<br />
     this.bindingSource.DataSource = null;<br />
     this.bindingSource.Dispose();<br />
/*<br />
Fill method read data by using data reader for this table.<br />
When this table contains many records (about 150000) this operation (Fill) consume about 1 minute.<br />
*/<br />
     this.dataTable.Fill();<br />

<br />
/*<br />
     this.bindingSource.DataSource = this.dataTable;<br />
     this.bindingSource.DataSource = null;<br />
     this.bindingSource.Dispose();<br />
*/<br />
Now i comment all code above, and supposingly this don't have any matter as such as i just return <br />
all to initiali state. BUT Now this operation (Fill) consume about <big>30 seconds</big>.<br />
*/<br />
     this.dataTable.Fill();<br />

//1) Load the Xml document <br />
        XPathDocument myXPathDoc = new XPathDocument("C:\\SSW55P12902365.XML");<br />
    <br />
        //2) Load the Xsl file <br />
        XslCompiledTransform myXslTrans = new XslCompiledTransform();<br />
        //XslTransform myXslTrans = new XslTransform();<br />
        myXslTrans.Load("C:\\Style.xsl");<br />
         <br />
        //3) Create a stream for output <br />
        XmlTextWriter myWriter = new XmlTextWriter("http://www.SpecifiedURL/SSW55P12902365.html", null);<br />
         <br />
        //4) Perform the actual transformation <br />
        myXslTrans.Transform(myXPathDoc,null,myWriter);

<br />
private void BtnSave_Click(object sender, EventArgs e)<br />
        {<br />
            method();<br />
        }<br />
<br />
        private void dataGridView_CellEndEdit(object sender, DataGridViewCellEventArgs e)<br />
        {<br />
            save = true;<br />
        }<br />
<br />
        private void FrmTimeCategories_FormClosing(object sender, FormClosingEventArgs e)<br />
        {<br />
            if (save)<br />
            {<br />
                string option = MessageBox.Show("Would You Like To Save The Changes?", "Question", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question).ToString();<br />
<br />
                if (option == "Yes")<br />
                {<br />
                    method();<br />
                }<br />
                else if (option == "No")<br />
                {<br />
                    MessageBox.Show("Changes Will Be Lost");<br />
                }<br />
                else if (option == "Cancel")<br />
                {<br />
                    e.Cancel = true;<br />
                }<br />
            }<br />
            save = false;<br />
        }<br />
<br />
        private void btnDeleteRow_Click(object sender, EventArgs e)<br />
        {<br />
            foreach (DataGridViewRow row in dataGridView.SelectedRows)<br />
            {<br />
                TimeCatTable.Rows[row.Index].Delete();<br />
            }<br />
            <br />
            TimeCatTable.AcceptChanges();<br />
            SqlCommandBuilder sqlBuilder = new SqlCommandBuilder(dataAdapter);<br />
            dataAdapter.Update(dataSet, "TimeCat");<br />
        }<br />
<br />
        public void method()<br />
        {<br />
            SqlCommandBuilder sqlBuilder = new SqlCommandBuilder(dataAdapter);<br />
            dataAdapter.Update(dataSet, "TimeCat");<br />
<br />
            save = false;<br />
        }<br />