Comments by Member 12161319

Member 12161319 25-Nov-15 7:16am View

yes but i need to know the code and how i would do it

Member 12161319 23-Nov-15 14:36pm View

http://www.codeproject.com/Questions/1058871/Exception-thrown-System-Data-SqlClient-SqlExceptio

Member 12161319 23-Nov-15 14:12pm View

just debugged it basically its adding all the data but its adding another one with no value so its null.. can't see why

Member 12161319 23-Nov-15 13:58pm View

this is what my database looks like:

id Name Date
NULL NULL NULL

is that a problem?

Member 12161319 23-Nov-15 13:47pm View

Done what you have done now i get this:

Exception thrown: 'System.Data.SqlClient.SqlException' in System.Data.dll

Additional information: Cannot insert the value NULL into column 'Id', table 'Login.dbo.Rota'; column does not allow nulls. INSERT fails.

The statement has been terminated.

i guess this means that there is no data going into the database? but there is..?

Member 12161319 23-Nov-15 12:54pm View

Done that now i get this error:

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll

Additional information: The variable name '@Id' has already been declared. Variable names must be unique within a query batch or stored procedure.

any sugguestions?

Comments by Member 12161319 (Top 6 by date)