Supposing you have 50 tables without identity column, adding identity manually in the table designer would take you so much time. Here's a script to automatically add identity to a column. List all tables without identity column. SELECT (SCHEMA_NAME(schema_id) + '.' + name) as SchemaTable FROM...
Adding primary key using designer in SQL would take you so much time. Here's a script that would automatically list all the tables without a primary key and create one. You can also filter by schema. List all tables without Primary Key select a.table_name, a.column_name, ...
During testing of the published file in IIS, I've encountered this issue regarding the target framework. To resolve this, you need to change the target framework of the Application Pool. Select the name of your application from the list. Double click to Edit. From the dropdownlist of the .Net...
When you are modifying table columns in SQL example changing data type or adding a new column, after you click save you are prompted with this error: "The changes you have made require the following tables to be dropped and re-created" from SQL Server." To solve this issue you must do the following: Go...
This code snippet will write to registry on a client side. (Only works in IE!) function writeInRegistry(path, sRegEntry, sRegValue) { var regpath = path + sRegEntry; var oShell = new ActiveXObject("WScript.Shell"); ...
In your MVC View @model IEnumerable<ProjName.Models.ModelClass> @{ if(Model!=null) { int count= Model.Count(); <table > <tr> ...
Here's how I generate CSV File from Stored Procedure Public Sub GetDataFromStored() Try Dim cmd As SqlCommand = New SqlCommand Dim strpath As String = Application.StartupPath + "\Result.txt" ...
Here's how I generate text file from a stored procedure. Public Sub GetDataFromStored() Try Dim cmd As SqlCommand = New SqlCommand Dim strpath As String = Application.StartupPath + "\Result.txt" ...
Here's my way of exporting a report generated using Crystal Reports viewed in PDF format to Excel File that is already ready for download by the user using MVC. Controller Method public ActionResult ExportPDFToEXCEL(string searchOption, string searchKeyWord) { ...
Follow the following steps on how to install IIS(Internet Information Services) 7.0 in Windows 7 since it is not installed by default when you install Windows. 1. Click Start button, and select Control Panel. 2. Choose Programs and Features. 3. On the left side, select Turn Windows features...
One of the issues encountered during publishing of MVC Applications in IIS is the registration of ASP.Net 4.0. Here's how it is done using Visual Studio Command Prompt. 1. In Start Menu, select All Programs. 2. Select Microsoft Visual Studio 2010, then Visual Studio Tools. 3. Right click on Visual...
This would be my first blog that is related to my career as a Web Developer. This serves also as a documentation, since I'm not good enough in organizing my files and too young enough to easily forget things. As the title suggests, this article is all about customization of the defined template for...
