I've attached an image.
This application should be connecting to a SQL-Server:
Server: [login to view URL]
Username: sa
Password: sapwd
Database: dbTest
- When I write something in the textbox next to "Search", and click "Ok" - it should search within all of the colums in the table.
I Should also be able to choose between the four other columns, the columns names are the same as I've named them in the image. The "Active" column should be a checkbox specifying the value "0"/"1". When I e.g. choose "Customer" from the dropdown menu, it should only search within that specific column.
- I Should be able to select a row, and edit or delete that specific row. When I click "Delete selected" I should get a pop-up box asking me to confirm. When I click "Edit selected", it should open a new window where I can edit the different columns.
- When I click "Add new" it should open a new window similar to the edit-window, where I can add a new item. When I add a new item it should increment the "ID" column.
This should be done in C# (csharp), and I hope for a clean commented code.