C#

taurusone wrote:

can anyone give me a C# code which does this.

Bastard Programmer from Hell

yes i know it is not restaurant and i am not ordering, it a request.

input file:

table 1:
txt1 txt2 txt3 txt4
txt5 txt6 txt7 txt8
txt4 txt3 txt2 txt1

table 2:
txt1 txt2 txt3 txt4
txt5 txt6 txt7 txt8
txt4 txt3 txt2 txt1
txt4 txt3 txt2 txt1
txt4 txt3 txt2 txt1

note that the table rows or variging. i want to write a code which

wanted output xls file:

table 1:
sume of first col: sum of say 3rd col:
txt1                txt3
txt5                txt7
txt4                txt2

table2: <same as above>


Plz dont misunderstand me point me to site which has c# code to do this or atleast give me an overview or idea about implenting this in c#.

taurusone wrote:

yes i know it is not restaurant and i am not ordering, it a request.

taurusone wrote:

Plz dont misunderstand me point me to site which has c# code to do this or atleast give me an overview or idea about implenting this in c#.

Bastard Programmer from Hell

BackgroundColor="{Binding Temperature, Converter={StaticResource myTemperatureToColorConverter}}"

<converters:TemperatureToColorConverter x:Key="myTemperatureToColorConverter" />

Inner exception
{"Type 'System.Data.Objects.ObjectSet`1[[entityMapExample.tableA, entityMapExample, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]' in Assembly 'System.Data.Entity, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' is not marked as serializable."}
Data
{System.Collections.ListDictionaryInternal}
StackTrace
   at System.Runtime.Serialization.FormatterServices.InternalGetSerializableMembers(RuntimeType type)
   at System.Runtime.Serialization.FormatterServices.GetSerializableMembers(Type type, StreamingContext context)
   at System.Runtime.Serialization.Formatters.Binary.WriteObjectInfo.InitMemberInfo()
   at System.Runtime.Serialization.Formatters.Binary.WriteObjectInfo.InitSerialize(Object obj, ISurrogateSelector surrogateSelector, StreamingContext context, SerObjectInfoInit serObjectInfoInit, IFormatterConverter converter, ObjectWriter objectWriter, SerializationBinder binder)
   at System.Runtime.Serialization.Formatters.Binary.WriteObjectInfo.Serialize(Object obj, ISurrogateSelector surrogateSelector, StreamingContext context, SerObjectInfoInit serObjectInfoInit, IFormatterConverter converter, ObjectWriter objectWriter, SerializationBinder binder)
   at System.Runtime.Serialization.Formatters.Binary.ObjectWriter.Serialize(Object graph, Header[] inHeaders, __BinaryWriter serWriter, Boolean fCheck)
   at System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Serialize(Stream serializationStream, Object graph, Header[] headers, Boolean fCheck)
   at System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Serialize(Stream serializationStream, Object graph)
   at entityMapExample.Program.Main() in C:\C#projetcs\entityMapExample\entityMapExample\Program.cs:line 39

/// <summary>
    /// No Metadata Documentation available.
    /// </summary>
    [EdmEntityTypeAttribute(NamespaceName="ModelStart", Name="tableA")]
    [Serializable()]
    [DataContractAttribute(IsReference=true)]
    public partial class tableA : EntityObject
    {
        #region Factory Method
    
        /// <summary>
        /// Create a new tableA object.
        /// </summary>
        /// <param name="id">Initial value of the Id property.</param>
        /// <param name="name">Initial value of the Name property.</param>
        public static tableA CreatetableA(global::System.Int32 id, global::System.String name)
        {
            tableA tableA = new tableA();
            tableA.Id = id;
            tableA.Name = name;
            return tableA;
        }

        #endregion
        #region Primitive Properties
    
        /// <summary>
        /// No Metadata Documentation available.
        /// </summary>
        [EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
        [DataMemberAttribute()]
        public global::System.Int32 Id
        {
            get
            {
                return _Id;
            }
            set
            {
                if (_Id != value)
                {
                    OnIdChanging(value);
                    ReportPropertyChanging("Id");
                    _Id = StructuralObject.SetValidValue(value);
                    ReportPropertyChanged("Id");
                    OnIdChanged();
                }
            }
        }
        private global::System.Int32 _Id;
        partial void OnIdChanging(global::System.Int32 value);
        partial void OnIdChanged();
    
        /// <summary>
        /// No Metadata Documentation available.
        /// </summary>
        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
        [DataMemberAttribute()]
        public global::System.String Name
        {
            get
            {
                return _Name;
            }
            set
            {
                OnNameChanging(value);
                ReportPropertyChanging("Name");
                _Name = StructuralObject.SetValidValue(value, false);
                ReportPropertyChanged("Name");
                OnNameChanged();
            }
        }
        private global::System.String _Name;
        partial void OnNameChanging(global::System.String value);
        partial void OnNameChanged();

        #endregion
    
    }

[XmlIgnoreAttribute()]
[SoapIgnoreAttribute()]
[DataMemberAttribute()]
[EdmRelationshipNavigationPropertyAttribute("ModelStart", "PlayerHobbie", "Hobbie")]
public EntityCollection<Hobbie> Hobbies
{

using (ModelStartContainer model= new ModelStartContainer())
            {
                /*
                Player obj= new Player();
                
                Hobbie o1= new Hobbie();
                o1.Sport = "Tennis";
                obj.Hobbies.Add(o1);

                Hobbie o2 = new Hobbie();
                o2.Sport = "Ski";
                obj.Hobbies.Add(o2);

                obj.Name = "Georgen";
                
                model.Players.AddObject(obj);
                model.SaveChanges();

                 */
 
                try
                {
                    var queryable = model.Players.Include("Hobbies").ToList();

                    using (XmlWriter writer = XmlWriter.Create(@"c:\Serialize\conTemp.xml"))
                    {
                        DataContractSerializer serializer = new DataContractSerializer(queryable.GetType());
                        serializer.WriteObject(writer, queryable);
                    }
                }
                catch (EntitySqlException ex)
                {
                    throw new ApplicationException("The object query failed", ex);
                }
                catch (EntityCommandExecutionException ex)
                {
                    throw new ApplicationException("The object query failed", ex);
                }
                catch (SerializationException ex)
                {
                    throw new ApplicationException("The object graph could not be serialized", ex);
                }
                  
            }