Microsoft SQL Server database CRUD operations panel. It adjusts the existing database and automatically generates Create, Read, Update and Delete forms for each table.
- ASP.NET MVC 5
- Angularjs 1.4.7
- Bootstrap 3.3.6
- Angular-UI-Bootstrap 2.1.3
It's simple:
- Download the repository.
- Open
CRUDpanel.csproj
in Visual Studio. - Open
Web.config
file and changeconnectionString
section to connect your server and database. - Save the Solution as
../CRUDpanel-master/CRUDpanel.sln
- Run the project from saved solution file and enjoy :)
CRUDpanel supports the following MS SQL Data Types
int
float
bit
decimal
bigint
smallint
tinyint
numeric
nvarchar
varchar
nchar
char
ntext
text
ntext
and text
types only works when table has identity column.
datetime
date
CRUDpanel can work with databases which hasn't relationships between tables and in this situation it works fine but with limited functionality. With relationships it gives some features.
One to Many
relationship: When you edit record's view with update button, CRUDpanel retrives information and shows you table with records which are dependant on this record.Many to One
relationship: When you create or update record, CRUDpanel generates the list of FK tables, so you can choose record from these FK tables.