Anuj Chauhan

Updatepanel gives full postback instead of asyncpostback When using Dropdownlist inside listview inside Updatepanel . This Problem i faced when i had a listview which dynamically gets items and populates itemtemplate with dropdownlists . I had this listview inside an updatepanel and when selectionchanged event fires a complete postback was fired .

Solution to this problem i found out at this link http://stackoverflow.com/questions/4319156/updatepanel-gives-full-postback-instead-of-asyncpostback

OR

you can directly add ClientIDMode="AutoID"in listview

ASP.NET UpdatePanel, ASP.NET AJAX

Solution to this problem is
We have to add these four lines in every page ( which you want to make not cacheable ) . I have added these lines in Masterpage on OnInit() function.

protected override void OnInit(EventArgs e)
{
Response.Cache.SetExpires(DateTime.UtcNow.AddMinutes(-1));
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Cache.SetAllowResponseInBrowserHistory(false);
Response.Cache.SetNoStore();
base.OnInit(e);
}

ASP.NET Logout, Cache

The solution i found for this problem is on this blog post .

http://stackoverflow.com/questions/4736140/login-failed-for-user-iis-apppool-classic-net-apppool

• Go into IIS Manager
• On the node with your computer name, select "Application Pools"
• Click "Classic .NET AppPool" and select "Advanced Settings..."
• Select "Identity" property and change its value to "LocalSystem"

IIS IIS APPPOOL Classic .NET AppPool

How to to verify case sensitive columns in SQL SERVER having Case insensitive Collation.

Use this query

SELECT * FROM LoginData WHERE username ='something' AND password COLLATE SQL_Latin1_General_CP1_CS_AS LIKE 'askjashAA';

OR

SELECT * FROM LoginData WHERE username LIKE 'something' AND password COLLATE SQL_Latin1_General_CP1_CS_AS LIKE 'askjashAA';

SQL Case insensitive SQL, check username password

How to disable default click of a hyperlink in html

We can use below statement in href of any hyperlink tag .

<a href='javascript:;' >something</a>

Javascript js

Suddenly my controls stop working and no postback was fired when buttons clicked . This problem occurred because i added  by mistake some html code in my form which included its own form hence my already working controls stopped .

ASP.NET postback not working in buttons

SELECT TOP 5 temp.totalcomments,NewsLetter.title,NewsLetter.nID 
FROM 
(SELECT NewsLetter.nID,NewsLetter.title ,COUNT(a.nID) AS TotalComments 
FROM NewsLetter LEFT OUTER JOIN (select nID from Comments where approved='true') as a 
ON a.nID=NewsLetter.nID 
GROUP BY NewsLetter.nID,NewsLetter.title) AS temp,Newsletter 
WHERE scID=10 AND temp.nID=NewsLetter.nID AND trash='false' 
ORDER BY totalcomments DESC;

SQL Query for getting the childtable no of rows related to one single row in parent table

A very good answer to this problem is provided on this blog post .

http://stackoverflow.com/questions/605189/how-can-i-sort-listt-based-on-properties-of-t

_list.Sort((a,b)=> String.Compare(a.Name,b.Name));

_list.Sort((a,b)=> a.SomethingInteger.CompareTo(b.SomethingInteger));

C# List<T>, Generic List Sorting

This error comes when you try to get user input in raw html through a textbox control in order to resolve this you will have to include ValidateRequest="false"

in

<%@ Page Title="" ValidateRequest="false" Language="C#" MasterPageFile="" AutoEventWireup="true" CodeBehind="" Inherits="" %>

and also you will have to include this

<configuration>
<system.web>
<compilation debug="true" targetFramework="4.0" />
<httpRuntime requestValidationMode="2.0"/>
</system.web>
</configuration> 

in your web.config file

ASP.NET html in textbox

This is a nice blog post for migrating TFS 2010 Project Collection to another TFS 2010 server

http://rmlinar.net/blog/2011/12/27/migrate-tfs-2010-project-collection-to-another-tfs-2010-server/

Team Foundation Server 2010 migrate TFS