Can anybody take me through a step by step process on how I can integrate FCKEditor into an aspx page that will allow me to edit and update data in an Access database with out cause frigin errors every stinking step of the way!
Here's what I've done so far...and please feel free to tell me to choose a different method because I am about to scrap the whole project and go with another editor if I can't get this to work.
I've created a master page and content page. The content page has a connection to the access database with the Fields PageID(primary key) and a memo field with the page information, we'll call this field "Pageinfo" The filter on the data displays the data from the record where the PageID = 1. Pretty straight forward.
I've placed a Form view on the content area and bound the form view to the data. I've then gone into editing the templates, remove the textbox from the editItem template and placed the FCKEditor in the field and bound the field PageInfo to the value of the object. Great, working so far.
Now I try and make soem changes to the data and click on the update button and I get this error!
Now to my knowledge thgye only two "parameters" are the two fields that I have placed into the page and one of them is an autonumber!
What gives!
Here's what I've done so far...and please feel free to tell me to choose a different method because I am about to scrap the whole project and go with another editor if I can't get this to work.
I've created a master page and content page. The content page has a connection to the access database with the Fields PageID(primary key) and a memo field with the page information, we'll call this field "Pageinfo" The filter on the data displays the data from the record where the PageID = 1. Pretty straight forward.
I've placed a Form view on the content area and bound the form view to the data. I've then gone into editing the templates, remove the textbox from the editItem template and placed the FCKEditor in the field and bound the field PageInfo to the value of the object. Great, working so far.
Now I try and make soem changes to the data and click on the update button and I get this error!
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: No value given for one or more required parameters. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [OleDbException (0x80040e10): No value given for one or more required parameters.] System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +1002416 System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +255 System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +188 System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +58 System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +161 System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +113 System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand command, DataSourceOperation operation) +386 System.Web.UI.WebControls.SqlDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues) +325 System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) +92 System.Web.UI.WebControls.FormView.HandleUpdate(String commandArg, Boolean causesValidation) +835 System.Web.UI.WebControls.FormView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +509 System.Web.UI.WebControls.FormView.OnBubbleEvent(Object source, EventArgs e) +95 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37 System.Web.UI.WebControls.FormViewRow.OnBubbleEvent(Object source, EventArgs e) +113 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37 System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +118 System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +135 System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +175 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
Now to my knowledge thgye only two "parameters" are the two fields that I have placed into the page and one of them is an autonumber!
What gives!