Database

<br />
namespace SimpleNHibernate<br />
{<br />
	<br />
	class Tester<br />
	{<br />
		<br />
		[STAThread]<br />
		static void Main(string[] args)<br />
		{<br />
			User usr;<br />
<br />
			Configuration config = new Configuration();<br />
			ISessionFactory factory = config.BuildSessionFactory();<br />
			ISession session = factory.OpenSession();<br />
			ITransaction transaction = session.BeginTransaction();<br />
<br />
			try {<br />
				config.AddClass(typeof(SimpleNHibernate.User));<br />
<br />
				for(int i=0; i<50; i++) {<br />
					usr = new User();<br />
					usr.Id="user" +i;<br />
					usr.UserName = "user" +i;<br />
					usr.Password = "testing";<br />
					usr.EmailAddress = "testing@testing.com";<br />
					usr.LastLogon = DateTime.Now;<br />
<br />
					session.Save(usr);<br />
					session.Flush();<br />
<br />
					Console.WriteLine(i);<br />
				}<br />
<br />
				transaction.Commit();<br />
<br />
			} catch(Exception ex) {<br />
				transaction.Rollback();<br />
				Console.WriteLine(ex);<br />
				Console.WriteLine(ex.Message);<br />
			} finally {<br />
				if (session!=null) {<br />
					try {<br />
						session.Close();<br />
					} catch(Exception ignored) {<br />
					}<br />
				}<br />
			}<br />
<br />
			return;<br />
		}<br />
	}<br />
}

public void Edit_User(object sender, DataListCommandEventArgs e)<br />
		{<br />
			userList.EditItemIndex = e.Item.ItemIndex;<br />
			userList.DataBind();<br />
		}<br />
<br />
		public void Update_User(object sender, DataListCommandEventArgs e)<br />
		{<br />
			string txtCustFirstNameEdit = ((TextBox)e.Item.FindControl("txtUserFirstNameEdit")).Text;<br />
			string UserKey = userList.DataKeys[e.Item.ItemIndex].ToString();<br />
			<br />
			message.Text = UserKey;<br />
			message1.Text = txtCustFirstNameEdit;<br />
			<br />
			OleDbConnection userListConnection = new OleDbConnection(@.....");<br />
<br />
			//StringBuilder custUpdateBuild = new StringBuilder();<br />
			//custUpdateBuild.Append("UPDATE custInfo SET custFirstName = ('");<br />
			//custUpdateBuild.Append(txtCustFirstNameEdit);<br />
			//custUpdateBuild.Append("') WHERE ID= ('");<br />
			//custUpdateBuild.Append(UserKey);<br />
			//custUpdateBuild.Append("')");<br />
			//string oleUpdateString = custUpdateBuild.ToString();<br />
<br />
			string oleUpdateString = "UPDATE custinfo SET custFirstName = "+"'"+txtCustFirstNameEdit+"'";<br />
			oleUpdateString += " WHERE ID = " + UserKey;<br />
			OleDbDataAdapter userUpdateAdapter = new OleDbDataAdapter();<br />
			userUpdateAdapter.UpdateCommand = new OleDbCommand(oleUpdateString, userListConnection);<br />
			userListConnection.Open();<br />
			userUpdateAdapter.Update(userListDataSet, "custInfo");<br />
			userListConnection.Close();<br />
<br />
			userList.EditItemIndex = -1;<br />
			userList.DataBind();<br />
<br />
			<br />
		}