C#

class dbColumn<T,U> {
   private string pColumnName;
   private T pColumnValue;
   private U pColumnType;

   public string ColumnName{
      get{
           return pColumnName;
      }
      set{
           pColumnName = value;
      }
   }
   public T ColumnValue{
      get{
           return pColumnValue;
      }
      set{
           pColumnValue = value;
      }
   }
   public U ColumnType{
      get{
           return pColumnType;
      }
      set{
           pColumnType = value;
      }
   }

   public dbColumn(string colName, T colValue, U colType){
         this.pColumnName = colName;
         this.pColumnValue = colValue;
         this.pColumnType = colType;
   }
}

<br />
List<dbcolumn> columns = new List<dbcolumn>();<br />
foreach (dbColumn col in columns){<br />
    col.ColumnName + "="+ columnValue<br />
}

interface IAbstractColumnType
{
}

class MyColumnType : IAbstractColumnType
{
   ...
}

<br />
class dbTable{<br />
      List<IAbstractColumnType> columns = new List<IAbstractColumnType>();<br />
<br />
   // sample function<br />
   public void GetSelectQuery(){<br />
         string sql = "";<br />
         foreach (IAbstractColumnType col in columns){<br />
            sql +=col.ColumnName + "=" + col.ColumnValue;<br />
         }<br />
         return sql;<br />
   }<br />
}<br />
<br />
    public interface IAbstractColumnType {<br />
        object ColumnValue;<br />
        object ColumnName;<br />
    }<br />
<br />
<br />
    public class dbColumn {<br />
        private string _Column;<br />
        public string ColumnName {<br />
            get {<br />
                return _Column;<br />
            }<br />
            set {<br />
                _Column = value;<br />
            }<br />
        }<br />
    }<br />
<br />
    public class dbColumnInt : dbColumn, IAbstractColumnType {<br />
        private int _Value;<br />
        public new int ColumnValue {<br />
            get {<br />
                return _Value;<br />
            }<br />
            set {<br />
                _Valore = value;<br />
            }<br />
        }<br />
        public dbColumnInt(string column, int id) {<br />
            this._Value = id;<br />
        }<br />
<br />
    }<br />
<br />
    public class dbColumnString : IAbstractColumnType {<br />
        private string _Value;<br />
        public new string ColumnValue {<br />
            get {<br />
                return _Value;<br />
            }<br />
            set {<br />
                _Value = value;<br />
            }<br />
        }<br />
        public dbColumnString(string column, string testo) {<br />
            this._Value = testo;<br />
        }<br />
    }

kulkoustubh wrote:

A complete code and running project is also welcome

kulkoustubh wrote:

And you have no right to say anything about me. If you were a generous person you would have helped me.

kulkoustubh wrote:

Get a life.