Random thoughts

To get the certification on specific technology is as important as to work on that technology and it's quite important to having information of certification road. so that you can plan your certification level and priority according to your requirement and get the maximum benefit of certification. Here, You can find the detail information about the SQL Server Certification More

Export to excel is quite useful functionality that we need to implement in our web application. We are discussing Here about generate the Excel File based on your Database records in another word we want to export the result set of data grid into excel. You can easily do the same by using Response object but what if you need to implement complex feature of Excel application in your exported excel sheet such as Creation of Validation List, Using formula to range of excel cells, Implementing AutoFilter. Or Using predefined templates; in nutshell we want to Automate the Excel Application. you have the following solution • Using Visual Studio Tools for Office (VSTO) • Using COM Interop for Excel Application • Using XML Schema to Create Excel Application Every method we will discuss in detail in next post