Tuesday, May 21, 2013

How to send Messages using asp.net with help of way2sms

protected override void Page_Load(object sender, System.EventArgs e)
        {
            HttpUtility.UrlEncode("SMS");
            string API = "http://www.way2sms.com/jsp/InstantSMS.jsp?UID=9942676484&PWD=password&MSG=Hello+yyy+zzz&MobileNumber=9942676484";
            HttpWebRequest request = (HttpWebRequest)WebRequest.Create(API);
            HttpWebResponse response = (HttpWebResponse)request.GetResponse();
            StreamReader reader = new StreamReader(response.GetResponseStream());
            Response.Write(reader.ReadToEnd());
        }

 Note: Please Register with way2sms.com before try this Coding. Registeration in Way2sms is mandatory.
                           *********************************

Tuesday, May 14, 2013

How to get date between two Dates in a month


How to show date (mm/dd/yyyy) between two dates
_______________________________________________
declare @dateh table(ind int identity(1,1),date1 smalldatetime,date2 smalldatetime)

insert into @dateh select '1/1/2011','1/15/2011'


;with T as
(
    select date1,date2 from @dateh as d
    union all
    select dateadd(dd,1,date1),date2 From T
    where  dateadd(dd,1,date1)<= date2
)
Select date1 from T