C#

Rob Philpott wrote:

Using them to control execution flow is criminal.

Luc Pattyn wrote:

Wait a minute, exceptions are supposed to alter execution flow

kibromg wrote:

select count(distinct(CR_Cli))

kibromg wrote:

datename(month,cr_callstart)='April'

kibromg wrote:

and Cr_cli not in (select Cr_cli from Callrecords where cr_callstart<'2009-03-31')

kibromg wrote:

group by SO_name desc

<br />
select count(distinct(CR.Cli))<br />
     , SO.name<br />
  from Callrecords CR<br />
 inner<br />
  join StudioOperators SO<br />
    on CR.StudioOperatorID = SO.ID<br />
 where month(CR.callstart) = 4<br />
   and CR.callstart > '2009-03-30'<br />
 group by SO.name desc<br />

<code>
[WebMethod]
public ReturnList GetList(string id, string fromDate)
{
    // overlaod
    // your parsing logic
}
[WebMethod]
public ReturnList GetList(string id, System.DateTime fromDate)
{
    // Original function
}
</code>

benson.misi wrote:

Object cannot be cast from DBNull to other types

benson.misi wrote:

Object cannot be cast from DBNull to other types.
what does this mean

if(row["blah"]==null)

if (row["blah"] == DBNull.Value)

[System.Xml.Serialization.XmlTypeAttribute(Namespace = "http://namespace/", TypeName = "person")]
public class Person
{
   private string _name;
   
   [System.Xml.Serialization.XmlElementAttribute(ElementName = "name")]
   public string Name { get { return _name; } }
}

using System;
using System.Runtime.Serialization;
using Person;

namespace SchoolPackage
{
    [Serializable()]
    public class Student : ISerializable
    {
        private Person person;
        private int intReference;
        private int intReqTypeID;
        //
        private string strLastAlteredByUser;
        private DateTime dteAlteredDate;
        private Boolean blnIsDirty;
        private Boolean blnIsNew;
        private enum RequestType : int
        {
            Create = 1, Delete = 2, Update = 3, Execute = 4,
            Retrieve = 5, RetrieveMultiple = 6
        }

        public Student(Person person, String user, int TypeID, int Reference) 
        {
            this.person = person;
            this.strLastAlteredByUser = user;
            this.dteAlteredDate = DateTime.Now;
            this.blnIsDirty = false;
            this.blnIsNew = true;
            this.intReqTypeID = TypeID;
            this.intReference = Reference;
        }
      
        //Deserialization constructor.
        public Student(SerializationInfo info, StreamingContext ctxt)
        {
            //Get the values from info and assign them to the appropriate properties
            person = (Person)info.GetValue("person", typeof(Person));
            action = (string)info.GetValue("action", typeof(string));
            intReference = (int)info.GetValue("intReference", typeof(int));
            intReqTypeID = (int)info.GetValue("intReqTypeID", typeof(int));
        }
                
        //Serialization function.
        public void GetObjectData(SerializationInfo info, StreamingContext ctxt)
        {            
            info.AddValue("person", person);
            info.AddValue("action", action);
            info.AddValue("intReference", intReference);
            info.AddValue("intReqTypeID", intReqTypeID);
        }

}

using System;
using System.Runtime.Serialization;
using Person;
using System.Xml;
using System.Xml.Serialization;

namespace SchoolPackage
{
    //This line is basically all you need for the class to be serializable
    [System.Xml.Serialization.XmlTypeAttribute(Namespace = "http://www.x.com/namespace/", TypeName = "Student")]
    public class Student
    {
        [System.Xml.Serialization.XmlElementAttribute(ElementName = "myCustomXmlElementName")]
        public string StrLastAlteredByUser
        {
            get { return strLastAlteredByUser; }
            set { strLastAlteredByUser = value; }
        }
    }
}