I have a table in database
I want to use a webpart to add, delete and udate data from database table
I can create a custom webpart with a gridview
but is there out of box webpart in 2007 sharepoint I can use ???
I suggest you to use BDC (Business Data Catalog) in Sharepoint 2007. BCS is an upgraded version of BDC in Sharepoint 2010. So since you are using 2007, you should look for BDC.
You can use the BDC Web Parts to View, Update, Create, Delete items to the database.
Here is a tutorial to get you started:
what you are looking for is business connectivity services. now I am not sure if this existed with the same functionality in 2007.
No not that i know of! any way that you chose you would need to create some code! there are alot of examples out there on the net!
For your issue it shouldnt be hard atall! just create three stored procedures for each task in SQL server, make sure you give each stored procedure the correct permission.
create your custome webpart and call the stored procedures from there!
somthing similar to this ;)
you can follow luis route:
Creating a Database Connection by Using the Business Data Catalog Definition Editor
for sql commands
to add buttons to webpart:
in create child controls even add:
|show 1 more comment|