SQL - CASE in a WHERE clause

Case statement in where clause

1. SELECT T2.*, T1.*
2.      FROM T1, T2
3.    WHERE (CASE WHEN T2.COMPARE_TYPE = 'A' AND
4.                      T1.SOME_TYPE LIKE 'NOTHING%'
5.                 THEN 1
6.                 WHEN T2.COMPARE_TYPE != 'A' AND
7.                      T1.SOME_TYPE NOT LIKE 'NOTHING%' 
8.                   THEN 1
9.                ELSE 0
10.           END) = 1

    
    

    Result

    
    C        SEQ SOME_TYPE
    - ---------- -----------
    A          1 NOTHING 1
    A          2 NOTHING 2
    B          3 SOMETHING 1
    B          4 SOMETHING 2
    B          5 SOMETHING 3
    B          6 SOMETHING 4
    

To Reference ASP.Net Master page content, content pages

To Access Content Page TextBox Value in MasterPage:

TextBox txtB = (TextBox)ContentPlaceHolder1.FindControl("txtContentPg");
txtMaster.Text = "Content Page TextBox Value: " + txtB.Text;

To Access Master Page Label Value in ContentPage:

Label l1 = (Label)Master.FindControl("lblMaster");
lblContentPg.Text = "Master Page Label = "+l1.Text;

clear combobox Items

dim strEmpty as string={}

combobox.datasource=strEmpty

combobox.databind()

Case sensitive search in SQL Server queries

Password Case Sensitive Search

Use COLLATE clause in your T-SQL statement.

SELECT * FROM dbo.TableName WHERE username=@username 

and Password = @ password COLLATE SQL_Latin1_General_CP1_CS_AS

Cannot use a leading .. to exit above the top directory

What this means is that your web page is referring to content which is in the folder one level up from your page, but your page is already in the website's root folder, so the relative path is invalid. Judging by your exception message it looks like an image control is causing the problem.

You must have something like:-

<asp:Image ImageUrl="..\foo.jpg" />

But since the page itself is in the root folder of the website, it cannot refer to content one level up, which is what the leading ..\ is doing.

How to find a text inside SQL Server procedures / triggers?

1) Search in All Objects

This script search stored procedures, views, functions as well other objects.
-- Search in All Objects
SELECT OBJECT_NAME(OBJECT_ID),
definition
FROM sys.sql_modules
WHERE definition LIKE '% iID %'
GO

2) Search in Stored Procedure

This script search only stored procedure for specified column.
-- Search in Stored Procedure Only
SELECT DISTINCT OBJECT_NAME(OBJECT_ID),
object_definition(OBJECT_ID)
FROM sys.Procedures
WHERE object_definition(OBJECT_ID) LIKE '% iID %'
GO

Assign Value to Asp.Net TextBox with mode=”Password”

 Using ASP.NET, the default textbox in password mode (TextMode="Password") has the following restrictions:

• The password can not be set (e.g., tbPassword.Text = "ThePassword";)
• The password is not restored after a postback

Both restrictions make perfect sense for security reasons. Nonetheless, sometimes the above behaviour is not wanted (especially during development).

The new PasswordTextBox control is an extension of the standard ASP.NET TextBox and makes a password textbox behave like a regular textbox.

PasswordTextbox.Attributes.Add("value", "ThePassword");

Use this to set the value, instead of setting the Text Property.