crud

Editing tables with ASP.Net - Quick 'n Dirty

I have need to provide a way for users to edit tables in ASP.Net. The tables are simple (no master/detail relationships), but there are likely to be a lot of them. What's the quickest/simplest way to provide a view/edit interface to a table, even considering commercial options (but not Iron Speed Designer. That thing is ridiculously e...

What is the best framework for developing a Java CRUD for an existent database?

We have a Java application with lots of config tables on the database (Oracle). We'd like to have Web-based GUIs for setting up these tables, that we currently update via SQL queries. What is the simplest way to develop CRUDs for a subset of our database? Is there any Java-based framework for doing this? ...

Does Google app engine supports JDBC?

I have heard the Google App Engine[java] do not support JDBC and Hibernate. Is it true? If yes then how do we access the database in Google App Engine. Also, is there any [basic] sample application which can help me understand how to perform CRUD operations in GAE. ...

Best practices book for CRUD apps

We will soon be designing a new tool to calculate commissions across multiple business units. This new compensation scheme is pretty clever and well thought-out, but the complexity that the implementation will involve will make the Hubble look like a toaster. A significant portion of the programming industry involves CRUD apps; updatin...

Kohana newbie - sample CRUD application

I'm completely new to this framework and I'm trying to find some sample CRUD application to get started with Kohana 3. There is a tutorial and information in the unofficial Kohana 3 Wiki (http://kerkness.ca/wiki/doku.php), but event there, there are some aspects that are not covered (the model, validation, etc). ...

WPF A good way to make a view/edit control?

Hi, this is just a question to discuss - what is the best way to make a view/edit control in WPF? E.g. we have an entity object Person, that has some props (name, surname, address, phone etc.). One presentation of the control would be a read-only view. And the other would have the edit view for this same person. Example: <UserControl x:...

ASP.NET MVC (MVC2) Best practices when Inserting/Updating Data using Linq to SQL and Repository layers

I'm in a bit of a conundrum here and I'm hoping for some of you Guru's to help fill in the blanks. The situation I'm currently facing is with regards to my "Users" table and my "OpenID" table. My app allows for a user to have multiple OpenID's, so I keep track of them in a separate table. Users ID Username OpenID ID Us...

Jquery Plugins - date selector and crud(php mysql)

hi, I am trying to find a date picker that can show dates to select starting current date so that the users don't select the past date and I need not worry about validating. I am not sure if this will show the correct date for any one from any place. I found some plugins but none of it has this option. I found this http://jqueryui.com...

Quick & dirt CRUD interface to SQLAlchemy?

I'm researching software components to use in a future development of a business logic web application. It's gonna be written in Python and we are targeting SQLAlchemy as ORM. The app will be used by other software apps via a REST-like interface over http, possibly using web.py for that part. For debugging, maintenance, etc we need to d...

Recommended JSF 2.0 CRUD frameworks

Hi all, Can somebody recommend any framework to facilitate CRUD development in JSF 2.0? Aspects I value most: As lightweight as possible; limited dependencies on third party libraries Support for an evolving domain model Limited need for repetitive coding; support for scaffolding and/or metaannotations Any hints highly appreciated...

References to same table

Hi, Im writing a simple editor for a game, to manage the relationships between creatures. The creatures table is setup with a id, name etc. and a boolean is_prey column; what I need is to figure out how a) an ORM relation can be defined between id's from the same table b) how to limit the 'available' other-nodes to only include the ones...

Entity Framework CRUD operations on a datagrid

I have a List<T> bound to a datagrid and am trying to figure out how to save all the changes to the database (using Entity Framework), not just one row at a time; OR, at least a better way to commit changes from the datagrid to the database. I am using the MVVM pattern. Here is what I have as far as saving one row: private static P...

Streamline and make form/crud operations more efficient in web applications?

Hi everybody, When looking back at last weeks work (identical to many others), I've found myself spending the major part of my time putting together forms of which POST-data are used to perform database CRUD operations through my MVC-models. When reflecting over this, it becomes a bit worrying. It's not really appropriate to spend the ...

CRUD Class for PHP (Simple but will Allow Relational Data)

I am building a database of products and manufacturers. I already have the database layout done. I am looking for a simple CRUD class that will let me setup Manufacturers and Products and create the records quickly and easily. I have looked at ORM's but they all seem to be over kill for what I am looking for. Thanks ...

is there a good PHP CRUD code generator?

Is there any better PHP CRUD code generator? I want to get Data Access Object, Business Object and Value Object. It would be difficult to match my needs, but I am happy at least I can get any relevant one. Thanks in advance. [EDIT] I am working on an MVC based application. I am using my own MVC framework. I need this code generator to ...

Best practices for snapshotting SQL database rows.

I have two tables X and Y. This is back end of a web based CRUD application. Let's say that rows in Y have fields a, b and c. When a row in X is created, it has to link to a snapshot of the values in a specific row of Y. The row in Y may change later but the row in X should still have the values of a, b and c at the time of creation. ...

Why SOME users cannot update record through the browser?

We have a simple SQL Server database with an ASP.NET front end. I can easily update a record from my browser. Another person cannot: he edits the field and hits the "update" button, but the change is not propagated to the database. The old value remains. He is using Internet Explorer. I checked the database, and his change is not propa...

"Inline" CRUD in ASP.NET MVC

Say I have a Companies table which has a many-many relationship with an Employees table. I have an add/edit Companies page, but I also want to be able to find/add new/existing Employees as well, without having to open up another CRUD page for each Employee first. I'll be inputting an English name and a Japanese name for each Employee, ...

How do I bind multiple tables (or entities) to a datagrid and enable CRUD operations?

Hi all, Consider two tables, Product and Supplier. To get the required data for a grid view I need to do something like the following code snippet. SupplierID is a foreign key in the products table, but needs to be displayed in the user friendly SupplierName from the Supplier table. SELECT Product.ProductID, Product.ProductName, Produc...

Yii framework generated forms field types dont corespond to database

I am using gii to generate CRUD operations for a large number of tables, but the generated form uses a text box for the boolean data types instead of the checkbox In my table model I modified the rules function to use a boolean validator for my fields public function rules() { return array( ... array('single, random, public', 'boo...