A bunch of tricky problems and solution

This weekend I faced a bunch of tricky problems that I solved after working hard on it. Here is a little description for that: Actually I am being a bit informal in case of description. I will be just copy and paste the report I used in my business.

1.a: Notorious problem for coping one whole page to other
Once upon a time I designed some pages according to some provided pages like
index.aspx buyabiz.aspx
I designed new pages like indexc.aspx or buyabizc.aspx. and so far I was working on it....
but the page name remain index.aspx....for it.which cause notorious problem to make ur head hung. It will give undefined errors. So we have to be careful.

2. I learned to use as in stored procedure that reduces the query size. Let me explain with an example:

select C.CityName, V.Voivodeship from City as C, VoivodeshipInfo as V where C.VoivodeshipID=V.VoivodeshipID order by C.CityName

3. Use of nvarchar(50) will save only 50 chars from the input taken
4. Negative balance showing:
This is a very typical problem. When u try to format in currency in this way:
string.Format("{0:C}",-25.50)..result is ($25.50)....:-)
This is a killing me problem. I used the picture format notation to solve this problem. The format I used is:

string.Format("{0:$#,#.00}",-25.50)..output is -$25.50 which I expected.

5.Look at this:
a.select DateTime, Name from Timetable as T where DateTime='2/9/2009': fails
b.select DateTime, Name from Timetable as T where T.DateTime='2/9/2009':works

here 5.a is incorrect but b will correct

6.To edit a column from SQL server Mgmt studio :
Table>Columns>Modify...

The column must allow null and have a default binding value
7. In CSS design:
display:none ---hides the control

lets look at it:

#menunav ul li:hover #submenu
{
display:block;
width:115px;
height:100px;
}
This is the hover syntax in css. when mouse is hovered on submneu-title then the
submenu is displayed and otherwise it is hidden.

8. when to redirect using the syntax in LinkButton or Response object:

Response.Redirect("www.cse.com"); won't work because it searches a page within ur website called www.cse.com.

Solution:
Response.Redirect("http://www.cse.com");