copy an array to hidden field and get back to array in javascript

   

Values are only strings or integers and a seperator(',') should not present in an array.


                        document.getElementById("hiddenfield").value = oldArray.join(",");

To retreive that array back

                          NewArray = document.getElementById("hiddenfield").value.split(",");

detect browser in web application using Jquery and ASP.Net C#

Using Jquery we can detect current browser and their version.


$(document).ready(function() {
   if ($.browser.mozilla && $.browser.version >= "2.0" ){
    alert('Mozilla above 1.9');
   }
  
   if( $.browser.safari ){
    alert('Safari');
   }
 
   if( $.browser.opera){
    alert('Opera');
   }
 
   if ($.browser.msie && $.browser.version <= 6 ){
    alert('IE 6 or below version');
   }
 
   if ($.browser.msie && $.browser.version > 6){
    alert('IE above 6');
   }
 });


Using ASP.NET

 Response.Write("Request.Browser.Type--------------------->" + Request.Browser.Type);

                Response.Write("<br/>Request.Browser.Version  ----------->   " + Request.Browser.Version);

                Response.Write("<br/>Request.Browser.W3CDomVersion------->" + Request.Browser.W3CDomVersion);

                Response.Write("<br/>Request.Browser.Browser------------->" + Request.Browser.Browser);

                Response.Write("<br/>Request.Browser.Browsers------------>" + Request.Browser.Browsers);

                Response.Write("<br/>Request.Browser.MajorVersion-------->" + Request.Browser.MajorVersion);

OUTPUT

Request.Browser.Type--------------------->IE10
Request.Browser.Version -----------> 10.0
Request.Browser.W3CDomVersion------->1.0
Request.Browser.Browser------------->IE
Request.Browser.Browsers------------>System.Collections.ArrayList
Request.Browser.MajorVersion-------->10
 

Serach Column in Existing table in Database and alter table

/*ADD one column "ColumnName" in table TableName */
 
 IF NOT EXISTS  ( SELECT 'X' FROM INFORMATION_SCHEMA.COLUMNS COLUMNS, INFORMATION_SCHEMA.TABLES TABLES

WHERE
COLUMNS.TABLE_NAME=TABLES.TABLE_NAME AND UPPER(COLUMNS.COLUMN_NAME)=UPPER('ColumnName') AND UPPER(TABLES.TABLE_NAME) = UPPER('TableName'))

BEGIN

ALTER TABLE  TableName    ADD ColumnName   INT Default(0)

END

GO

How can combine multiple column as a one column in SQL SERVER?

Suppose there is a table Employee and recordset as

EmpID	Name	Sal
1	PQR	1000
2	XYZ	2000
3	ABC	3000

And aspected Result as

FieldName	Value
EmpID	1
Name	PQR
Sal	1000
EmpID	2
Name	XYZ
Sal	2000
EmpID	3
Name	ABC
Sal	3000

Query -

SELECT  FieldName, Value
FROM
(
    SELECT CAST(EmpID AS VARCHAR(10))EmpID,
    CAST(name AS VARCHAR(10)) Name,
    CAST(sal AS VARCHAR(10)) Sal
    FROM Employee
)x
UNPIVOT
(
Value
FOR FieldName in (EmpID,Name,Sal)
)y