Clear controls in asp.net using javascript

   <script type="text/javascript" language="javascript">
        function clearAllServerFields() {

            //Code for accessing all dropdown lists and listboxes in an aspx page

            var select = document.getElementsByTagName("select");
            var length = select.length;
            for (i = 0; i < length; i++) {
                for (var j = 0; j < select[i].length; j++) {
                    select[i][j].selected = false;
                }
            }

            var elements = document.getElementsByTagName("input");
            for (var i = 0; i < elements.length; i++) {
                if (elements[i].disabled == false) {
                    //Code for accessing all textboxes in an aspx page

                    if (elements[i].type == "text") {
                        elements[i].value = "";
                    }
                    //Code for accessing all radio buttons in an aspx page

                    if (elements[i].type == "radio") {
                        elements[i].checked = false;
                    }
                    //Code for accessing all checkboxes in an aspx page

                    if (elements[i].type == "checkbox") {
                        elements[i].checked = false;
                    }
                }
            }
        }

    </script>

queries of date functions in sqlserver

weekstartdate and weekenddate of current week:

select convert(varchar,DATEADD(dd, -(DATEPART(dw, GETDATE())-1), GETDATE()),103) as [WeekStart]

select CONVERT(varchar, DATEADD(dd, 7-(DATEPART(dw, GETDATE())), GETDATE()),103) as [WeekEnd]

--India Time=UTC+5:30

select convert(varchar,DATEADD(dd, -(DATEPART(dw, DATEADD(mi,30,DATEADD(hh,5,getutcdate())))-1), DATEADD(mi,30,DATEADD(hh,5,getutcdate()))),103) as [WeekStart]

select CONVERT(varchar, DATEADD(dd, 7-(DATEPART(dw, DATEADD(mi,30,DATEADD(hh,5,getutcdate())))), DATEADD(mi,30,DATEADD(hh,5,getutcdate()))),103) as [WeekEnd]


monthstartdate and monthenddate of currentmonth :

select convert(varchar,dateadd(d,-(day(getdate()-1)),getdate()),103) as [monthfirstDate]

select  convert(varchar,dateadd(d,-day(getdate()),dateadd(m,1,getdate())),103)as [monthlastDate]

--India Time=UTC+5:30

select convert(varchar,dateadd(d,-(day(DATEADD(mi,30,DATEADD(hh,5,getutcdate()))-1)),DATEADD(mi,30,DATEADD(hh,5,getutcdate()))),103) as [monthfirstDate]

select  convert(varchar,dateadd(d,-day(DATEADD(mi,30,DATEADD(hh,5,getutcdate()))),dateadd(m,1,DATEADD(mi,30,DATEADD(hh,5,getutcdate())))),103)as [monthlastDate]

C# Basics And Interview Questions

http://www.gointerviews.com/top-50-c-sharp-interview-questions-answers/


http://www.java2s.com/Tutorial/CSharp/CatalogCSharp.htm

stored procedure for counting Records

Create Procedure [dbo].[Buddy_DashBoard]
as
/*
exec Buddy_DashBoard
*/
begin


declare @Buddy_Total_Android int,@Buddy_Month_Android int,@Buddy_Week_Android int,@Buddy_Day_Android int

---To Get Android Users Data for dashBoard
select @Buddy_Total_Android=COUNT(*) from dbo.Buddy_tracker_User_Details BUD
where BUD.User_From='Android'
select @Buddy_Month_Android=COUNT(*) from dbo.Buddy_tracker_User_Details BUD
where MONTH(BUD.CreatedDate)=MONTH(dateadd(hh,5,dateadd(mi,30,getutcdate()))) and YEAR(BUD.CreatedDate)=YEAR(dateadd(hh,5,dateadd(mi,30,getutcdate()))) and BUD.User_From='Android'
select @Buddy_Week_Android=COUNT(*) from dbo.Buddy_tracker_User_Details BUD
where CONVERT(date,BUD.CreatedDate,103) between CONVERT(date,dateadd(d,-7,dateadd(hh,5,dateadd(mi,30,getutcdate()))),103) and CONVERT(date,dateadd(hh,5,dateadd(mi,30,getutcdate()))) and BUD.User_From='Android'
select @Buddy_Day_Android=COUNT(*) from dbo.Buddy_tracker_User_Details BUD
where CONVERT(date,BUD.CreatedDate,103)=CONVERT(date,dateadd(hh,5,dateadd(mi,30,getutcdate())),103) and BUD.User_From='Android'


select @Buddy_Day_Android as Buddy_Day_Android,@Buddy_Week_Android as Buddy_Week_Android,@Buddy_Month_Android as Buddy_Month_Android,@Buddy_Total_Android as Buddy_Total_Android

end

Datalist Paging in asp.net

http://www.aspdotnetcodes.com/DataList_Dynamic_Paging_PagedDataSource.aspx

Add Youtube Videos in asp.net

 <asp:TextBox ID="txtvideourl" onclick="hide_video();" runat="server" Width="258px"></asp:TextBox>
                    <asp:RequiredFieldValidator ID="rfv_txtvideourl" runat="server" ControlToValidate="txtvideourl"
                        ErrorMessage="Please Enter Video URL" Display="None" SetFocusOnError="true" ValidationGroup="submitvideo"></asp:RequiredFieldValidator>
                    <ajaxToolkit:ValidatorCalloutExtender ID="vce_txtvideourl" runat="server" TargetControlID="rfv_txtvideourl">
                    </ajaxToolkit:ValidatorCalloutExtender>


 protected void btnVideo_Click(object sender, EventArgs e)
    {

        string videourl = string.Empty, filename = string.Empty;
        try
        {
            if (txtvideourl.Text.Contains("http://youtu.be"))
            {
                videourl = txtvideourl.Text;
                string[] arr = new string[5];
                arr = videourl.Split('/');
                filename = arr[3];
                if (ObjBll.Opertaions_on_Videos("", txtVideoName.Text, filename, "True", "Insert"))
                {
                    ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Warning", "alert(' Submited Successfully..')", true);
                    iframe_Video.Visible = true;
                    iframe_Video.Attributes["src"] = "http://www.youtube.com/embed/" + filename;
                    bind_data();
                    txt_Clear();
                }
            }
            else
            {
                txtvideourl.Focus();
                lbl_urlmsg.Text = "Enter Valid URL";
            }
        }
        catch (Exception ex)
        {
            lblMsg.Text = ex.Message.ToString();
        }

How to call java script function from code behind file in asp.net

Example:

 Declare a JavaScript function in the head tag of your design file as shown below:

<head runat="server">
    <title>Calling JavaScript From CodeBehind in asp.net file</title>
    <script type="text/javascript">
        function MyFunction() {
            alert('Demonstration Successfull..');
        }
    </script>
</head>

In order to call it from code behind, use the following code in your Page_Load

protected void Page_Load(object sender, EventArgs e)
{
    if (!ClientScript.IsStartupScriptRegistered("alert"))
    {
        Page.ClientScript.RegisterStartupScript(this.GetType(),
            "alert", "MyFunction();", true);
    }
}