[RESOLVED] GridView DataSource Edit

[weirddemon]

I have a DataView that is bound to a DataSource, which gets its data from a SQL database.

I'm converting a desktop app to a web app and I've been able to duplicate the data query side, but I'm having a hard time inserting a new record via the data source. In the desktop app, I don't use a data source. I have a class I created that inserts a new record, but the upkeep is extremely time consuming, so I'm switching to the datasource.

When I assign the datasource, I selected the SQL statement/stored procedure option and created my INSERT command via the Query Builder.

The problem I'm running into is that I don't want a SELECT statement. I just want a plain GridView so I can select Edit, fill in the data and then call InsertParameters.

If I don't add a SELECT statement, it won't let me finish the wizard and an invalid one throws an exception. The only other thing I could think of, was to call SELECT and set a WHERE based on a column whose value is null. The app runs, but the GridView doesn't appear.

Does anyone know how I can only do an INSERT?