We are working on an application and which had got login screen as an entry page. One day all the developers were getting time out error from the development database when they launch the application.

Ok fine. But we were able to connect to the Sql server without any issues. So Server availability was not an issue. We were able to query all the tables without any issue except the UserInfo table. UserInfo was the table which had got user credentials.

One of the features added as part of language enhancements in dotnet 2.0 is anonymous method.

What is anonymous method?

A delegate with no named method associated with it is an anonymous method.

When do we use it?

When we do not want to have a separate method for a delegate

When we need to access the local variables

 Creating a cutom control on silverlight 2 and applying default style to that

Most of us blog these days regularly. But it’s not very comfortable writing blog post directly inside the browser.  Not all blog service providers support interim save to avoid accident lose of content, spell check and other commonly used features that any word processors provide.

But we are smart enough to overcome this problem. So we frame the content in note pad or word processor. Later we copy from word processor and paste in blog. But it’s again a pain of pasting in the blog composer like security issues from accessing clipboard, losing the format and many more hurdles. Sometime it also discourages us from blogging.

 Let’s discuss how to capture remote webpage’s result into our web page. Sometime we might need the remote webpage’s result to be stored in database as well.

[WebMethod]

public int GetPortNumber()

{

return this.Context.Request.Url.Port;

}

SELECT Count(*) FROM Syscolumns WHERE ID=(SELECT object_id('tablename'))

1.       DELETE and TRUNCATE removes rows or records from the table.

2.       DELETE can be used with WHERE clause. But not the TRUNCATE.

3.       DELETE can be rolled back, but not TRUNCATE

4.       DELETE raises TRIGGERS, but not the TRUNCATE

5.       DELETE does not reset the IDENTITY column