[Firebird-net-provider] Re: Helping inserting data on a firebird database using C#.

2006-04-11 Thread Fabio Gomes
Hi, thats me again :)Now i m trying to delete a record using this: int codigo=int.Parse(this.txtCli_cod.Text); if (dr ==DialogResult.Yes){ try { da_cli.DeleteCommand = con.CreateCommand(); da_cli.DeleteCommand.CommandText = DELETE FROM

Re: [Firebird-net-provider] Re: Helping inserting data on a firebird database using C#.

2006-04-11 Thread Carlos Guzmán Álvarez
Hello: int codigo=int.Parse(this.txtCli_cod.Text); if (dr ==DialogResult.Yes){ try { da_cli.DeleteCommand = con.CreateCommand(); da_cli.DeleteCommand.CommandText = DELETE FROM

Re: [Firebird-net-provider] Re: Helping inserting data on a firebird database using C#.

2006-04-11 Thread Carlos Guzmán Álvarez
Hello: Sorry.. what do mean changes before the update? Check if ds_cli.HasChanges is true if not the dataadapter will have nothing to update, did you have deleted the Row from the datatable right ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code,

Re: [Firebird-net-provider] Re: Helping inserting data on a firebird database using C#.

2006-04-11 Thread Fabio Gomes
No, o didnt do that.I think that this is the problem then.I try to read about it, i m completely lost on this stuff.Thanx :)On 4/11/06, Carlos Guzmán Álvarez [EMAIL PROTECTED] wrote: Hello: Sorry.. what do mean changes before the update?Check if ds_cli.HasChanges is true if not the dataadapter

Re: [Firebird-net-provider] Re: Helping inserting data on a firebird database using C#.

2006-04-11 Thread Fabio Gomes
i tried this: DataTable dtTable = ds_cli.Tables[0]; dtTable.PrimaryKey = dtTable.Columns[0]; DataRow delete = dtTable.Rows.Find(txtCli_cod); delete.Delete();But it gives me an error, how am i supposed to pass the PrimaryKey value to the dataTable?Thanx again, and sorry for the

Re: [Firebird-net-provider] Re: Helping inserting data on a firebird database using C#.

2006-04-11 Thread Carlos Guzmán Álvarez
Hello: delete.Delete(); For this line try instead: dtTable.Rows.Remove(delete); -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg )