Follow this blog
Administration Create my blog

Interview Questions of SQLServer

Do you know what are User Defined functions. Scalar, Inline Table-Valued and Multi-statement Table-valued. A Scalar user-defined function returns one of the scalar data types. Text, ntext, image and timestamp data types are not supported. These are the...

Read more

iTextSharp

iTextSharp

Getting Started with iTextSharp For the ASP.NET developers out there, if you need to generate PDF reports from your code, there is an open source library called iText# (iTextSharp) that is worth checking out. iTextSharp is a port of the Java iText library...

Read more

ASP.NET

ASP.NET ASP.NET, the next version of ASP, is a programming framework used to create enterprise-class Web Applications. These applications are accessble on a global basis leading to effecient information management. The advantages ASP.NET offers is more...

Read more

ASP.NET Important Topics

1) Asp.net Page Life Cycle & Page Architecture. 2) Assemblies. 3) User Controls & Custom Controls. 4) Gridview Control. 5) Themes, Skins and Style Sheets. 6) Master Pages. 7) Site Maps. 8) State Management. 9) Security(Web.config) (Authentication & Authorization)...

Read more

FOR XML - SQL Server

Introduction In Microsoft SQL Server 2000, we introduced the FOR XML clause to the SELECT statement. This clause provides the ability to aggregate the relational rowset returned by the SELECT statement into XML. FOR XML on the server supports three modes—RAW,...

Read more

Time Delay to Execute a T-SQL Query

A New feature in SQL Server is Time delay to execute a T-SQL Query SQL Server will wait for perticular time to excute the query. Ex : i) SELECT GETDATE() CurrentTime WAITFOR DELAY '00:00:20' ---- 5 Second Delay SELECT GETDATE() CurrentTime Ex: ii) DECLARE...

Read more

.text { mso-number-format:\@;...">

Export Gridview data to Excel

i) Get the Data from the Database and Bind it to the Gridview ii) Set Gridview Allowpaging property to "False" Write the below code to export the entire Gridview data to Excel sheet private void ExportGridView() { string style = @"