Hi,

I'm still new in Dotnetnuke. I got a problem and i hope anybody can help me to solve it. I want to get the system date and stored it in MS SQL 2000 database. I want to passing the value to the parameter but I got an error as stated below.

 DotNetNuke.Services.Exceptions.ModuleLoadException: Failed to convert parameter value from a String to a DateTime. ---> System.formatException: Failed to convert parameter value from a String to a DateTime. ---> System.formatException: String was not recognized as a valid DateTime. at System.DateTimeParse.Parse(String s, DateTimeformatInfo dtfi, DateTimeStyles styles) at System.DateTime.Parse(String s, IformatProvider provider) at System.Convert.ToDateTime(String value, IformatProvider provider) at System.String.System.IConvertible.ToDateTime(IformatProvider provider) at System.Convert.ChangeType(Object value, Type conversionType, IformatProvider provider) at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType) --- End of inner exception stack trace --- at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType) at System.Data.SqlClient.SqlParameter.GetCoercedValue() at System.Data.SqlClient.SqlParameter.Validate(Int32 index) at System.Data.SqlClient.SqlCommand.SetUpRPCParameters(_SqlRPC rpc, Int32 startCount, Boolean inSchema, SqlParameterCollection parameters) at System.Data.SqlClient.SqlCommand.BuildRPC(Boolean inSchema, SqlParameterCollection parameters, _SqlRPC& rpc) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, String spName, Object[] parameterValues) at PRISM.Customer.AddCustomer.lb_Create_Click(Object sender, EventArgs e) in d:\Projects\BIX\DesktopModules\Customer\AddCustomer.ascx.cs:line 138 --- End of inner exception stack trace ---

I use the Microsoft.ApplicationBlock.Data to pass the value to parameter. Below is the code:-

SqlCommand cmd = new SqlCommand("Add_CustomerInformation", sqlconn);CommandType.StoredProcedure;SqlHelper.ExecuteNonQuery(sqlconn, "Add_CustomerInformation", rbl_Category.SelectedValue,

cmd.CommandType =

txt_Name.Text, txt_IC.Text, txt_DOB.Text, rbl_Race.SelectedValue, rbl_Gender.SelectedValue,

ddl_Nationality.SelectedIndex, txt_HomeTel.Text, txt_HP.Text, txt_CurrAddress.Text,

txt_PermanentAddress.Text, txt_Fax.Text, txt_EmailID1.Text, txt_EmailID2.Text,

myDateTime, TextBox2.Text, myDateTime1, TextBox3.Text);

DateTime

myDateTime = DateTime.Now;