insertion of data into SQL

[Former Member]

hi,

can anyone tell me how to insert data in SQL fron a view which is developed in NWDS.by clicking on button in view data should be inserted to in SQL.I will be grateful for this help

[Former Member]

Hi Aravind,

As you can try as the above , if your trying for only one record updation you can use update querry

[ankur_garg5]

Hi Aravind,

As cool dude mentioned, you can create an EJB which is used to access your SQL server. This EJB can be used directly as an EJB model in your Web Dynpro, or can be used to create a web service, which can in turn be used to make a Web Service model in Web Dynpro.

To create such an EJB, go through this article:

[How to Create a Web Service using an Enterprise JavaBean Which Accesses the MS SQL Server|https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/uuid/b00917dc-ead4-2910-3ebb-b0a63e49ef10]

Now to use an EJB directly to create a model in Web Dynpro, go through this article:

[Using EJBs in Web Dynpro|https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/user-interface-technology/webdynpro/wd%20java/wdjava%20tutorials%207.0/using%20ejbs%20in%20web%20dynpro%20applications.pdf]

And to use a Web Service (made from EJB) to create a model in Web Dynpro, go through this article:

[Upload Files Using Web Service in Web Dynpro Java Application|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/c0d9336b-b4cf-2910-bdbf-b00d89bd2929]

[How to Employ Google Search Functionality in Web Dynpro|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/fd68e590-0201-0010-da89-ba631f41b3d7]

Bye

Ankur

[Former Member]

HI Aravind,

Check this

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/user-interface-tec...

Check these also

/people/valery.silaev/blog/2005/06/29/apojo--almostplain-old-java-objects-as-model

/people/david.beisert/blog/2004/10/26/webdynpro-importing-java-classes-as-model

regards

Sumit

[Former Member]

Try to create a EJB for the requirement.Try to wite the SQL statements in the EJB and expose your EJB as a webservice.Call this webservice making use of the 'webservice model' in to your component and create a fornt end for this to enter the data in the webdynpro.

Any queries then reply.

Regards,

YUSUF.