Client side exception after inserting event

jamesik@centrum.cz — Mon, 17 Jun 2013 11:41:58 GMT

Ok, this is solved. The problem was related to the return value of the custom Insert metod in the EventsTableAdapter.

return (int)command.ExecuteScalar()

needs to be changed to

return Convert.ToInt32(command.ExecuteScalar())

Client side exception after inserting event

jamesik@centrum.cz — Mon, 17 Jun 2013 10:50:30 GMT

Hi,

after inserting event to DB (MS-SQL) I'm getting the following exception on client side:
"Exception has been thrown by the target of an invocation.","Type":"Event","Id":,"Refresh":false})

ISRes.axd, line 13 character 618"

Looks like there is passed null value to the Id key and therefore syntax integrity is broken.

Data are properly passed to DB (no problem found in server side insert method).

After inserting new event to the DB table the progress indicator isn't removed and the mentioned client side exception occurs. Webscheduler is not updated (the new event isn't displayed until manual page refresh).

I don't have any problem when updating or deleting existing records.

Attaching the server side Insert method:

[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
[global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)]
public virtual int Insert(int EventID, string CategoryID, global::System.Nullable<int> ResourceID, global::System.Nullable<int> Mode, string Subject, string Description, string Location, bool AllDayEvent, global::System.Nullable<global::System.DateTime> StartTime, global::System.Nullable<global::System.DateTime> EndTime, global::System.Nullable<int> Reminder)
{
this.Connection.Open();

try
{
this.Insert(CategoryID, resID, Mode, Subject, Description, Location, AllDayEvent, StartTime, EndTime, Reminder);

SqlCommand command = new SqlCommand();
command.CommandText = "SELECT @@IDENTITY";
command.Connection = this.Connection;

return (int)command.ExecuteScalar();
}

finally
{
this.Connection.Close();
}
}

Do you have any idea what might cause the issue?

I suspect this is somehow connected to the MSSQL related solution as I don't have these problems when trying to connect to the provided MDB file via OleDB...

Thank you,

Jakub

Intersoft Community - WebScheduler - Client side exception after inserting event

Client side exception after inserting event

Client side exception after inserting event