Insert and update don't work

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance





Hi, I have a store procedure to insert , and I use tableadapter to
execute this store procedure, when I run the application and execute the
sp , works ok
and after I see the datagridview and the new row is there, but the
problem ir that when I stop the application and look my database in SQL
Server 2005 the table don´t have the new row.
Somebody knows why? or Any idea to execute the store procedure to
insert or delete or update rows in SQL Server 2005 data base using C#
2005.

Thanks a lot!!
Regards!

*** Sent via Developersdex http://www.developersdex.com ***
.



Relevant Pages

  • ADOConnection TimeOut 30 second, no way to change it ???
    ... i use ADOConnection component to connect to SQL Server and using TQuey to ... When i execute the store procedure, it look like the setting is no effect ...
    (borland.public.delphi.database.ado)
  • Re: Insert and update dont work
    ... > execute this store procedure, when I run the application and execute the ... > and after I see the datagridview and the new row is there, ... > insert or delete or update rows in SQL Server 2005 data base using C# ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: ADO - lost records with asynchronous fetching
    ... the problem is that I execute a TADOStoredProc ... Furthermore AsyncFetch and AsyncFetchNonblocking set to True doesn't allow ... I don't need to show records, only to execute the store procedure. ...
    (borland.public.delphi.database.ado)
  • Records lost in an ADOStoredProc
    ... I have a situation, I execute a TADOStoredProc ... Furthermore AsyncFetch and AsyncFetchNonblocking set to True doesn't allow ... I don't need to show records, only to execute the store procedure. ...
    (borland.public.delphi.database.ado)
  • Update or Insert in tableadapter not working
    ... Hi, I have a store procedure to insert, and I use tableadapter to execute this store procedure, when I run the application and execute the sp with: ... or Any idea to execute the store procedure to insert or delete or update rows in SQL Server 2005 data base using C# 2005. ...
    (microsoft.public.dotnet.framework.adonet)