Following is a small demonstration of getting the first character of a string in capital letter.
print upper(left('manas', 1)) + right('manas', len('manas') - 1)
Thursday, January 1, 2009
Thursday, November 27, 2008
Microsoft JScript runtime error: 'Sys' is undefined
This is a common issue which occurs often when the web config file is not configured.
To resolve this issue add following to web.config file.
==================================================
<httpHandlers>
<remove verb="*" path="*.asmx"/>
<add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false"/>
</httpHandlers>
<httpModules>
<add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
</httpModules>
==================================================
To resolve this issue add following to web.config file.
==================================================
<httpHandlers>
<remove verb="*" path="*.asmx"/>
<add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false"/>
</httpHandlers>
<httpModules>
<add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
</httpModules>
==================================================
Friday, October 17, 2008
Find n th highest salary
SELECT MIN(SALARY) FROM EMP WHERE
SALARY IN (SELECT DISTINCT TOP N SALARY FROM EMP ORDER BY SALARY DESC)
Monday, October 13, 2008
Export file to client
Following function downloads specified file from server to client.
=============================================
public static void DownloadFiles(string FileName)
{
HttpContext context = HttpContext.Current;
context.Response.AddHeader("Content-Disposition", "attachment; filename=" + FileName);
context.Response.ContentType = "application/xml";
string Path = context.Server.MapPath(FileName);
try
{
context.Response.WriteFile(Path);
}
catch (Exception ex) { }
context.Response.Flush();
context.Response.End();
}
=============================================
public static void DownloadFiles(string FileName)
{
HttpContext context = HttpContext.Current;
context.Response.AddHeader("Content-Disposition", "attachment; filename=" + FileName);
context.Response.ContentType = "application/xml";
string Path = context.Server.MapPath(FileName);
try
{
context.Response.WriteFile(Path);
}
catch (Exception ex) { }
context.Response.Flush();
context.Response.End();
}
Friday, October 3, 2008
Amount validation using Regex and Java Script
I come through a way to validate amount field.
This script validates amount field.
- If the value have a dot, It must be preceded and followed by one or two numerals.
var val = /^-?\d+(\.\d+)?$/.test(document.frm.txt_amount.value);
if(!val)
{
alert("Please enter correct amount.");
return false;
}
This script validates amount field.
- If the value have a dot, It must be preceded and followed by one or two numerals.
var val = /^-?\d+(\.\d+)?$/.test(document.frm.txt_amount.value);
if(!val)
{
alert("Please enter correct amount.");
return false;
}
Friday, September 12, 2008
Session lost problem after Response.Redirect
If you create a session like this and redirect the user to some other page, the session will lost.
Session["UserId"] = "User1";
Response.Redirect("YourPage.aspx");
This is because of the working of session and Response.Redirect, Lets go through.
" When you create a new session (that is, the first time you write to a Session variable), ASP.NET sets a volatile cookie on the client that contains the session token. On all subsequent requests, and as long as the server session and the client cookie have not expired, ASP.NET can look at this cookie and find the right session.
" When you create a new session (that is, the first time you write to a Session variable), ASP.NET sets a volatile cookie on the client that contains the session token. On all subsequent requests, and as long as the server session and the client cookie have not expired, ASP.NET can look at this cookie and find the right session.
Now, what Redirect does is to send a special header to the client so that it asks the server for a different page than the one it was waiting for. Server-side, after sending this header, Redirect ends the response. This is a very violent thing to do. Response.End actually stops the execution of the page wherever it is using a ThreadAbortException.
What happens really here is that the session token gets lost in the battle.
There are a few things you can do to solve this problem.
First, in the case of the forms authentication, we already provide a special redirect method: FormsAuthentication.RedirectFromLoginPage. This method is great because, well, it works, and also because it will return the user to the page he was asking for in the first place, and not always default. This means that the user can bookmark protected pages on the site, among other things. " - Bertrand Le Roy
Another thing you can do is use the overloaded version of Redirect:
Response.Redirect("YourPage.aspx", false);
This does not abort the thread and thus conserve the session token. Actually, this overload is used internally by RedirectFromLoginPage.
Friday, September 5, 2008
A very basic functional introduction to Css
Hi,
This is an extreme basic introduction to apply css.
============================
Display <li> horizontally -
<ul class="MyCss">
<li>Asp.net</li>
<li>JavaScript</li>
<li>Css</li>
</ul>
Definition of MyCss
ul.MyCss
{
margin: 0 0 0 0;
}
ul.MyCss li
{
display: inline;
}
===============================
Another way to apply same css -
div ul li
{
display:inline;
}
<div>
<ul>
<li>Asp.net</li>
<li>JavaScript</li>
<li>Css</li>
</ul>
</div>
===============================
Applying css using Tag id -
Lets we have
<span id="mySpan">Hi, css applied</span>
we can define its class using id like this -
#mySpan
{
background: #cfc;
}
===============================
This is an extreme basic introduction to apply css.
============================
Display <li> horizontally -
<ul class="MyCss">
<li>Asp.net</li>
<li>JavaScript</li>
<li>Css</li>
</ul>
Definition of MyCss
ul.MyCss
{
margin: 0 0 0 0;
}
ul.MyCss li
{
display: inline;
}
===============================
Another way to apply same css -
div ul li
{
display:inline;
}
<div>
<ul>
<li>Asp.net</li>
<li>JavaScript</li>
<li>Css</li>
</ul>
</div>
===============================
Applying css using Tag id -
Lets we have
<span id="mySpan">Hi, css applied</span>
we can define its class using id like this -
#mySpan
{
background: #cfc;
}
===============================
Labels:
Css,
css class,
css introduction,
Display li tag horizontally
Subscribe to:
Posts (Atom)