31 January 2012

timer countdown in asp.net

›
Label4.Text = "00"; Label5.Text = "02"; Label6.Text = "00";         if (Label6.Text == "00" || Label...
25 January 2012

Tooltip for dropdownlist items

›
It is common in most web pages that whole text in dropdown lists cannot be seen due to width limitation. One solution for this would be addi...
21 January 2012

change the database name in sqlserver using query

›
Supported in SQL Server 2000 and 2005 exec sp_renamedb 'databasename' , 'newdatabasename' Supported in SQL Server 2005 and l...
07 January 2012

Naming conventions in .net

›
Pascal case The first letter in the identifier and the first letter of each subsequent concatenated word are capitalized. Example: BackColor...

Some Coding Standards in .net

›
1.    Use Meaningful, descriptive words to name variables. Do not use abbreviations.     Good:     string address     int salary      Not Go...

factorial of number in console applications

›
int count = 1; Console.Write("Enter Number for factorial: "); int number = Convert.ToInt32(Console.ReadLine()); for (int i = 1; i ...

palindrome in console applications

›
string str = string.Empty; Console.WriteLine("Enter a String"); string s = Console.ReadLine(); int i = s.Length; for (int j = i - ...
06 January 2012

group by and row no in sql

›
SELECT ROW_NUMBER()   OVER ( ORDER   BY   ColumnName1) As SrNo, ColumnName1,  ColumnName2 FROM   TableName SELECT DENSE_RANK()  OVER (ORD...

sql syntaxes

›
Select Statement SELECT "column_name" FROM "table_name" Distinct SELECT DISTINCT "column_name" FROM "tabl...
02 January 2012

C# Features not in Java

›
•No automatic fall-through from one case block to the next •Strongly-typed enums •By reference calls are explicit at caller AND callee •Meth...

joins example

›
table1                                    table2 col1 col2                           col3   col4  1      a                              1   ...
27 December 2011

ddl in js

›
opt=document.createElement("OPTION"); document.getElementById('ddlPages').options.add(opt); opt.text=cnt-1; opt.value=cnt-...
16 December 2011

how to find server/system name from sqlserver name using query

›
select host_name()
17 November 2011

querystring n gv rows in javascript

›
query string in js: '<%=Request.QueryString["val"]%>'; -------------------------- gridrows in js: Totalrows = parseI...
11 November 2011

ws vs wcf

›
webservices uses XmlSerializer. A Web Service is programmable application logic accessible via standard Web protocols(Simple Object Access P...