MVC Application deployed in IIS 7 using MSSQL Server 2005 and MSSQL Server 2008 R2 didn't encountered issue on date format. But after the compatibility test conducted for deployment in Window 8 operating system using IIS 8 and MSSQL Server 2014 dates encoded were displayed in (dd/mm/yyyy) format which...
Error: Could not load file or assembly 'System.Web.Mvc, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) This occurred during browsing...
Private Sub btnOpenFile_Click(sender As System.Object, e As System.EventArgs) Handles btnOpenFile.Click If OpenFileDialog1.ShowDialog <> Windows.Forms.DialogResult.Cancel Then Dim appSetDT As DataTable ...
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...
