Dear friends

A web portal developed in DNN 4.0.2.

I made some changes in my SQL Server 2005 database, like adding new tables, adding new columns to existing tables, changing the properties of table fields, etc. Now I need to update these changes in the DataProvider.vb, SQLDataProvider.vb and the respective "XXXXXXcontroller.vb" and "XXXXXXinfo" files.

I did these changes manually, and I am into error state now (given below). Is there any way that we can do this updations by building or something.???

Please reply with your valuable suggestions. Thanking you in advance.

Praveen

AssemblyVersion: 04.00.02
Method: Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues
FileName:
FileLineNumber: 0
FileColumnNumber: 0
PortalID: 0
PortalName: Our website
UserID: 3
UserName: counter1
ActiveTabID: 36
ActiveTabName: Our website
AbsoluteURL: /OurWebsite/Default.aspx
AbsoluteURLReferrer: http://localhost/OurWebsite/OurWebsite/tabid/36/Default.aspx
ExceptionGUID: e8afd8e5-1975-4398-8cd4-c3b9b7f8f5f2
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
InnerException: Parameter count does not match Parameter Value count.
Message: DotNetNuke.Services.Exceptions.PageLoadException: Parameter count does not match Parameter Value count. ---> System.ArgumentException: Parameter count does not match Parameter Value count. at Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues(SqlParameter[] commandParameters, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at OurWebsite.Modules.LTShare.SqlDataProvider.AddLTBookingTemp(Int32 tripID, String name, String contactNo, String address, Byte seatsPurchased, Double amountTransacted, String receiptNo, DateTime bookingDate, String destination, String paymentMode, String counterID) in c:\inetpub\wwwroot\OurWebsite\App_Code\LTShare\SqlDataProvider.vb:line 139 at OurWebsite.Modules.LTShare.LTBookingTempController.Add(LTBookingTempInfo objLTBookingTemp) in c:\inetpub\wwwroot\OurWebsite\App_Code\LTShare\LTBookingTempController.vb:line 98 at OurWebsite.Modules.LTBookingGUI.ViewLTBookingGUI.cmdFinish_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\OurWebsite\DesktopModules\LTBookingGUI\ViewLTBookingGUI.ascx.vb:line 552 at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
StackTrace:
Source:
Server Name: MyComputer