Hello, i've made an application with the vb.net and i created my connection through the sql server by stored procedure. The identity of the [ID] of the table that the data is stored in is on and i've entered some data as a trial. Then i've deleted the rows that i've entered and i made the identity off and then i made refresh then i made the identity on so that the data entered to be accurate. unfortunately when i've ran the application no data was stored in the table and there is no error appeared !! and i don't know what to do!! Your help is appriciated
You can use SQL Server profiler to capture the commands that go to the SQL Server. This way yyou can see if the command to insert the data is even getting executed. You will want to capture the following events: Errors and Warnings TSQL Stored procedures Launch Profiler and then insert data via the application. Check to see if the insert gets to SQL Server. There may be an error that is getting generated. Rand This posting is provided "as is" with no warranties and confers no rights.
Don't see what you're looking for? Try a search.
|