Cross-database references are not implemented
Posted: Tue 17 May 2005 18:29
I am just switching over my app from using the npgsql driver to the corelab's driver. Everything worked ok in the npgsql driver, but I get an error using the crlab driver when I try to update rows. Here is the code I'm using:
Any ideas as to what I'm doing wrong?
OLIVER
Code: Select all
DataSet ds = new DataSet();
PgSqlDataAdapter da = new PgSqlDataAdapter("select * from prospect where 0=1", conn);
da.FillSchema(ds, SchemaType.Source);
DataTable prospect_dt = ds.Tables["Table"];
prospect_dt.TableName = "prospect";
DataRow newProspect = prospect_dt.NewRow();
newProspect["prospect_id"] = oProspect.ProspectID;
newProspect["agency"] = Convert.ToInt16(oProspect.Agency);
newProspect["branch"] = Convert.ToInt16(oProspect.Branch);
newProspect["name"] = oProspect.Name;
newProspect["street"] = oProspect.Street;
newProspect["city"] = oProspect.City;
newProspect["state"] = oProspect.State;
newProspect["zip"] = oProspect.ZipCode;
newProspect["phone_bus"] = oProspect.PhoneBusiness;
newProspect["user2"] = oProspect.UserField2;
da.InsertCommand = new PgSqlCommandBuilder(da).GetInsertCommand();
ds.Tables["prospect"].Rows.Add(newProspect);
da.Update(ds, "prospect");
OLIVER