<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
   assembly="Lab_KPT4" namespace="Lab_KPT4">
  <class name="Tovar" table="tovar">
    <id name="tovarid" column="Tovar_ID" type="Int32">
      <generator class="identity"/>
    </id>
    <property name="tname" column="TName" type="String"/>
    <property name="measure" column="Measure" type="String"/>
    <property name="bprice" column="Buying_Price" type="Double"/>
    <property name="sprice" column="Selling_Price" type="Double"/>
  </class>
  <class name="Postavshiki" table="postavshiki">
    <id name="suppid" column="Post_ID" type="Int32">
      <generator class="identity"/>
    </id>
    <property name="supname" column="Name" type="String"/>
    <property name="adress" column="Adress" type="String"/>
    <property name="phone" column="Phone" type="String"/>
  </class>
  <class name="PrivilegedUser" table="users">
    <id name="userid" column="user_id" type="Int32">
      <generator class="identity"/>
    </id>
    <property name="userLogin" column="login" type="String"/>
    <property name="userPass" column="password" type="String"/>
  </class>
</hibernate-mapping>

<?xml version='1.0' encoding='utf-8' ?>
  <hibernate-configuration>
    <session-factory xmlns="urn:nhibernate-configuration-2.2">
      <property name="connection.provider">
        NHibernate.Connection.DriverConnectionProvider
      </property>
      <property name="connection.driver_class">
        NHibernate.Driver.MySqlDataDriver
      </property>
      <property name="dialect">
        NHibernate.Dialect.MySQLDialect
      </property>
      <property name="connection.connection_string">
        Server=localhost;Database=Pirotek;User ID=root;Password=root;Pooling=false
      </property>
      <mapping resource="library.hbm.xml" assembly="Lab_KPT4" />
    </session-factory>
  </hibernate-configuration>

using System;
using System.Web;
using NHibernate;
using NHibernate.Cfg;

namespace Lab_KPT4
{
    public class Transport
    {
        private const string CurrentSessionKey = "nhibernate.current_session";
        private static readonly ISessionFactory sessionFactory;

        static Transport()
        {
            sessionFactory = new Configuration().Configure()
              .AddFile("hibernate.cfg.hml").BuildSessionFactory();
        }

        public static ISession GetCurrentSession()
        {
            HttpContext context = HttpContext.Current;
            ISession currentSession;
            if (context == null)
            {
                currentSession = sessionFactory.OpenSession();
            }
            else
            {
                currentSession = context.Items[CurrentSessionKey] as ISession;
                if (currentSession == null)
                {
                    currentSession = sessionFactory.OpenSession();
                    context.Items[CurrentSessionKey] = currentSession;
                }
            }
            return currentSession;
        }

        public static void CloseSession()
        {
            HttpContext context = HttpContext.Current;
            if (context == null)
            {
                return;
            }
            ISession currentSession = context.Items[CurrentSessionKey] as ISession;
            if (currentSession == null)
            {
                // No current session
                return;
            }
            currentSession.Close();
            context.Items.Remove(CurrentSessionKey);
        }

        public static void CloseSessionFactory()
        {
            if (sessionFactory != null)
            {
                sessionFactory.Close();
            }
        }
    }
}

        protected void TaskGridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            
            GridViewRow row = tgv.Rows[e.RowIndex];
            ISession session = Transport.GetCurrentSession();
            ITransaction tx = session.BeginTransaction();
            Tovar t = session.Get<Tovar>(Convert.ToInt32(row.Cells[0].Text)); 
            TextBox tb = row.Cells[1].FindControl("editName") as TextBox;
            t.tname = tb.Text;
            session.Update(t);
            tx.Commit();
            session.Flush();
            Transport.CloseSession();
            tgv.EditIndex = -1;
            tgv.DataBind();
            
        }