I have a SQL Server 2005 database which holds a fairly basic schema. I'm fine with accessing it through Management Studio, but I need to be able to provide read-write access to other internal staff so they can modify the contents of certain tables. Can anyone recommend a tool (preferably free) that can look at a SQL Server database and...
I've started to learn how to use the CakePHP framework for a part time job. And I decided to build one of my personal projects in this framework to get some practice on it. I have some models I created using Cake bake command and I added the automated CRUD support (It adds to the controller var $scaffold for the all relevant actions. I...
Say I have a WinForm CRUD(like) application. I want to follow best practices on this so I try and make it follow OOP and a n-Tiered design. Unfortunately I am familar with the words but not the practice of them. So lets go with the following example: My CaseNote program. I have a tabbed application where you go to the search tab t...
I am new to SubSonic and Linq Stuff and I am trying a figure out the shortest and optimal way of retrieving a single record. What other way is quicker and requires less code to write than this to get a single record? User user2 = DB.Select().From(User.Schema) .Where(User.PasswordColumn).IsEqualTo(password) .And(User.SINumberColumn).IsE...
I am designing a WinForms CRUD "like" app for a large group of Nurses and Social Workers to interact with Client information. There are many different forms(about 30ish) that they need to "possiblly" interact with for any given client and they "can be" required to jump from one to another for a specific person. I am strugghling wit...
Suppose I have these tables: Fruits - FruitID INT PK - FruitName NVARCHAR(30) - FruitStatusID INT FK: Statuses Statuses - StatusID INT PK - StatusName NVARCHAR(30) How do I update both the Fruit's name and its status in the database in these situations?: Update a piece of Fruit that came from a previous L2E c...
Given this schema: Fruits - FruitID INT PK - FruitName NVARCHAR(30) - FruitStatusID INT NULL FK: Statuses Statuses - StatusID INT PK - StatusName NVARCHAR(30) If I have a FruitID in hand (just an int, not a Fruit object), how do I update the FruitName and null out FruitStatusID without loading the Fruit object ...
Where can I find examples of very well produced enterprise-y software that have: Good, consistent use of keyboard shortcuts. Good keyboard form navigation Standarized form validation Standarized use of lookup/search screens. (User gets asked for Client ID, doesn't know it but can look it up from a popup window that returns it) Standari...
Trying to avoid the SomethingManager trap here... Let's say I'm going to write a User editor which will allow administrators to create users in the system. Pretty basic functionality - view a list of existing users, create a new user, update an existing user, delete a user. Let us also say that I decide to write a "business" class to ...
So my background is in Java web services, but I'm trying to make the move to ROR. I'm using FlexImage to handle image uploading and thumbnail generation. I followed the guide and CRUD behavior was working fine at one point. However, at some point, CRUD behavior for one of my models (Images) was broken. The error code I'm getting back...
If I understand correctly, in rest style, every query (that is, every action on every resource that does not modifies the resource's state) should be enconded in the querystring, using a get method, with no body at all... am I right? well, I have several applications that comunicate with the db thru an xml message that is handled by a ...
In PHP, Are there any patterns people use to submit forms? A form submission best practices.. etc. Example, I am trying to achieve a CRUD operation. Initially I have been using a same function for handling form-display and form-submission class Somecontroller extends Controller { function form1_add() { // if submit exist save it...
I'm making a simple CRUD app with ASP MVC and I want to have a confirm page when creating a new object and inserting it into the database. The problem is that I'm having trouble passing the object between actions. I tried to save it in the session after it's created and then retrieving it when the user confirms, but I'm getting an Inva...
MSCRM 4.0 When writing plugins, I have assumed that the required fields will always exist either in the Target image or the PreImage image. But recently when coding an external application that consumes the CrmService, I realised that the service will allow a business entity (or dynamic entity) to be created using the 'Create' method, e...
Hi all :) I'm currently developing a Blog project using Post model, which will be used by multiple authors. I want to make an admin/control-panel interface where each author of the Post can view the Post list the author created (so he won't see the Post created by the other authors), edit, and multiple-delete them. http://stackoverflo...
I'm trying to build a website that has a Member section, and I'm struggling to find a fast and efficient way to build the enduser pages, which will pull a user's data. For example, the user's "my account" page. They simply need to be able to view and edit the data. Would you use the Entity Frameworks EntityDataSource control? And bin...
Hy guys. I've created a simple blog app with the usual CRUD actions. I've also added a new action in the PostController called "archive" and an associated view. In this view I want to bring back all blog posts and group them by month, displaying them in this kind of format: March <ul> <li>Hello World</li> <li>Blah blah</li> ...
When I try to generate a CRUD test for a new project I am getting a PHP Warning and a Fatal Error. The errors relate to files that it cannot find, however, I have checked and the files are definitely there. The error text is 'require_once(lib/model/map/QuestionMapBuilder.php): failed to open stream: No such file or directory in c:\webr...
We're developing quite a big application using ASP.NET MVC and at the beginning we saw that could be useful to have an abstract base controller with common CRUD actions (new, save, delete...) plus a default list action. In our case we have 20+ entities that are managed through this kind of controllers. That works and avoids duplicating ...
I have to make some database request with php on a mySQL database Question : What is the best (simpliest) framewok to get thing done right CRUD (create read update delete) I also have to populdate the database, what is a good tool to do that. The only one i know is sqlmyadmin, wich does not look good. An online tool will be great Your...