Non Clustered indexes per tabel

In Sql Server 2008 32 Bit addition ,following are the limit for Non Cluster Index and Cluster Index

Clustered indexes per table: 1

None clustered per table: 999

Nested sub queries: 32

Nested trigger levels: 32

Parameters per stored procedure: 2100

Parameters per user-defined function: 210

Best way to display default image if specified image file is not found ?

Many times in grid/repeater or even in image display we have a problem if we don’t find any image related to that ID/Record and to replace “X” sign or image not found message we need to do programming but here is the
Quick solution which saves lot’s of your time and also your server processing time.
Just put following code in your in your image control.


onerror="this.onerror=null;this.src='Noview.jpg'">

How to call javascript code from server side

One can call JavaScript client side function directly from code behind using RegisterStartupScript. If one wants JavaScript to be embedded into codebehind, then make use of RegisterClientScriptBlock:

<script>
function fnShowMessage()
{
       alert(" Invoke Javascript function from Server Side Code Behind ");
 }
 </script>

protected void Button1_Click(object sender, EventArgs e)
{
        ClientScript.RegisterStartupScript (GetType(),"Javascript", "javascript: fnShowMessage(); ",true);
}
protected void Button2_Click(object sender, EventArgs e)
{
       ClientScript.RegisterClientScriptBlock(GetType(), "Javascript",  "<script>alert('Record Added Successfully')</script>");
}