Enable selection of page where selection is not allowed.
=======================================================================
<style>
::-moz-selection { /* Code for Firefox */
color: white;
background: #0472C1;
}
::selection {
color: white;
background: #0472C1;
}
</style>
========================================================================
Excel Download
private void bindlead()
{
try
{
user.SearchText = txt_search.Text;
user.GetAllLead();
if (user.OperationStatus)
{
DataTable dt = EnquiryData = user.leadTable;
grid_Image.DataSource = dt;
grid_Image.DataBind();
txt_search.Text = "";
}
}
catch (Exception ex)
{
lbl_msg.Text = "Error : " + ex.Message;
lbl_msg.ForeColor = System.Drawing.Color.Red;
}
}
--------------------------------------------------------------------------------------------------------------------------
protected void download_Click(object sender, EventArgs e)
{
CreateExcelFile(EnquiryData);
}
--------------------------------------------------------------------------------------------------------------------------
public void CreateExcelFile(DataTable Excel)
{
Excel.Columns.RemoveAt(0); //removing unwanted columns from datatable.
Excel.Columns.RemoveAt(3);
Excel.Columns.RemoveAt(3);
Response.ClearContent();
string FileName = "Leads.xls";
//Adds HTTP header to the output stream
Response.AddHeader("content-disposition", "attachment; filename=" + FileName);
// Gets or sets the HTTP MIME type of the output stream
Response.ContentType = "application/vnd.ms-excel";
string space = "";
foreach (DataColumn dcolumn in Excel.Columns)
{
Response.Write(space + dcolumn.ColumnName);
space = "\t";
}
Response.Write("\n");
int countcolumn;
foreach (DataRow dr in Excel.Rows)
{
space = "";
for (countcolumn = 0; countcolumn < Excel.Columns.Count; countcolumn++)
{
Response.Write(space + dr[countcolumn].ToString());
space = "\t";
}
Response.Write("\n");
}
Response.End();
}
=======================================================================
FACEBOOK Sharing
<script>
function fbShare(url, winWidth, winHeight) {
var winTop = (screen.height / 2) - (winHeight / 2);
var winLeft = (screen.width / 2) - (winWidth / 2);
window.open(url, width = ' + winWidth + ', height = ' + winHeight+'
);
}
</script>
--------------------------------------------------------------------------------------------------------------------------
<li><a href="javascript:fbShare('https://www.facebook.com/sharer/sharer.php?u=<%#"http://www.karsoo.com/story/"+Regex.Replace(Eval("Title").ToString().ToLower(), "[^a-zA-Z0-9_]+", "-")+"/"+Eval("StoryID").ToString() %>&src=sdkpreparse',520, 350)"><i>
<img src='<%=Page.ResolveUrl("images/share_storyicon.png") %>'></i></a></li>
========================================================================
Find Control
string hdn1=((HiddenField)grid_Image.Rows[e.RowIndex].FindControl("hdn_AgentID")).Value;
-------------------------------------------------------------------------------------------------------------------------
Control div_trBuilders = this.Master.FindControl("trbuilder");
div_trBuilders.Visible = false;
-------------------------------------------------------------------------------------------------------------------------
Label lbl_li = (Label)this.Master.FindControl("Label1");
lbl_li.Text = "About Us";
=======================================================================
FIXED
<div style="position: fixed; padding-top: 80px; right:0; text-align:right;">
<a href="contact-us">
<img src="images/ContactUs--rea.png" alt="Click for enquiry" title="Click for enquiry" width="80%" /></a>
</div>
=======================================================================
Funtion to Pass comma separated (delimited) values as Parameter to Stored Procedure in SQL Server and Filter data
--------------------------------------------------------------------------------------------------------------------------
CREATE FUNCTION [dbo].FN_SplitString
(
@Input NVARCHAR(MAX),
@Character CHAR(1)
)
RETURNS @Output TABLE (
Item NVARCHAR(1000)
)
AS
BEGIN
DECLARE @StartIndex INT, @EndIndex INT
SET @StartIndex = 1
IF SUBSTRING(@Input, LEN(@Input) - 1, LEN(@Input)) <> @Character
BEGIN
SET @Input = @Input + @Character
END
WHILE CHARINDEX(@Character, @Input) > 0
BEGIN
SET @EndIndex = CHARINDEX(@Character, @Input)
INSERT INTO @Output(Item)
SELECT SUBSTRING(@Input, @StartIndex, @EndIndex - 1)
SET @Input = SUBSTRING(@Input, @EndIndex + 1, LEN(@Input))
END
RETURN
END
-----------------------------------------------------------------------------------------------------------------------
Alter proc [dbo].[SP_SearchAllTutorsByCityAndSubjectFront] 'Maths,English','Delhi','VIII,IX,X'
@SearchText nvarchar(max),
@City nvarchar(100),
@Class nvarchar(max)
AS
BEGIN
Select * INTO #Temp from (
Select * from tbl_Tutors
where (@SearchText='' or Subject in (SELECT Item FROM [dbo].FN_SplitString(@SearchText, ',')))) as x
select * from #Temp where (@Class='' or Class in (SELECT Item FROM [dbo].FN_SplitString(@Class, ',')))
and (@City='' or City=@City)
--or Class in (SELECT Item FROM [dbo].FN_SplitString1(@Class, ','))
--and (@City='' or City=@City)
--and (@Class ='' or (',' + RTRIM(Class) + ',') in (@Class))
--and Status='True'
END
=======================================================================
Javascript to Calculate bill
<script type="text/javascript">
function totalBillAmount() {
var taxApplicable = document.getElementById('<%=txtServiceTax.ClientID %>').value;
var discountApplicable = document.getElementById('<%=txtDiscount.ClientID %>').value;
var billAmount = document.getElementById('<%=txtBillAmount.ClientID %>').value;
document.getElementById('<%=txtTotalBillAmount.ClientID %>').value = "";
var totalBillAmount;
if (!isNaN(taxApplicable) && (taxApplicable == ""))
taxApplicable = 0;
if (!isNaN(discountApplicable) && (discountApplicable == ""))
discountApplicable = 0;
totalBillAmount = (parseInt(billAmount) + (parseInt(billAmount) * (parseInt(taxApplicable) / 100)) - parseInt(discountApplicable));
document.getElementById('<%=txtTotalBillAmount.ClientID %>').value = totalBillAmount;
}
</script>
-------------------------------------------------------------------------------------------------------------------------
<asp:TextBox ID="txtBillAmount" runat="server" Width="250px"
onkeyup="totalBillAmount()" ></asp:TextBox>
=======================================================================
Javascript to Check Page Validation
<script type="text/javascript">
function WebForm_OnSubmit() {
if (Page_ClientValidate()) {
return true;
}
else return false;
}
</script>
=======================================================================
Last Page Url using ViewState
if (!Page.IsPostBack)
{
ViewState["RefUrl"] = Request.UrlReferrer.ToString();
}
-----------------------------------------------------------------------------------------------------------------------
object refUrl = ViewState["RefUrl"];
if (refUrl != null)
{
Response.Redirect((string)refUrl);
}
=======================================================================
Lazy Loading Perception
<asp:Repeater ID="Rpt_lifestyle" runat="server" DataSourceID="Sql_story_By_Feeds" >
<ItemTemplate>
<div class="blogboxf2_Left" style="display:none;">
<div class="lifecontent">
<a href='<%# Page.ResolveUrl(WriteUrl2(Eval("Title").ToString(),Eval("StoryID").ToString())) %>' target="_blank">
<asp:HiddenField ID="hdn_Feedit" runat="server" Value='<%# Eval("StoryID").ToString() %>' />
<figure>
<img src='<%# Page.ResolveUrl(Eval("FeatureCoverImage").ToString()) %>'>
</figure>
<figcaption><%#Eval("ShortDescription").ToString().Length>80?Eval("ShortDescription").ToString().Substring(0,80)+"....":Eval("ShortDescription").ToString() %>
</figcaption>
</a>
<asp:UpdatePanel ID="UpdatePanel7" runat="server">
<ContentTemplate>
<div class="btn_navigation">
<ul>
<table collspacing="0" cellpadding="0" style="float: right;" width="100%">
<tr>
<td valign="top" width="10px">
<li style="float: none;">
<a href="javascript:fbShare('https://www.facebook.com/sharer/sharer.php?u=<%#"http://www.karsoo.com/story/"+Regex.Replace(Eval("Title").ToString().ToLower(), "[^a-zA-Z0-9_]+", "-")+"/"+Eval("StoryID").ToString() %>&src=sdkpreparse',520, 350)">
<img src='<%=Page.ResolveUrl("images/share_storyicon.png") %>'></a>
</li>
</td>
</tr>
</table>
</ul>
</div>
</ContentTemplate>
</asp:UpdatePanel>
<%--<div style="float: right;">
</div>--%>
</div></div>
</ItemTemplate>
</asp:Repeater>
-------------------------------------------------------------------------------------------------------------------------
<div class="showmore_result">
<a href="javascript:void(0)" id="loadMore">View more lifestyle <span>»</span></a>
</div>
-------------------------------------------------------------------------------------------------------------------------
<script type="text/javascript">
/*
Load more content with jQuery - May 21, 2013
(c) 2013 @ElmahdiMahmoud
Note : .blogboxf2_Left is the class of div which is repeating in Repeater Item Template and loadMore is the
Id of control on click of which we want to achieve lazy loading .
*/
$(function () {
$(".blogboxf2_Left").slice(0, 10).show();
$("#loadMore").on('click', function (e) {
e.preventDefault();
$(".blogboxf2_Left:hidden").slice(0, 10).slideDown(0);
if ($(".blogboxf2_Left:hidden").length == 0) {
$("#loadMore").hide();
}
});
});
</script>
--------------------------------------------------------------------------------------------------------------------------
Note : .blogboxf2_Left is the class of div which is repeating in Repeater Item Template and loadMore is the
Id of control on click of which we want to achieve lazy loading. An Inline style code is also required to put in repeating div in Item Template
as style="display:none;".
========================================================================
Listview
<asp:ListView ID="ListView1" runat="server">
<EmptyDataTemplate>
<div class="product_box3 hover-border">
<div align="center" width="100%" style="font-family: 'Roboto Condensed', sans-serif;
color: Red">
Sorry, No Project available as your search criteria.
</div>
</div>
</EmptyDataTemplate>
<GroupTemplate>
<div class="product_box3 hover-border" id="itemPlaceholderContainer" runat="server">
<div id="itemPlaceholder" runat="server">
</div>
</div>
</GroupTemplate>
<ItemTemplate>
<div class="product_item">
<div>
<a href='<%#Page.ResolveUrl(WriteUrl1(Eval("ProjectName").ToString(),Eval("ProjectID").ToString())) %> '
target="_blank" style="text-decoration: none;">
<h6>
<%# Eval("ProjectName") %></h6>
</a>
</div>
<div>
<h5>
<%# Eval("ProjectLocality") + ", " + Eval("ProjectCity")%></h5>
</div>
<a href='<%#Page.ResolveUrl(WriteUrl1(Eval("ProjectName").ToString(),Eval("ProjectID").ToString())) %> '
target="_blank" style="text-decoration: none;">
<img src='<%# "http://www.jungleehomes.com/"+Eval("ProjectImagePath").ToString().Remove(0,2) %>'
alt='<%# Eval("ProjectName") %>' width="100%" height="150px" /></a>
<div class="product_text2">
<div class="type-formate">
Unit Type
<div class="clearfix">
</div>
</div>
<div class="dot-fromate">
:</div>
<div>
<%# Eval("ProjectPlan")%>
<%#Eval("ProjectType") %>
<asp:HiddenField ID="hdnid" runat="server" Value='<%#Eval("ProjectID") %>' />
</div>
</div>
<div class="product_text2">
<div class="type-formate">
Sizes
</div>
<div class="dot-fromate">
:</div>
<div>
<asp:Repeater ID="Repeater1" runat="server" DataSourceID="SqlDataSource_size">
<ItemTemplate>
<%# Eval("Size")%></ItemTemplate>
</asp:Repeater>
</div>
<asp:SqlDataSource ID="SqlDataSource_size" runat="server" ConnectionString="<%$ ConnectionStrings:connectionstring %>"
SelectCommand="SP_GetProjectSize" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:ControlParameter Name="ProjectID" ControlID="hdnid" DefaultValue="-1" PropertyName="Value"
Type="Double" />
</SelectParameters>
</asp:SqlDataSource>
</div>
<div class="product_text2">
<div class="type-formate">
Price</div>
<div class="dot-fromate">
:</div>
<div>
Rs.
<%# !String.IsNullOrEmpty(Convert.ToString(Eval("ProjectPriceRangeMin")))?NumberToWords(Convert.ToDouble(Eval("ProjectPriceRangeMin"))):"0"%>
-
<%# !String.IsNullOrEmpty(Convert.ToString(Eval("ProjectPriceRangeMax"))) ? NumberToWords(Convert.ToDouble(Eval("ProjectPriceRangeMax"))) : "0"%>
</div>
</div>
<div class="read">
<div class="read_more1">
<a href='<%#Page.ResolveUrl(WriteUrl1(Eval("ProjectName").ToString(),Eval("ProjectID").ToString())) %> '
target="_blank">View Details</a></div>
</div>
</div>
<div class="clearfix">
</div>
</ItemTemplate>
</asp:ListView>
========================================================================
Live Chat
https://account.zopim.com/account/login?redirect_to=%2Faccount%2F#signup
Create Id in Zopim for website or company and then you'll get code like below, use it in head section.
-------------------------------------------------------------------------------------------------------------------------
<!--Start of Zopim Live Chat Script-->
<script type="text/javascript">
window.$zopim || (function (d, s) {
var z = $zopim = function (c) { z._.push(c) }, $ = z.s =
d.createElement(s), e = d.getElementsByTagName(s)[0]; z.set = function (o) {
z.set.
_.push(o)
}; z._ = []; z.set._ = []; $.async = !0; $.setAttribute("charset", "utf-8");
$.src = "//v2.zopim.com/?3jGbp4XUeAYL9PciWy5ehnD7hYPNkeDi"; z.t = +new Date; $.
type = "text/javascript"; e.parentNode.insertBefore($, e)
})(document, "script");
</script>
<!--End of Zopim Live Chat Script-->
========================================================================
Loader using Jquery
<div style="position: fixed; top: 45%; left: 45%;" id="div_Loader">
<div style="position: absolute; z-index: 10000; margin: auto; color: blue;">
<img alt="Please Wailt..." src='<%= Page.ResolveUrl("~/images/new_loader.gif") %>' />
</div>
</div>
-------------------------------------------------------------------------------------------------------------------------
We can call show funtion on onchange event of dropdownlist or checkbox or onclientclick of button etc..
<script type="text/javascript">
$(document).ready(function () {
$("#div_Loader").hide();
});
function Show() {
$('#div_Loader').show();
}
function Hide() {
$('#div_Loader').hide();
}
</script>
--------------------------------------------------------------------------------------------------------------------------
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Hide", "Hide()", true);
========================================================================
OR
========================================================================
<script type="text/javascript">
$(document).ready(function () {
HideLoader();
});
function ShowLoader() {
$('#ProgressBar').show()
}
function HideLoader() {
$('#ProgressBar').hide();
}
</script>
--------------------------------------------------------------------------------------------------------------------------
<div class="modal" id="ProgressBar">
<div class="center">
<asp:Image ImageUrl="~/images/loader22.gif" runat="server" ID="imgprog" />
<img alt="Please Wait....." src='<%=Page.ResolveUrl("images/loader22.gif") %>' runat="server" id="img1" />
</div>
</div>
========================================================================
Email Format
string body1 = "Dear, " + txt_name.Text + "<br/><br/> Greetings of the day<br/><br/>Thanks for your enquiry on iDesign . We will contact you soon.<br/><br/>Thanks<br/><br/>Team iDesign <br/><br/>www.idesign.com";
Class_Additionalresources.Sendmail(txt_email.Text.Trim(), "idesign Project ", body1, "idesign Project ", "info@idesignproject.com");
========================================================================
Max charcount in string program
protected void Button1_Click(object sender, EventArgs e)
{
int count = 0, Max = 0;
int len = 0;
string ch=string.Empty;
string str = TextBox1.Text;
len = TextBox1.Text.Length;
for (int j = 0; j < len; j++)
{
count = 0;
for (int i = 0; i < len; i++)
{
if (str[j] == str[i])
{
count++;
}
if (count > Max)
{
Max = count;
ch = str[i].ToString();
}
}
}
TextBox2.Text = ch.ToString();
TextBox3.Text = len.ToString();
}
