Calculating age from a given date or calander date in c#

using System.Globalization;
IFormatProvider ci= new CultureInfo("en-US", true); 


DateTime Dt = Convert.ToDateTime(txtDateOfBirth.Text,ci);


string test = String.Format("{0:MM/dd/yyyy}", Convert.ToDateTime( Dt ));
int age = DateTime.Now.Subtract(DateTime.ParseExact(test, "dd/MM/yyyy", ci,DateTimeStyles.NoCurrentDateDefault)).Days / 365;

Creating Virtual table and getting joined sql result

1.
SELECT A.CID,B.add1 ,B.add2,B.add3,B.add4,B.County,B.pcode ,B.street from
(SELECT CID from Claimant_Master where Claimant_Master.CID NOT IN(SELECT Cla_Id FROM Claimant_Address) AND Claimant_Master.WarrantID LIKE 'SPC%')  A ,
(SELECT add1,add2,add3,add4,County,pcode, street from Claimant_Address where Cla_Id IN (SELECT CID from Claimant_Master where WarrantID='SPC6748'))  B

2.Another query

select c.EnterBy,c.totalcalls astotal,c.reminder as rem,d.tot as blank from 

(SELECT A.EnterBy,A.tot as totalcalls,B.Tot as reminder FROM

(SELECT COUNT(custTicketNo) AS 'tot',EnteredBy As EnterBy FROM indiatimes_cust_complaint WHERE (TDate + 2

+ TTime BETWEEN '7/22/2008 00:00:00.000' AND '7/22/2008 23:59:59.999') 

and EnteredBy in(SELECT agentLoginID FROM indiatimes_agent_master WHERE (TType IN

('Admin', 'BackendAgent','FrontEndAgent'))) GROUP BY EnteredBy )A,

(SELECT EnterBy, COUNT(*) AS tot FROM IT_Reminders WHERE (entertime between '7/22/2008 00:00:00.000' and '7/22/2008

23:59:59.999' ) and Type='NT' GROUP BY EnterBy )B WHERE (A.EnterBy *= B.EnterBy))c ,

(SELECT EnteredBy, COUNT(*) AS tot FROM

Indiatimes_BlankCalls WHERE (tdate between '7/22/2008 00:00:00.000' and '7/22/2008 23:59:59.999' ) and EnteredBy in(SELECT agentLoginID FROM indiatimes_agent_master

WHERE (TType IN ('Admin', 'BackendAgent','FrontEndAgent'))) GROUP BY EnteredBy)d

where c.EnterBy *=d.EnteredBy

Adding double quotes("") in string and displaying like "Ajay""

simplest way to do this is:

string test ="You are very good \"person\" and want to meet you"

console.write(test );

You will get output like:

You are very good "person" and want to meet you

How get sql identity key value in ASP.net code behind page

1.Create stored procedure in SQL like this...



CREATE procedure test

@retval int output

As

Begin
insert INTO Testtable(abc,xyz) values('ajay','balwindar')

@retval=@@identity
return @retval
End

2 .In asp.net code behind page..on page load call this function written below


 protected void Page_Load(object sender, EventArgs e)
    {

Label1.Text= Convert.ToString(GetIdentityValue());
}




public int GetIdentityValue()
        {
              string S4CConString = ConfigurationManager.AppSettings["S4CConString"].ToString();
          SqlConnection _con = new SqlConnection(S4CConString);
            SqlCommand _cmd = new SqlCommand("test", _con);
            _cmd.CommandType = CommandType.StoredProcedure;
        _cmd.Parameters.Add("@subjectParam", SqlDbType.NVarChar);
      _cmd.Parameters["@retval"].Direction = ParameterDirection.ReturnValue;

_cmd.ExecuteNonQuery();

int i = (int)_cmd.Parameters["@retval"].Value;
return i;

}