Code Simplified – Viral Sarvaiya

Code Simplified – Viral Sarvaiya, Web Developer Friends, dot net Developer, Sql Server Developer

Archive for February, 2011

Server Variables in asp.net

Posted by Viral Sarvaiya on February 26, 2011


hi to all,

here is all the server variables with examples that we use in day to day life in asp.net…

Server Variable Value
ALL_HTTP HTTP_CONNECTION:keep-alive HTTP_KEEP_ALIVE:115 HTTP_ACCEPT:text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 HTTP_ACCEPT_CHARSET:ISO-8859-1,utf-8;q=0.7,*;q=0.7 HTTP_ACCEPT_ENCODING:gzip,deflate HTTP_ACCEPT_LANGUAGE:en-us,en;q=0.5 HTTP_COOKIE:ASPSESSIONIDSSTTCSSB=GANGPOMDLDACPIBLKMJHDDFO; qsg=34; QUADIDX=107; __utma=132845726.461764672.1298712757.1298712757.1298712757.1; __utmb=132845726.4.10.1298712757; __utmc=132845726; __utmz=132845726.1298712757.1.1.utmcsr=google|utmccn=(organic)|utmcmd=organic|utmctr=stored%20procedure%20in%20sql%20server; WT_FPC=id=117.196.1.15-3099774992.30125098:lv=1298664215323:ss=1298664161173; ASPSESSIONIDCCCAQRSB=EEEKIKMDAHHEMLMDGMAGOIKP HTTP_HOST:www.asp101.com HTTP_REFERER:http://www.asp101.com/samples/index.asp HTTP_USER_AGENT:Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13 HTTP_X_REWRITE_URL:/samples/servvars.asp
ALL_RAW Connection: keep-alive Keep-Alive: 115 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7 Accept-Encoding: gzip,deflate Accept-Language: en-us,en;q=0.5 Cookie: ASPSESSIONIDSSTTCSSB=GANGPOMDLDACPIBLKMJHDDFO; qsg=34; QUADIDX=107; __utma=132845726.461764672.1298712757.1298712757.1298712757.1; __utmb=132845726.4.10.1298712757; __utmc=132845726; __utmz=132845726.1298712757.1.1.utmcsr=google|utmccn=(organic)|utmcmd=organic|utmctr=stored%20procedure%20in%20sql%20server; WT_FPC=id=117.196.1.15-3099774992.30125098:lv=1298664215323:ss=1298664161173; ASPSESSIONIDCCCAQRSB=EEEKIKMDAHHEMLMDGMAGOIKP Host: http://www.asp101.com Referer: http://www.asp101.com/samples/index.asp User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13 X-REWRITE-URL: /samples/servvars.asp
APPL_MD_PATH /LM/W3SVC/40/Root/samples
APPL_PHYSICAL_PATH D:\Inetpub\WWWROOT\Path1\path\www\path
AUTH_PASSWORD
AUTH_TYPE
AUTH_USER
CERT_COOKIE
CERT_FLAGS
CERT_ISSUER
CERT_KEYSIZE
CERT_SECRETKEYSIZE
CERT_SERIALNUMBER
CERT_SERVER_ISSUER
CERT_SERVER_SUBJECT
CERT_SUBJECT
CONTENT_LENGTH 0
CONTENT_TYPE
GATEWAY_INTERFACE CGI/1.1
HTTPS off
HTTPS_KEYSIZE
HTTPS_SECRETKEYSIZE
HTTPS_SERVER_ISSUER
HTTPS_SERVER_SUBJECT
INSTANCE_ID 40
INSTANCE_META_PATH /LM/W3SVC/40
LOCAL_ADDR 10.2.81.62
LOGON_USER
PATH_INFO path\pagename.aspx
PATH_TRANSLATED D:\Inetpub\WWWROOT\Path1\path\www\path\pagename.aspx
QUERY_STRING
REMOTE_ADDR 117.196.15.21
REMOTE_HOST 117.196.15.21
REMOTE_USER
REQUEST_METHOD GET
SCRIPT_NAME /path/pagename.aspx
SERVER_NAME http://www.Server.com
SERVER_PORT 80
SERVER_PORT_SECURE 0
SERVER_PROTOCOL HTTP/1.1
SERVER_SOFTWARE Microsoft-IIS/6.0
URL /path/page.aspx
HTTP_CONNECTION keep-alive
HTTP_KEEP_ALIVE 115
HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_CHARSET ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_ENCODING gzip,deflate
HTTP_ACCEPT_LANGUAGE en-us,en;q=0.5
HTTP_COOKIE ASPSESSIONIDSSTTCSSB=GANGPOMDLDACPIBLKMJHDDFO; qsg=34; QUADIDX=107; __utma=132845726.461764672.1298712757.1298712757.1298712757.1; __utmb=132845726.4.10.1298712757; __utmc=132845726; __utmz=132845726.1298712757.1.1.utmcsr=google|utmccn=(organic)|utmcmd=organic|utmctr=stored%20procedure%20in%20sql%20server; WT_FPC=id=117.196.1.15-3099774992.30125098:lv=1298664215323:ss=1298664161173; ASPSESSIONIDCCCAQRSB=EEEKIKMDAHHEMLMDGMAGOIKP
HTTP_HOST http://www.sitename.com
HTTP_REFERER http://www.website.com/ index.aspx
HTTP_USER_AGENT Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13
HTTP_X_REWRITE_URL /page.aspx

hope this all useful to you..

Happy Coding…

Posted in .Net, ASP.NET | Tagged: , | Leave a Comment »

SQL Server: Return Multiple Values from a Function

Posted by Viral Sarvaiya on February 10, 2011


hi

we know that function can return value and stored procedure cannot return value.

but function can return more than 1 value,

but the return type should be table.

so how can we do that..?

Click here.

thank you…

Posted in Sql Server | Tagged: , , , , | Leave a Comment »

 
%d bloggers like this: