Example #1
0
 public bool AddColumn(ProfileColumn column)
 {
     string strSql = String.Format("ALTER TABLE {0}ProfileData ADD {1} {2} DEFAULT {3} {4}",Config.MemberTablePrefix, column.ColumnName, column.DataType, column.DefaultValue, column.AllowNull ? "NULL" : "NOT NULL");
     try
     {
         SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql + column, null);
     }
     catch (Exception)
     {
         return false;
     }
     return true;
 }
Example #2
0
 public static bool AddColumn(ProfileColumn column)
 {
     ICustomProfile dal = Factory<ICustomProfile>.Create("CustomProfile");
     return dal.AddColumn(column);
 }