Intersoft Community - WebGrid Enterprise - Webgrid Update Command using Oracle 10g/11g

Webgrid Update Command using Oracle 10g/11g

yudi — Tue, 04 Oct 2011 06:49:45 GMT

Glad to hear the good news and thank you for willing to share the solution with us. I’m sure that this solution will be useful for other member who has similar scenario with yours.

Should you need further assistance or run into any problems regarding our controls, feel free to post it into our community. We would be happy to assist you again.

Webgrid Update Command using Oracle 10g/11g

socialnetworkdude@gmail.com — Tue, 04 Oct 2011 04:29:06 GMT

OK I solved it I replaced the oledb data objects with Oracle data objects (i think u need devart dll) and modified the query using :p1 instead of ? this works for insert so it will also work for update.

This is solved i only need dropdowns now for the input fields.

Webgrid Update Command using Oracle 10g/11g

socialnetworkdude@gmail.com — Mon, 03 Oct 2011 06:51:43 GMT

Sry for the double post my bad (u can remove the other thread),

I looked into the samples and came accross something i was looking for:

Solution: WebgridSamples > BatchUpdate_CustomObjectUpdate.aspx

I can use codebehind to bind the webgrid to and datasource, however again select query's work fine but when i want to insert/update/delete it gives errors.

I am now trying to insert a record from an intersoftgrid into an oracle table. This method looks more likely to work but im getting errors so maybe im doing something wrong ?

I have added some screenshots. the most important SS is Insert Method for(Webgrid) there I show the error message with some text. The other screenshots are for additional information to understand my situation.

Webgrid Update Command using Oracle 10g/11g

yudi — Sun, 02 Oct 2011 23:26:36 GMT

*Edited
reason: double post

Webgrid Update Command using Oracle 10g/11g

yudi — Sun, 02 Oct 2011 23:26:18 GMT

Most of the sample files provided by Intersoft are using Northwind as the database. The screenshot indicates that the ISDataSource control is unable to find the “UpdateQuery” method.

Please ensure that the “UpdateQuery” method is available and can be accessed by the ISDataSource control.

Please allow me to share a trick that I often use when having problem with ISDataSource and the method of dataset. When having problem with the select, insert, update, or delete method I usually use the ObjectDataSource control to test the method.

Hope this helps.

Webgrid Update Command using Oracle 10g/11g

socialnetworkdude@gmail.com — Sun, 02 Oct 2011 10:20:45 GMT

Hi,

I'm not totaly new to intersoft but i have little experience.

Ok my problem.

I want to use the webgrid functionality on a oracle Database Table. To keep it simple i copied the table columns from the Customer table Northwind and created one in a ORACLE Database so i could use the samples provided by Intersoft.

Doesnt mather what i try it always says could not find Non-generic method.

I removed the Create Insert,Delete combobox and made a custom update statement in the dataset.

The select query works perfect but whenever i want update it starts giving errors.

Is this possible?

Thx.