/*
               File: AccountDataSet
        Description: Account
             Author: DeKlarit - Language C# - Generator Version 1_1_0.046 - Specifier Version 1_2_0.001
       Generated on: August 5, 2002 16:39:7.46
       Program type: Deklarit Business Component
          Main DBMS: sqlserver
*/
namespace DklPetShop 
{
	using System;
	using System.Collections;
	using System.Data;
	using System.Data.SqlClient;
	using System.ComponentModel.Design;
	using System.Xml;
   #region "Dataset"
	[System.ComponentModel.DesignerAttribute("Deklarit.Designer.BCDesigner, DKDesigner")]
	public class AccountDataSet : System.Data.DataSet
	{
		private AccountDataTable tableAccount ;
		[System.ComponentModel.DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Content)]
		public AccountDataTable Account
		{
			get 
			{
				return this.tableAccount ;
			}

		}

		public  AccountDataSet( )
		{
			this.InitClass( ) ;
		}

		protected override System.Xml.Schema.XmlSchema GetSchemaSerializable() 
		{
			System.IO.MemoryStream stream = new System.IO.MemoryStream();
			this.WriteXmlSchema(new XmlTextWriter(stream, null));
			stream.Position = 0;
			return System.Xml.Schema.XmlSchema.Read(new XmlTextReader(stream), null);
		}
       
		protected override void ReadXmlSerializable(XmlReader reader) 
		{
			this.Reset();
			DataSet ds = new DataSet();
			ds.ReadXml(reader);
			if ((ds.Tables["Account"] != null)) 
			{ 
				this.Tables.Add(new AccountDataTable(ds.Tables["Account"])); 
			}
			this.DataSetName = ds.DataSetName;
			this.Prefix = ds.Prefix;
			this.Namespace = ds.Namespace;
			this.Locale = ds.Locale;
			this.CaseSensitive = ds.CaseSensitive;
			this.EnforceConstraints = ds.EnforceConstraints;
			this.Merge(ds, false, System.Data.MissingSchemaAction.Add);
			this.InitVars();
		}
      
		private void InitClass( )
		{
			this.DataSetName = "AccountDataSet" ;
			this.tableAccount = new AccountDataTable() ;
			this.Tables.Add( this.tableAccount) ;
		}

		public override DataSet Clone( )
		{
			AccountDataSet cln = ((AccountDataSet)(base.Clone())) ;
			cln.InitVars( ) ;
			return cln ;
		}

		internal void InitVars( )
		{
			this.tableAccount = ((AccountDataTable)(this.Tables["Account"])) ;
			if ( ( this.tableAccount != null ) )
			{
				this.tableAccount.InitVars( ) ;
			}
		}

		protected override bool ShouldSerializeTables( )
		{
			return false ;
		}

		protected override bool ShouldSerializeRelations( )
		{
			return false ;
		}

		private bool ShouldSerializeAccount( )
		{
			return false ;
		}

		public delegate  void AccountRowChangeEventHandler( object sender ,
			AccountRowChangeEvent e );
		public class AccountDataTable : DataTable, System.Collections.IEnumerable
		{
			private DataColumn columnUserId ;
			private DataColumn columnUserEmail ;
			private DataColumn columnUserFirstNAme ;
			private DataColumn columnUserLastName ;
			private DataColumn columnUserStatus ;
			private DataColumn columnUserAddr1 ;
			private DataColumn columnUserAddr2 ;
			private DataColumn columnUserCity ;
			private DataColumn columnUserState ;
			private DataColumn columnUserZip ;
			private DataColumn columnUserCountry ;
			private DataColumn columnUserPhone ;
			private DataColumn columnPassword ;
			private DataColumn columnLangPref ;
			private DataColumn columnFavCategory ;
			private DataColumn columnMyListOpt ;
			private DataColumn columnBannerOpt ;
			internal  AccountDataTable( ) : base("Account")
			{
				this.InitClass( ) ;
			}

			internal  AccountDataTable( DataTable table ) : base(table.TableName)
			{
				if ( ( table.CaseSensitive != table.DataSet.CaseSensitive ) )
				{
					this.CaseSensitive = table.CaseSensitive ;
				}
				if ( ( table.Locale.ToString() != table.DataSet.Locale.ToString() ) )
				{
					this.Locale = table.Locale ;
				}
				if ( ( table.Namespace != table.DataSet.Namespace ) )
				{
					this.Namespace = table.Namespace ;
				}
				this.Prefix = table.Prefix ;
				this.MinimumCapacity = table.MinimumCapacity ;
				this.DisplayExpression = table.DisplayExpression ;
			}

			public int Count
			{
				get 
				{
					return this.Rows.Count ;
				}

			}

			public DataColumn UserIdColumn
			{
				get 
				{
					return this.columnUserId ;
				}

			}

			public DataColumn UserEmailColumn
			{
				get 
				{
					return this.columnUserEmail ;
				}

			}

			public DataColumn UserFirstNAmeColumn
			{
				get 
				{
					return this.columnUserFirstNAme ;
				}

			}

			public DataColumn UserLastNameColumn
			{
				get 
				{
					return this.columnUserLastName ;
				}

			}

			public DataColumn UserStatusColumn
			{
				get 
				{
					return this.columnUserStatus ;
				}

			}

			public DataColumn UserAddr1Column
			{
				get 
				{
					return this.columnUserAddr1 ;
				}

			}

			public DataColumn UserAddr2Column
			{
				get 
				{
					return this.columnUserAddr2 ;
				}

			}

			public DataColumn UserCityColumn
			{
				get 
				{
					return this.columnUserCity ;
				}

			}

			public DataColumn UserStateColumn
			{
				get 
				{
					return this.columnUserState ;
				}

			}

			public DataColumn UserZipColumn
			{
				get 
				{
					return this.columnUserZip ;
				}

			}

			public DataColumn UserCountryColumn
			{
				get 
				{
					return this.columnUserCountry ;
				}

			}

			public DataColumn UserPhoneColumn
			{
				get 
				{
					return this.columnUserPhone ;
				}

			}

			public DataColumn PasswordColumn
			{
				get 
				{
					return this.columnPassword ;
				}

			}

			public DataColumn LangPrefColumn
			{
				get 
				{
					return this.columnLangPref ;
				}

			}

			public DataColumn FavCategoryColumn
			{
				get 
				{
					return this.columnFavCategory ;
				}

			}

			public DataColumn MyListOptColumn
			{
				get 
				{
					return this.columnMyListOpt ;
				}

			}

			public DataColumn BannerOptColumn
			{
				get 
				{
					return this.columnBannerOpt ;
				}

			}

			public AccountRow this[int index]
			{
				get 
				{
					return ((AccountRow)(this.Rows[index])) ;
				}

			}

			public event  AccountRowChangeEventHandler AccountRowChanged ;
			public event  AccountRowChangeEventHandler AccountRowChanging ;
			public event  AccountRowChangeEventHandler AccountRowDeleted ;
			public event  AccountRowChangeEventHandler AccountRowDeleting ;
			public void AddAccountRow( AccountRow row )
			{
				this.Rows.Add( row) ;
			}

			public AccountRow AddAccountRow( String userId ,
				String userEmail ,
				String userFirstNAme ,
				String userLastName ,
				String userStatus ,
				String userAddr1 ,
				String userAddr2 ,
				String userCity ,
				String userState ,
				String userZip ,
				String userCountry ,
				String userPhone ,
				String password ,
				String langPref ,
				String favCategory ,
				int myListOpt ,
				int bannerOpt )
			{
				AccountRow rowAccountRow = ((AccountRow)(this.NewRow())) ;
				rowAccountRow.ItemArray = new   Object[]  {userId,userEmail,userFirstNAme,userLastName,userStatus,userAddr1,userAddr2,userCity,userState,userZip,userCountry,userPhone,password,langPref,favCategory,myListOpt,bannerOpt} ;
				this.Rows.Add( rowAccountRow) ;
				return rowAccountRow ;
			}

			public AccountRow FindByUserId( String userId )
			{
				return ((AccountRow)(this.Rows.Find(new  Object[] {userId}))) ;
			}

			public System.Collections.IEnumerator GetEnumerator( )
			{
				return this.Rows.GetEnumerator() ;
			}

			public override DataTable Clone( )
			{
				AccountDataTable cln = ((AccountDataTable)(base.Clone())) ;
				cln.InitVars( ) ;
				return cln ;
			}

			internal void InitVars( )
			{
				this.columnUserId = this.Columns["UserId"] ;
				this.columnUserEmail = this.Columns["UserEmail"] ;
				this.columnUserFirstNAme = this.Columns["UserFirstNAme"] ;
				this.columnUserLastName = this.Columns["UserLastName"] ;
				this.columnUserStatus = this.Columns["UserStatus"] ;
				this.columnUserAddr1 = this.Columns["UserAddr1"] ;
				this.columnUserAddr2 = this.Columns["UserAddr2"] ;
				this.columnUserCity = this.Columns["UserCity"] ;
				this.columnUserState = this.Columns["UserState"] ;
				this.columnUserZip = this.Columns["UserZip"] ;
				this.columnUserCountry = this.Columns["UserCountry"] ;
				this.columnUserPhone = this.Columns["UserPhone"] ;
				this.columnPassword = this.Columns["Password"] ;
				this.columnLangPref = this.Columns["LangPref"] ;
				this.columnFavCategory = this.Columns["FavCategory"] ;
				this.columnMyListOpt = this.Columns["MyListOpt"] ;
				this.columnBannerOpt = this.Columns["BannerOpt"] ;
			}

			public void InitClass( )
			{
				this.columnUserId = new DataColumn( "UserId", typeof(String), "", System.Data.MappingType.Element) ;
				this.columnUserId.AllowDBNull = false ;
				this.columnUserId.Caption = "User Id" ;
				this.columnUserId.MaxLength = 80 ;
				this.columnUserId.Unique = true ;
				this.columnUserId.DefaultValue = System.Convert.DBNull ;
				this.Columns.Add( this.columnUserId) ;
				this.columnUserEmail = new DataColumn( "UserEmail", typeof(String), "", System.Data.MappingType.Element) ;
				this.columnUserEmail.AllowDBNull = false ;
				this.columnUserEmail.Caption = "User Email" ;
				this.columnUserEmail.MaxLength = 80 ;
				this.columnUserEmail.DefaultValue = System.Convert.DBNull ;
				this.Columns.Add( this.columnUserEmail) ;
				this.columnUserFirstNAme = new DataColumn( "UserFirstNAme", typeof(String), "", System.Data.MappingType.Element) ;
				this.columnUserFirstNAme.AllowDBNull = false ;
				this.columnUserFirstNAme.Caption = "User First NAme" ;
				this.columnUserFirstNAme.MaxLength = 80 ;
				this.columnUserFirstNAme.DefaultValue = System.Convert.DBNull ;
				this.Columns.Add( this.columnUserFirstNAme) ;
				this.columnUserLastName = new DataColumn( "UserLastName", typeof(String), "", System.Data.MappingType.Element) ;
				this.columnUserLastName.AllowDBNull = false ;
				this.columnUserLastName.Caption = "User Last Name" ;
				this.columnUserLastName.MaxLength = 80 ;
				this.columnUserLastName.DefaultValue = System.Convert.DBNull ;
				this.Columns.Add( this.columnUserLastName) ;
				this.columnUserStatus = new DataColumn( "UserStatus", typeof(String), "", System.Data.MappingType.Element) ;
				this.columnUserStatus.Caption = "User Status" ;
				this.columnUserStatus.MaxLength = 2 ;
				this.columnUserStatus.DefaultValue = System.Convert.DBNull ;
				this.Columns.Add( this.columnUserStatus) ;
				this.columnUserAddr1 = new DataColumn( "UserAddr1", typeof(String), "", System.Data.MappingType.Element) ;
				this.columnUserAddr1.AllowDBNull = false ;
				this.columnUserAddr1.Caption = "User Addr1" ;
				this.columnUserAddr1.MaxLength = 80 ;
				this.columnUserAddr1.DefaultValue = System.Convert.DBNull ;
				this.Columns.Add( this.columnUserAddr1) ;
				this.columnUserAddr2 = new DataColumn( "UserAddr2", typeof(String), "", System.Data.MappingType.Element) ;
				this.columnUserAddr2.Caption = "User Addr2" ;
				this.columnUserAddr2.MaxLength = 40 ;
				this.columnUserAddr2.DefaultValue = System.Convert.DBNull ;
				this.Columns.Add( this.columnUserAddr2) ;
				this.columnUserCity = new DataColumn( "UserCity", typeof(String), "", System.Data.MappingType.Element) ;
				this.columnUserCity.AllowDBNull = false ;
				this.columnUserCity.Caption = "User City" ;
				this.columnUserCity.MaxLength = 80 ;
				this.columnUserCity.DefaultValue = System.Convert.DBNull ;
				this.Columns.Add( this.columnUserCity) ;
				this.columnUserState = new DataColumn( "UserState", typeof(String), "", System.Data.MappingType.Element) ;
				this.columnUserState.AllowDBNull = false ;
				this.columnUserState.Caption = "User State" ;
				this.columnUserState.MaxLength = 80 ;
				this.columnUserState.DefaultValue = System.Convert.DBNull ;
				this.Columns.Add( this.columnUserState) ;
				this.columnUserZip = new DataColumn( "UserZip", typeof(String), "", System.Data.MappingType.Element) ;
				this.columnUserZip.AllowDBNull = false ;
				this.columnUserZip.Caption = "User Zip" ;
				this.columnUserZip.MaxLength = 20 ;
				this.columnUserZip.DefaultValue = System.Convert.DBNull ;
				this.Columns.Add( this.columnUserZip) ;
				this.columnUserCountry = new DataColumn( "UserCountry", typeof(String), "", System.Data.MappingType.Element) ;
				this.columnUserCountry.AllowDBNull = false ;
				this.columnUserCountry.Caption = "User Country" ;
				this.columnUserCountry.MaxLength = 20 ;
				this.columnUserCountry.DefaultValue = System.Convert.DBNull ;
				this.Columns.Add( this.columnUserCountry) ;
				this.columnUserPhone = new DataColumn( "UserPhone", typeof(String), "", System.Data.MappingType.Element) ;
				this.columnUserPhone.AllowDBNull = false ;
				this.columnUserPhone.Caption = "User Phone" ;
				this.columnUserPhone.MaxLength = 80 ;
				this.columnUserPhone.DefaultValue = System.Convert.DBNull ;
				this.Columns.Add( this.columnUserPhone) ;
				this.columnPassword = new DataColumn( "Password", typeof(String), "", System.Data.MappingType.Element) ;
				this.columnPassword.AllowDBNull = false ;
				this.columnPassword.Caption = "Password" ;
				this.columnPassword.MaxLength = 25 ;
				this.columnPassword.DefaultValue = System.Convert.DBNull ;
				this.Columns.Add( this.columnPassword) ;
				this.columnLangPref = new DataColumn( "LangPref", typeof(String), "", System.Data.MappingType.Element) ;
				this.columnLangPref.AllowDBNull = false ;
				this.columnLangPref.Caption = "Lang Pref" ;
				this.columnLangPref.MaxLength = 80 ;
				this.columnLangPref.DefaultValue = System.Convert.DBNull ;
				this.Columns.Add( this.columnLangPref) ;
				this.columnFavCategory = new DataColumn( "FavCategory", typeof(String), "", System.Data.MappingType.Element) ;
				this.columnFavCategory.Caption = "Fav Category" ;
				this.columnFavCategory.MaxLength = 80 ;
				this.columnFavCategory.DefaultValue = System.Convert.DBNull ;
				this.Columns.Add( this.columnFavCategory) ;
				this.columnMyListOpt = new DataColumn( "MyListOpt", typeof(int), "", System.Data.MappingType.Element) ;
				this.columnMyListOpt.Caption = "My List Opt" ;
				this.columnMyListOpt.DefaultValue = System.Convert.DBNull ;
				this.Columns.Add( this.columnMyListOpt) ;
				this.columnBannerOpt = new DataColumn( "BannerOpt", typeof(int), "", System.Data.MappingType.Element) ;
				this.columnBannerOpt.Caption = "Banner Opt" ;
				this.columnBannerOpt.DefaultValue = System.Convert.DBNull ;
				this.Columns.Add( this.columnBannerOpt) ;
				this.PrimaryKey = new  DataColumn[]  {this.columnUserId} ;
			}

			public AccountRow NewAccountRow( )
			{
				return ((AccountRow)(this.NewRow())) ;
			}

			protected override DataRow NewRowFromBuilder( DataRowBuilder builder )
			{
				return new AccountRow( builder) ;
			}

			protected override System.Type GetRowType( )
			{
				return typeof( AccountRow) ;
			}

			protected override void OnRowChanged( DataRowChangeEventArgs e )
			{
				base.OnRowChanged( e) ;
				if ( ( this.AccountRowChanged != null ) )
				{
					this.AccountRowChanged( this, new AccountRowChangeEvent( ((AccountRow)(e.Row)), e.Action)) ;
				}
			}

			protected override void OnRowChanging( DataRowChangeEventArgs e )
			{
				base.OnRowChanging( e) ;
				if ( ( this.AccountRowChanging != null ) )
				{
					this.AccountRowChanging( this, new AccountRowChangeEvent( ((AccountRow)(e.Row)), e.Action)) ;
				}
			}

			protected override void OnRowDeleted( DataRowChangeEventArgs e )
			{
				base.OnRowDeleted( e) ;
				if ( ( this.AccountRowDeleted != null ) )
				{
					this.AccountRowDeleted( this, new AccountRowChangeEvent( ((AccountRow)(e.Row)), e.Action)) ;
				}
			}

			protected override void OnRowDeleting( DataRowChangeEventArgs e )
			{
				base.OnRowDeleting( e) ;
				if ( ( this.AccountRowDeleting != null ) )
				{
					this.AccountRowDeleting( this, new AccountRowChangeEvent( ((AccountRow)(e.Row)), e.Action)) ;
				}
			}

			public void RemoveAccountRow( AccountRow row )
			{
				this.Rows.Remove( row) ;
			}

		}

		public class AccountRow : DataRow
		{
			private AccountDataTable tableAccount ;
			internal  AccountRow( DataRowBuilder rb ) : base(rb)
			{
				this.tableAccount = ((AccountDataTable)(this.Table)) ;
			}

			public String UserId
			{
				get 
				{
					return ((String)(this[this.tableAccount.UserIdColumn])) ;
				}

				set 
				{
					this[this.tableAccount.UserIdColumn] = value ;
				}

			}

			public bool IsUserIdNull( )
			{
				return this.IsNull( this.tableAccount.UserIdColumn) ;
			}

			public void SetUserIdNull( )
			{
				this[this.tableAccount.UserIdColumn] = System.Convert.DBNull ;
			}

			public String UserEmail
			{
				get 
				{
					try
					{
						return ((String)(this[this.tableAccount.UserEmailColumn])) ;
					}
					catch ( InvalidCastException e )
					{
						throw new StrongTypingException( "Cannot get value UserEmail because it is DBNull.", e) ;
					}
				}

				set 
				{
					this[this.tableAccount.UserEmailColumn] = value ;
				}

			}

			public bool IsUserEmailNull( )
			{
				return this.IsNull( this.tableAccount.UserEmailColumn) ;
			}

			public void SetUserEmailNull( )
			{
				this[this.tableAccount.UserEmailColumn] = System.Convert.DBNull ;
			}

			public String UserFirstNAme
			{
				get 
				{
					try
					{
						return ((String)(this[this.tableAccount.UserFirstNAmeColumn])) ;
					}
					catch ( InvalidCastException e )
					{
						throw new StrongTypingException( "Cannot get value UserFirstNAme because it is DBNull.", e) ;
					}
				}

				set 
				{
					this[this.tableAccount.UserFirstNAmeColumn] = value ;
				}

			}

			public bool IsUserFirstNAmeNull( )
			{
				return this.IsNull( this.tableAccount.UserFirstNAmeColumn) ;
			}

			public void SetUserFirstNAmeNull( )
			{
				this[this.tableAccount.UserFirstNAmeColumn] = System.Convert.DBNull ;
			}

			public String UserLastName
			{
				get 
				{
					try
					{
						return ((String)(this[this.tableAccount.UserLastNameColumn])) ;
					}
					catch ( InvalidCastException e )
					{
						throw new StrongTypingException( "Cannot get value UserLastName because it is DBNull.", e) ;
					}
				}

				set 
				{
					this[this.tableAccount.UserLastNameColumn] = value ;
				}

			}

			public bool IsUserLastNameNull( )
			{
				return this.IsNull( this.tableAccount.UserLastNameColumn) ;
			}

			public void SetUserLastNameNull( )
			{
				this[this.tableAccount.UserLastNameColumn] = System.Convert.DBNull ;
			}

			public String UserStatus
			{
				get 
				{
					try
					{
						return ((String)(this[this.tableAccount.UserStatusColumn])) ;
					}
					catch ( InvalidCastException e )
					{
						throw new StrongTypingException( "Cannot get value UserStatus because it is DBNull.", e) ;
					}
				}

				set 
				{
					this[this.tableAccount.UserStatusColumn] = value ;
				}

			}

			public bool IsUserStatusNull( )
			{
				return this.IsNull( this.tableAccount.UserStatusColumn) ;
			}

			public void SetUserStatusNull( )
			{
				this[this.tableAccount.UserStatusColumn] = System.Convert.DBNull ;
			}

			public String UserAddr1
			{
				get 
				{
					try
					{
						return ((String)(this[this.tableAccount.UserAddr1Column])) ;
					}
					catch ( InvalidCastException e )
					{
						throw new StrongTypingException( "Cannot get value UserAddr1 because it is DBNull.", e) ;
					}
				}

				set 
				{
					this[this.tableAccount.UserAddr1Column] = value ;
				}

			}

			public bool IsUserAddr1Null( )
			{
				return this.IsNull( this.tableAccount.UserAddr1Column) ;
			}

			public void SetUserAddr1Null( )
			{
				this[this.tableAccount.UserAddr1Column] = System.Convert.DBNull ;
			}

			public String UserAddr2
			{
				get 
				{
					try
					{
						return ((String)(this[this.tableAccount.UserAddr2Column])) ;
					}
					catch ( InvalidCastException e )
					{
						throw new StrongTypingException( "Cannot get value UserAddr2 because it is DBNull.", e) ;
					}
				}

				set 
				{
					this[this.tableAccount.UserAddr2Column] = value ;
				}

			}

			public bool IsUserAddr2Null( )
			{
				return this.IsNull( this.tableAccount.UserAddr2Column) ;
			}

			public void SetUserAddr2Null( )
			{
				this[this.tableAccount.UserAddr2Column] = System.Convert.DBNull ;
			}

			public String UserCity
			{
				get 
				{
					try
					{
						return ((String)(this[this.tableAccount.UserCityColumn])) ;
					}
					catch ( InvalidCastException e )
					{
						throw new StrongTypingException( "Cannot get value UserCity because it is DBNull.", e) ;
					}
				}

				set 
				{
					this[this.tableAccount.UserCityColumn] = value ;
				}

			}

			public bool IsUserCityNull( )
			{
				return this.IsNull( this.tableAccount.UserCityColumn) ;
			}

			public void SetUserCityNull( )
			{
				this[this.tableAccount.UserCityColumn] = System.Convert.DBNull ;
			}

			public String UserState
			{
				get 
				{
					try
					{
						return ((String)(this[this.tableAccount.UserStateColumn])) ;
					}
					catch ( InvalidCastException e )
					{
						throw new StrongTypingException( "Cannot get value UserState because it is DBNull.", e) ;
					}
				}

				set 
				{
					this[this.tableAccount.UserStateColumn] = value ;
				}

			}

			public bool IsUserStateNull( )
			{
				return this.IsNull( this.tableAccount.UserStateColumn) ;
			}

			public void SetUserStateNull( )
			{
				this[this.tableAccount.UserStateColumn] = System.Convert.DBNull ;
			}

			public String UserZip
			{
				get 
				{
					try
					{
						return ((String)(this[this.tableAccount.UserZipColumn])) ;
					}
					catch ( InvalidCastException e )
					{
						throw new StrongTypingException( "Cannot get value UserZip because it is DBNull.", e) ;
					}
				}

				set 
				{
					this[this.tableAccount.UserZipColumn] = value ;
				}

			}

			public bool IsUserZipNull( )
			{
				return this.IsNull( this.tableAccount.UserZipColumn) ;
			}

			public void SetUserZipNull( )
			{
				this[this.tableAccount.UserZipColumn] = System.Convert.DBNull ;
			}

			public String UserCountry
			{
				get 
				{
					try
					{
						return ((String)(this[this.tableAccount.UserCountryColumn])) ;
					}
					catch ( InvalidCastException e )
					{
						throw new StrongTypingException( "Cannot get value UserCountry because it is DBNull.", e) ;
					}
				}

				set 
				{
					this[this.tableAccount.UserCountryColumn] = value ;
				}

			}

			public bool IsUserCountryNull( )
			{
				return this.IsNull( this.tableAccount.UserCountryColumn) ;
			}

			public void SetUserCountryNull( )
			{
				this[this.tableAccount.UserCountryColumn] = System.Convert.DBNull ;
			}

			public String UserPhone
			{
				get 
				{
					try
					{
						return ((String)(this[this.tableAccount.UserPhoneColumn])) ;
					}
					catch ( InvalidCastException e )
					{
						throw new StrongTypingException( "Cannot get value UserPhone because it is DBNull.", e) ;
					}
				}

				set 
				{
					this[this.tableAccount.UserPhoneColumn] = value ;
				}

			}

			public bool IsUserPhoneNull( )
			{
				return this.IsNull( this.tableAccount.UserPhoneColumn) ;
			}

			public void SetUserPhoneNull( )
			{
				this[this.tableAccount.UserPhoneColumn] = System.Convert.DBNull ;
			}

			public String Password
			{
				get 
				{
					try
					{
						return ((String)(this[this.tableAccount.PasswordColumn])) ;
					}
					catch ( InvalidCastException e )
					{
						throw new StrongTypingException( "Cannot get value Password because it is DBNull.", e) ;
					}
				}

				set 
				{
					this[this.tableAccount.PasswordColumn] = value ;
				}

			}

			public bool IsPasswordNull( )
			{
				return this.IsNull( this.tableAccount.PasswordColumn) ;
			}

			public void SetPasswordNull( )
			{
				this[this.tableAccount.PasswordColumn] = System.Convert.DBNull ;
			}

			public String LangPref
			{
				get 
				{
					try
					{
						return ((String)(this[this.tableAccount.LangPrefColumn])) ;
					}
					catch ( InvalidCastException e )
					{
						throw new StrongTypingException( "Cannot get value LangPref because it is DBNull.", e) ;
					}
				}

				set 
				{
					this[this.tableAccount.LangPrefColumn] = value ;
				}

			}

			public bool IsLangPrefNull( )
			{
				return this.IsNull( this.tableAccount.LangPrefColumn) ;
			}

			public void SetLangPrefNull( )
			{
				this[this.tableAccount.LangPrefColumn] = System.Convert.DBNull ;
			}

			public String FavCategory
			{
				get 
				{
					try
					{
						return ((String)(this[this.tableAccount.FavCategoryColumn])) ;
					}
					catch ( InvalidCastException e )
					{
						throw new StrongTypingException( "Cannot get value FavCategory because it is DBNull.", e) ;
					}
				}

				set 
				{
					this[this.tableAccount.FavCategoryColumn] = value ;
				}

			}

			public bool IsFavCategoryNull( )
			{
				return this.IsNull( this.tableAccount.FavCategoryColumn) ;
			}

			public void SetFavCategoryNull( )
			{
				this[this.tableAccount.FavCategoryColumn] = System.Convert.DBNull ;
			}

			public int MyListOpt
			{
				get 
				{
					try
					{
						return ((int)(this[this.tableAccount.MyListOptColumn])) ;
					}
					catch ( InvalidCastException e )
					{
						throw new StrongTypingException( "Cannot get value MyListOpt because it is DBNull.", e) ;
					}
				}

				set 
				{
					this[this.tableAccount.MyListOptColumn] = value ;
				}

			}

			public bool IsMyListOptNull( )
			{
				return this.IsNull( this.tableAccount.MyListOptColumn) ;
			}

			public void SetMyListOptNull( )
			{
				this[this.tableAccount.MyListOptColumn] = System.Convert.DBNull ;
			}

			public int BannerOpt
			{
				get 
				{
					try
					{
						return ((int)(this[this.tableAccount.BannerOptColumn])) ;
					}
					catch ( InvalidCastException e )
					{
						throw new StrongTypingException( "Cannot get value BannerOpt because it is DBNull.", e) ;
					}
				}

				set 
				{
					this[this.tableAccount.BannerOptColumn] = value ;
				}

			}

			public bool IsBannerOptNull( )
			{
				return this.IsNull( this.tableAccount.BannerOptColumn) ;
			}

			public void SetBannerOptNull( )
			{
				this[this.tableAccount.BannerOptColumn] = System.Convert.DBNull ;
			}

		}

		public class AccountRowChangeEvent : EventArgs
		{
			private AccountRow eventRow ;
			private System.Data.DataRowAction eventAction ;
			public  AccountRowChangeEvent( AccountRow row ,
				DataRowAction action )
			{
				this.eventRow = row ;
				this.eventAction = action ;
			}

			public AccountRow Row
			{
				get 
				{
					return this.eventRow ;
				}

			}

			public DataRowAction Action
			{
				get 
				{
					return this.eventAction ;
				}

			}

		}

	}

   #endregion
}