I'm not sure if anyone else has had this question, but here goes.
I'm looking for a module that has the ability to add, edit, change parent tables and children tables. It should extract this data from a SQL Server across the network and if any changes are made to the data via the DNN GUI, it should be updated with the SQL Server database. This should be done in a nice GUI interface for the user. The data is already in place, you just need to add, edit and delete.
Example: Parent 1 with children A and B. You should be able to drill down from 1 and make changes to A or B. You can also make changes to the parent as well. The PK of Parent 1 is a string which can be numbers
For now, I've been using onyaktech dataview Evaluation version 3.0.1 module which sort of works. I can drill down a level but am not able to make any changes to the drilled down data. Whenever I try to edit, change or add a record in the parent, it can't recognize the pk to fill in. I get this error in the log.
Error: (TRUNCATED TO 500 CHARS): System.Data.OleDb.OleDbException: The statement has been terminated. Cannot insert the value NULL into column 'Project', table 'Reporting.dbo.Projects'; column does not allow nulls. INSERT fails. at
I am putting in values when inserting a new record. It says Unable to insert into. Reason: Input string was not in a correct format.
And I get this when trying to delete (from the log)
Error: (TRUNCATED TO 500 CHARS): System.Data.OleDb.OleDbException: Conversion failed when converting the varchar value '10419-M ' to data type int. at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at OnyakTech.DataView.DataController.ExecuteOLE(String SQL, String connectionString) at OnyakTech.DataView.DataController.DeleteRecord(String TableName, String PrimaryKey, Int32 PrimaryKeyValue, String ConnectionStrin
Can this module only deal with int PKs?
Thanks.