Re: [GENERAL] The connection is dead

2006-01-09 Thread pairat
Thank you for your response. I use ODBC instead of Npgsql because I can use ODBC with other database such as MS Access, and MS SQL. Here is the code. System.DateTime dateTimeNow = System.DateTime.Now; int i=0; dataView1.RowFilter = "Posted = true"; dataView1.Sort = "GLTran, ID"; //GLTran Table in

Re: [GENERAL] The connection is dead

2006-01-09 Thread pairat
Hi Jonel Thank you for your response. I use ODBC instead of Npgsql because the program can use with MS Access, MS SQL and PostgreSQL. Here is the code. int n = this.BindingContext[dataView1].Count - 1; string _Journal; DataRowView DataRowView1; this.cmdInsert.Transaction = _Transaction; this.cm

Re: [GENERAL] The connection is dead

2006-01-09 Thread pairat
I use ODBC instead of Npgsql because the ODBC can use with MS Access, MS SQL and PostgreSQL database. Here is the code. System.DateTime dateTimeNow = System.DateTime.Now; int i=0; dataView1.RowFilter = "Posted = true"; dataView1.Sort = "GLTran, ID"; //GLTran Table int n = this.BindingContext[data

Re: [GENERAL] The connection is dead

2006-01-07 Thread Jonel Rienton
connection is dead Hi, I'm running PostgreSQL 8.1.1 on the WindowsXP box with following information: 1. Programming Language C# MS .NET Framework 2. ADO NET connection through PostgresODBC 3. Using "Connection.BeginTransaction(IsolationLevel.ReadCommitted) and Transaction.Commit

[GENERAL] The connection is dead

2006-01-07 Thread pairat
Hi, I'm running PostgreSQL 8.1.1 on the WindowsXP box with following information: 1. Programming Language C# MS .NET Framework 2. ADO NET connection through PostgresODBC 3. Using "Connection.BeginTransaction(IsolationLevel.ReadCommitted) and Transaction.Commit to update database. 4. Update record