PsqlConnection    DBConn; 
DBConn = new PsqlConnection("ServerDSN=DEMODATA; 
								UID=test; 
								PWD=test; 
								Server=localhost;"); 
PsqlDataAdapter    myDataAdapter = new 
PsqlDataAdapter(); 
PsqlCommand    DBCmd = new PsqlCommand("select * from 
emp",DBConn); 
myDataAdapter.SelectCommand = DBCmd; 
//  Set up the CommandBuilder 
PsqlCommandBuilder  CommBuild = new 
PsqlCommandBuilder(myDataAdapter); 
DataSet      myDataSet = new DataSet(); 
try  
{ 
    DBConn.Open(); 
    myDataAdapter.Fill(myDataSet); 
    //  Now change the salary of the first employee 
    DataRow     myRow; 
    myRow = myDataSet.Tables["Table"].Rows[0]; 
    myRow["sal"] = 95000; 
    // Tell the DataAdapter to resynch with the 
Pervasive.SQL server. 
    // Without the CommandBuilder, this line would fail. 
    myDataAdapter.Update(myDataSet); 
} 
catch (Exception ex)  
{ 
    // Display any exceptions in a messagebox 
    MessageBox.Show (ex.Message); 
} 
//  Close the connection 
DBConn.Close();