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
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
Posted"].Value = true;
this.cmdUpdate2.Parameters["GLTran"].Value =
ataRowView1["GLTran"];
try
{
this.cmdUpdate2.ExecuteNonQuery();
}
catch (System.Exception ex)
4. Update record by record.
5. There is no problem if the records is less than 1000 records.
6. If records is over 1000 records, I got the error message "The
connection is dead".
How can I configure the PostgreSQL 8.1.1 to handle it.
Thank you for any suggestion.
Pairat
--
