Monday, March 15, 2010

Zindagi Ke Safar Mein

Zindagi Ke Safar Mein





Mera kuch saamaan tumhare paas pada hai

Mera kuch saamaan tumhare paas pada hai 
o o o ! saavan ke kuch bheege bheege din rakhe hain
aur mere ik khat main lipti raat padi hai
vo raat bhulaa do, mera vo saamaan lauta do -
mera kuch saamaan tumhaare paas pada hai 

patjhad hai kcuh ... hai na ?
o ! patjhas main kuch patton ke girne kee aahat
kaanon main ek baar pahan ke laut aai thee
patajhad kee vo saakh abhi tak kaanp rahi hai
vo saakh gira do, mera vo saamaan lauta do 

ek akeli chhataree main jab aadhe aadhe bheeg rahe the 
aadhe sookhe aadhe geele, sukha to main le aaye thee
geela man shayad bistar ke paas pada ho
vo bhijwa do, mera vo saamaan lauta do

ek so sola chaand ki ratain ek tumhare kaandhe ka til 
geeli mahendi ki khushbu, jhoot mooth ke shikwe kuch
jhooth mooth ke wade sab yaad karaa do
sab bhijwa do, mera vo saamaan lauta do

ek ijaazat de do bas, jab isako dafanaaungee
main bhi vaheen so jaungee
main bhi vaheen so jaungee

Baareeshon Kee Paanee Se

Chhoti Si Kahani Se

Chhotee See Kahaanee Se,
Baareeshon Kee Paanee Se
Saaree Waadee Bhar Gayee,
Naa Jaane Kyo, Dil Bhar Gayaa,
Naa Jaane Kyo, Aankh Bhar Gayee

Shaakho Pe Patte The,patton Pe Boonde Thee
Boondo Mein Paanee Thaa,paanee Mein Aansoo The

Dil Mein Geele Bhee The,pahale Mile Bhee The
Milake Paraaye The,do Humasaaye The










Sunday, March 07, 2010

VB.Net Operators ( And / OR ....)

VB.Net Operators

Visual Basic comes with many built-in operators that allow us to manipulate data. An operator performs a function on one or more operands. For example, we add two variables with the "+" addition operator and store the result in a third variable with the "=" assignment operator like this: int x + int y = int z. The two variables (x ,y) are called operands. There are different types of operators in Visual Basic and they are described below in the order of their precedence.

Arithmetic Operators

Arithmetic operators are used to perform arithmetic operations that involve calculation of numeric values. The table below summarizes them:

OperatorUse
^Exponentiation
-Negation (used to reverse the sign of the given value, exp -intValue)
*Multiplication
/Division
\Integer Division
ModModulus Arithmetic
+Addition
-Subtraction

Concatenation Operators

Concatenation operators join multiple strings into a single string. There are two concatenation operators, + and & as summarized below:

OperatorUse
+String Concatenation
&String Concatenation

Comparison Operators

A comparison operator compares operands and returns a logical value based on whether the comparison is true or not. The table below summarizes them:

OperatorUse
= Equality
<>Inequality
<Less than
>Greater than
>=Greater than or equal to
<=Less than or equal to

Logical / Bitwise Operators

The logical operators compare Boolean expressions and return a Boolean result. In short, logical operators are expressions which return a true or false result over a conditional expression. The table below summarizes them:

OperatorUse
Not Negation
AndConjunction
AndAlsoConjunction
Or Disjunction
OrElse Disjunction
Xor Disjunction






VB.Net Operators OR / And / Not Equal ....

HTML clipboard= Tests whether two values are equal.

<> Tests whether two values are not equal.

< Tests whether the first value is less than the second value.

> Tests whether the first value is greater than the second value.

<= Tests whether the first value is less than or equal to the second value.

>= Tests whether the first value is greater than or equal to the second value.
Daniel Powter's BAD DAY
Song: Bad Day...
by
Daniel





Thursday, February 18, 2010

SQL SERVER Replace Query

SQL SERVER Replace Query/

Using REPLACE in an UPDATE statement




SELECT Replace
('SQLTeam.com Rocks!', 'Rocks', 'Rolls')

Wednesday, February 17, 2010

Combining JavaScript with ASP.NET

A powerful combination

JavaScript is the de facto standard for client-side Web development. Combining it with ASP.NET Web forms provides the developer with a powerful set of tools for building robust applications that consider performance a key ingredient.


Private
btnSearch_Click (sender As Object, e As System.EventArgs)

Response.Write("Search")


End Sub


Private Page_Load(sender As Object, e As System.EventArgs)

btnSubmit.Attributes.Add("onClick", "return valSubmit();")

End Sub



-------------------------------------------

Monday, February 15, 2010

SQL SERVER SELECT IS NOT NULL

SQL SERVER SELECT IS NOT NULL

ID name salary start_date city region
------ ---------- ----------- ----------------------- ---------- ------
1 Jason 40420 1994-02-01 00:00:00.000 New York W
2 Robert 14420 1995-01-02 00:00:00.000 Vancouver N
3 Celia 24020 1996-12-03 00:00:00.000 Toronto W
4 Linda 40620 1997-11-04 00:00:00.000 New York N
5 null 80026 1998-10-05 00:00:00.000 Vancouver W
6 null 70060 1999-09-06 00:00:00.000 Toronto N
7 null 90620 2000-08-07 00:00:00.000 New York W
8 Chris 26020 2001-07-08 00:00:00.000 Vancouver N
9 Mary 60020 2002-06-09 00:00:00.000 Toronto W


1>
2> SELECT City, Region, COUNT(*) 'Employees'
3> FROM Employee
4> WHERE Name IS NOT NULL


ID name salary start_date city region
----------- ---------- ----------- ----------------------- ---------- ------
1 Jason 40420 1994-02-01 00:00:00.000 New York W
2 Robert 14420 1995-01-02 00:00:00.000 Vancouver N
3 Celia 24020 1996-12-03 00:00:00.000 Toronto W
4 Linda 40620 1997-11-04 00:00:00.000 New York N
5 David 80026 1998-10-05 00:00:00.000 Vancouver W
6 James 70060 1999-09-06 00:00:00.000 Toronto N
7 Alison 90620 2000-08-07 00:00:00.000 New York W
8 Chris 26020 2001-07-08 00:00:00.000 Vancouver N
9 Mary 60020 2002-06-09 00:00:00.000 Toronto W

DropDownList onChange javascript call

DropDownList onChange javascript call


-- begin aspx code --










-- end aspx code --


Sunday, February 14, 2010

Replace String in SQL Query (SQL Server Replase)

Exp: #1
Select replace(((Col_name)), '-', '==') as filtercol from tablname


Exp: #2
SELECT REPLACE('AsmA Qureshi Software Developer','Software Developer','Project Manager') as AQCOL

S.No      AQCOL
-------  -----------------------------
1         AsmA Qureshi Project Manager-------  -----------------------------

Exp: #3
SELECT
 REPLACE('Banana', REPLACE('Orange', REPLACE('Banana', Product, 'Fruit'),
          'Fruit'), 'Fruit') AS Product
FROM
 Table


Product     Quantity
-------     --------
Apple       2
Orange      3
Banana      1
Vegetable   7
Dairy       6

would become


Product     Quantity
-------     --------
Fruit       2
Fruit       3
Fruit       1
Vegetable   7
Dairy       6

Exp Query 
SELECT
 REPLACE('Banana', REPLACE('Orange', REPLACE('Banana', Product, 'Fruit'),
          'Fruit'), 'Fruit') AS Product
FROM
 Table