I have create table in SQL 2005 and retrive its data in to sharepoint with the help of Database connection option through Sharepoint Designer. When configuring the connection i have selected a custom quer with stored procedure option and from the dropdown
option selected the insert stored procedure everything is ok.
CREATE PROCEDURE ChangeTable_insert
@ROLE VARCHAR(50) ,
@PROJECT varchar(50) ,
INSERT INTO [dbo].[ChangeTable]
i have created new aspx page in Sharepoint Designer from the datasource details-->Insert selected fields as-->selected new item form and saved this page.
When i opened this page in to browser and try to save data it gives an below error
Go back to site
Error: "The data source control failed to execute the insert command.
Troubleshoot issues with Windows SharePoint Services."
please help me. i have to save data to sql database through sharepoint
thanks in advance
View Complete Post