Jan 3, 2018

How to show limited characters in asp.net gridview column display on javasctipt alert by using asp.net javascript

In asp.net gridview, here we have to hide all extra characters and display only limited number of characters by clicking on gridview column with the help of java script function placed on anchor tag in asp.net gridview column of ItemTemplate.

Source Code : 

<asp:GridView ID="gvRpts" runat="server" AutoGenerateColumns="False
Width="100%" >
<Columns>
 <asp:BoundField DataField="Date" HeaderText="Date" ></asp:BoundField>
<asp:TemplateField HeaderText="Particulars">
<EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server"
Text='<%# Bind("Particulars") %>'></asp:TextBox>                                    </EditItemTemplate>
<ItemTemplate>
<a id="anchrID" onclick="javascript:showExtraChars('<%# Eval("Particulars") %>')" >
<asp:Label ID="Label2" runat="server"
Text='<%#Eval("Particulars").ToString().Length <= 25 ? Eval("Particulars") : (Eval("Particulars") as string).Substring(0,26)+"..."  %>'>
</asp:Label></a>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>


 Javascript Code :

<script language="javascript" type="text/javascript">

function showExtraChars (reason) {
        if (reason == null || reason == "")
            alert('Empty data… ');
        else
            alert(reason);
    }


</script>


Result : 






























Jan 2, 2018

get weekly data (Lastweek, Thisweek and Nextweek) in sql server



declare @TodaysDate datetime;
set @TodaysDate = getdate();

select convert(varchar(20), dateadd(wk, datediff(wk, 0, @TodaysDate) -1, 0), 107) LastWeekStart
select convert(varchar(15), dateadd(wk, datediff(wk, 0, @TodaysDate), -1), 107) LastWeekEnd

select convert(varchar(15), dateadd(wk, datediff(wk, 0, @TodaysDate), 0), 107) ThisWeekStart
select convert(varchar(15), dateadd(wk, datediff(wk, 0, @TodaysDate) +1, -1),107) ThisWeekEnd

select convert(varchar(15), dateadd(wk, datediff(wk, 0, @TodaysDate) + 1, 0),107) NextWeekStart
select convert(varchar(15), dateadd(wk, datediff(wk, 0, @TodaysDate) +2 , -1),107) NextWeekEnd


OR || Required date format - Monthname dd, yyyy


declare @TodaysDate datetime;
set @TodaysDate = getdate();
-- with this (December 31, 2017) date format
select datename(mm, convert(varchar(15), dateadd(wk, datediff(wk, 0, @TodaysDate)-1, 0), 107))
+' '+ replace(convert(varchar(15), dateadd(wk, datediff(wk, 0, @TodaysDate)-1, 0), 107),
left(convert(varchar(15), dateadd(wk, datediff(wk, 0, @TodaysDate)-1, 0), 107),4),'') LastWeekStart

select datename(mm, convert(varchar(15), dateadd(wk, datediff(wk, 0, @TodaysDate), -1), 107))
+' '+ replace(convert(varchar(15), dateadd(wk, datediff(wk, 0, @TodaysDate), -1), 107) ,
left(convert(varchar(15), dateadd(wk, datediff(wk, 0, @TodaysDate), -1), 107) ,4),'')  LastWeekEnd

select datename(mm,convert(varchar(15), dateadd(wk, datediff(wk, 0, @TodaysDate), 0), 107))
+' '+ replace(convert(varchar(15), dateadd(wk, datediff(wk, 0, @TodaysDate), 0), 107),
left(convert(varchar(15), dateadd(wk, datediff(wk, 0, @TodaysDate), 0), 107), 4), '') ThisWeekStart

select datename(mm,convert(varchar(15), dateadd(wk, datediff(wk, 0, @TodaysDate) +1, -1),107))
+' '+ replace(convert(varchar(15), dateadd(wk, datediff(wk, 0, @TodaysDate) +1, -1),107),
left(convert(varchar(15), dateadd(wk, datediff(wk, 0, @TodaysDate) +1, -1),107),4),'') ThisWeekEnd

select datename(mm,convert(varchar(15), dateadd(wk, datediff(wk, 0, @TodaysDate) + 1, 0),107))
+' '+ replace(convert(varchar(15), dateadd(wk, datediff(wk, 0, @TodaysDate) + 1, 0),107),
left(convert(varchar(15), dateadd(wk, datediff(wk, 0, @TodaysDate) + 1, 0),107),4),'') NextWeekStart

select datename(mm,convert(varchar(15), dateadd(wk,datediff(wk, 0, @TodaysDate) +2 , -1),107))
+' '+ replace(convert(varchar(15), dateadd(wk,datediff(wk, 0, @TodaysDate) +2 , -1),107),

left(convert(varchar(15), dateadd(wk,datediff(wk, 0, @TodaysDate) +2 , -1),107),4),'') NextWeekEnd


Result :