Update or Insert in tableadapter not working

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 with :

dbPrensas2006DataSetTableAdapters.spq_PrensaTableAdapter prensa = new Prensas.dbPrensas2006DataSetTableAdapters.spq_PrensaTableAdapter();
int i = prensa.Update(ID, this.txtNombre.Text, int.Parse(txtNumero.Text));

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!
---
Posted via www.DotNetSlackers.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)
  • settings: ARITHABORT
    ... I have a .Net application that executes a store procedure, ... execute fine until I added a clustered unique index to one of the view .This ... But I am not able to reproduce the error when I execute the store procedure ... from the SQL server and happens only when called from my application. ...
    (microsoft.public.sqlserver.programming)