First and Last Day Of a Month in SQL

DECLARE @Today DATETIME

SELECT @Today = '6/17/2007'

Select 'Get First Day of a Month Using SQL Query'

SELECT DATEADD(dd,-(DAY(DATEADD(mm,1,@Today))-1),DATEADD(mm,-3,@Today))

--Value = 2007-03-01 00:00:00.000

SELECT DATEADD(dd,-(DAY(DATEADD(mm,1,@Today))-1),DATEADD(mm,-2,@Today))

--Value = 2007-04-01 00:00:00.000

SELECT DATEADD(dd,-(DAY(DATEADD(mm,1,@Today))-1),DATEADD(mm,-1,@Today))

--Value = 2007-05-01 00:00:00.000

SELECT DATEADD(dd,-(DAY(DATEADD(mm,1,@Today))-1),DATEADD(mm,0,@Today))

--Value = 2007-06-01 00:00:00.000

SELECT DATEADD(dd,-(DAY(DATEADD(mm,1,@Today))-1),DATEADD(mm,1,@Today))

--Value = 2007-07-01 00:00:00.000

SELECT DATEADD(dd,-(DAY(DATEADD(mm,1,@Today))-1),DATEADD(mm,2,@Today))

--Value = 2007-08-01 00:00:00.000

SELECT DATEADD(dd,-(DAY(DATEADD(mm,1,@Today))-1),DATEADD(mm,3,@Today))

--Value = 2007-09-01 00:00:00.000

  Select 'Get Last Day of a Month Using SQL Query'

SELECT DATEADD(dd, -DAY(DATEADD(m,1,@Today)), DATEADD(m,-2,@Today))

--Value = 2007-03-31 00:00:00.000

SELECT DATEADD(dd, -DAY(DATEADD(m,1,@Today)), DATEADD(m,-1,@Today))

--Value = 2007-04-30 00:00:00.000

SELECT DATEADD(dd, -DAY(DATEADD(m,1,@Today)), DATEADD(m,0,@Today))

--Value = 2007-05-31 00:00:00.000

SELECT DATEADD(dd, -DAY(DATEADD(m,1,@Today)), DATEADD(m,1,@Today))

--Value = 2007-06-30 00:00:00.000

SELECT DATEADD(dd, -DAY(DATEADD(m,1,@Today)), DATEADD(m,2,@Today))

--Value = 2007-07-31 00:00:00.000

SELECT DATEADD(dd, -DAY(DATEADD(m,1,@Today)), DATEADD(m,3,@Today))

--Value = 2007-08-31 00:00:00.000

SELECT DATEADD(dd, -DAY(DATEADD(m,1,@Today)), DATEADD(m,4,@Today))

--Value = 2007-09-30 00:00:00.000

Webservices and remoting

COM is Component Object Model. This is specification developed by Microsoft. Component is pre compiled block of code which is reusable and language independent. In order to use COM you must know the interfaces of COM. The family of COM technologies includes COM+, Distributed COM (DCOM) and ActiveX Controls.

DCOM is a Distributed component object Model runs at the given server.

Webservices and  remoting

webservices apply between defferent vendor but remoting only on same vendor.
that is
a webservice application made in java platform can be used in a .Net application or project.
but remoting doesnt provide this.

Let me try to explain both without getting too much into technicalities.

In pre-.NET days, the protocol to communicate between a client and a server or between components across machines on a Windows platform was DCOM. But, DCOM had it's own limiations and all, the major ones being that it works only on MS o/s, was MS proprietory, needs a specific port to be opened if using Firewall and so on.

Now DCOM was basically to facilitate communcation between components across processes. .NET Remoting is the same, except that in .NET, there are AppDomains instead of processes.

.NET Remoting replaces DCOM. Now, no more proprietory protocols used. Remoting works over TCP and HTTP. Supports binary as well as XML.

Also, you need a "server" to host your Remoting component. It could be a normal .exe app, or you can host your component in IIS or via a Windows Service. Your choice.

Now .NET Remoting is a good option if you are creating an app that is to be used within the corporate network as it will use TCP. TCP is definitely faster than HTTP. So, if you need to transfer data between apps within the same network, use .NET Remoting.

Now, what if the data needs to go outside your network. Well, you could use .NET Remoting over HTTP, but that is not advisable as (a) HTTP is slow, (b) you'll have to give access to the outside world to your network and (c) U R defeating the purpose of Remoting.

So, in such a case where you do not know "who" is gonna connect to your app, from where, what platform do they use and what format do they need data in (and send too), go for Web Services. They could be using J2EE for all you know.

Web Services is a standard, wherein it uses all standard protocols/technologies like HTTP, XML, SOAP, UDDI and WSDL. All it needs is a Web Server (IIS in this case).

Anybody who has a net connection can access a Web service. Of course, you'll have to take care of the security part too. But let's not get into that right now.

Also, if I had to define a Web service in one line, I'd say "It is a Web Page without a UI.".

Let me know if you need more info.

The following list outlines some of the major differences between .NET Remoting and Web services that will help you to decide when to use one or the other:

ASP.NET based Web services can only be accessed over HTTP. .NET Remoting can be used across any protocol.

Web services work in a stateless environment where each request results in a new object created to service the request. .NET Remoting supports state management options and can correlate multiple calls from the same client and support callbacks.

Web services serialize objects through XML contained in the SOAP messages and can thus only handle items that can be fully expressed in XML. .NET Remoting relies on the existence of the common language runtime assemblies that contain information about data types. This limits the information that must be passed about an object and allows objects to be passed by value or by reference.

Web services support interoperability across platforms and are good for heterogeneous environments. .NET Remoting requires the clients be built using .NET, or another framework that supports .NET Remoting, which means a homogeneous environment.

Find Check box id inside GridView or Table Control with Jquery

function FindControlInsideGridView() {

            var _Table1 = document.getElementById('<%= Table1.ClientID %>');

            $(_Table1).find("tr").each(function(index) {

                var mytd = $(_Table1).find("tr").eq(index).find("td").eq(0);

                if (mytd[0].childNodes[0].checked) {

            //Do some thing

                }

            });

        }

ModalPopup Show on Button click with JQuery..

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajaxToolkit" %>

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title>Untitled Page</title>

    <script src="Js/jquery-1.4.2.min.js" type="text/javascript"></script>

    <script src="Js/ModalPopups.js" type="text/javascript"></script>

    <script language="javascript">

        //Set Click Event of  Button

        $(document).ready(function() {

            var _btnNo = document.getElementById('<%= btn.ClientID %>');

            $(_btnNo).click(function() {

            ModalConfirmPopup('hello');

            return false;

            });

        });

   

   

        //Modal PopUp Show

        function ModalConfirmPopup(msg) {

            var divAlertMsg = document.getElementById('<%= divPopupMsg.ClientID %>');

            var divPopupTitle = document.getElementById('<%= divPopupTitle.ClientID %>');

            divAlertMsg.innerHTML = msg;

            divPopupTitle.innerHTML = 'confirm Box';

            $find('popupPO').show();

          

        }

  

    </script>

   

    <style>

        <%--CSS--%>

        .modalBackground

        {

            filter: alpha(opacity=40);

            opacity: 0.4;

            background-color: Gray;

        }

        .modalPopup

        {

            background-color: #AEBC21;

            border-width: 3px;

            border-style: solid;

            border-color: Gray;

            padding: 3px;

            position: absolute;

            visibility: hidden;

        }

    </style>

</head>

<body>

    <form id="form1" runat="server">

    <div>

  <%-- Set Button--%>

        <asp:Button ID="btn" runat="server" Text="Show popUp"  />

    </div>

    <table cellpadding="0" cellspacing="0" width="100%">

        <tr>

            <td>

                <div>

                    <asp:ScriptManager ID="ScriptManager1" runat="server">

                    </asp:ScriptManager>

                    <asp:LinkButton ID="lnkPOPopup" runat="server"></asp:LinkButton>

                    <ajaxToolkit:ModalPopupExtender ID="ModalPOPopup" runat="server" BehaviorID="popupPO"

                        TargetControlID="lnkPOPopup" PopupControlID="pnlPOPopup" OkControlID="btnNo"

                        BackgroundCssClass="modalBackground" />

                    <asp:Panel ID="pnlPOPopup" runat="server" Style="display: none; width: 40%; font-size: 8pt;">

                        <div id="divPopupTitle" runat="server">

                        </div>

                        <table width="100%">

                            <tr>

                                <td>

                                    <div id="divPopupMsg" runat="server">

                                    </div>

                                </td>

                            </tr>

                            <tr>

                                <td style="height: 7px;">

                                </td>

                            </tr>

                            <tr>

                                <td align="center">

                                    <span class="art-button-wrapper"><span class="l"></span><span class="r"></span>

                                        <asp:Button ID="btnConfirm" runat="server" Text="Yes" CssClass="art-button" OnClientClick="javascript:return ModalConfirmPopup('Hello');" />

                                    </span><span class="art-button-wrapper"><span class="l"></span><span class="r"></span>

                                        <asp:Button ID="btnNo" runat="server" Text="No" CssClass="art-button" />

                                    </span>

                                </td>

                            </tr>

                        </table>

                        <div class="cleared">

                        </div>

                    </asp:Panel>

                </div>

            </td>

        </tr>

    </table>

    </form>

</body>

</html>

Notes--..

Download JQuey For  1. ModalPopups.js 2. jquery-1.4.2.min.js