Monday, March 15, 2010
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
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:
| Operator | Use |
| ^ | Exponentiation |
| - | Negation (used to reverse the sign of the given value, exp -intValue) |
| * | Multiplication |
| / | Division |
| \ | Integer Division |
| Mod | Modulus Arithmetic |
| + | Addition |
| - | Subtraction |
Concatenation Operators
Concatenation operators join multiple strings into a single string. There are two concatenation operators, + and & as summarized below:
| Operator | Use |
| + | 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:
| Operator | Use |
| = | 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:
| Operator | Use |
| Not | Negation |
| And | Conjunction |
| AndAlso | Conjunction |
| Or | Disjunction |
| OrElse | Disjunction |
| Xor | Disjunction |
VB.Net Operators OR / And / Not 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.
Thursday, February 18, 2010
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
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 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
----------- ---------- ----------- ----------------------- ---------- ------
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: #2SELECT 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 6would becomeProduct Quantity ------- -------- Fruit 2 Fruit 3 Fruit 1 Vegetable 7 Dairy 6 Exp QuerySELECT REPLACE('Banana', REPLACE('Orange', REPLACE('Banana', Product, 'Fruit'), 'Fruit'), 'Fruit') AS Product FROM Table