Skip site navigation (1) Skip section navigation (2)

Re: Problem with C# TableAdapter

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Klaus Ummenhofer <info(at)deciphe-it(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Problem with C# TableAdapter
Date: 2009-10-10 15:37:23
Message-ID: (view raw or whole thread)
Lists: pgsql-odbc
On Sat, 2009-10-10 at 16:33 +0200, Klaus Ummenhofer wrote:
> Hello community,
> I try to access a PostgreSql database with C# and have some problems creating a TableAdapter.

This doesn't answer your question, but why are you not using the .Net

Joshua D. Drake

> The problem is that a new TableAdapter does only create the SELECT command but not the commands for UPDATE, INSERT and DELETE. I am using the ODBC driver PSQLODBC30A.DLL, PostgreSql 8.4 and VS2005.
> I found some information affecting my problem which are related to primary keys. So far I am aware of needing a primary key in order to generate these commands. Please could someone inspect the CREATE scripts below which are not working properly and let me know, how I should change them.
> What else could I do in order to use the database via a TableAdapter object?
> Thank you.
> Klaus
> CREATE TABLE films (
> code char(5) CONSTRAINT firstkey PRIMARY KEY,
> title varchar(40) NOT NULL,
> did integer NOT NULL,
> date_prod date,
> kind varchar(10),
> len interval hour to minute
> );
> (
> id serial NOT NULL,
> "name" character varying(10) NOT NULL,
> script_data text,
> )
> WITH (
> );
> ALTER TABLE script OWNER TO postgres;
-- Major Contributor
Command Prompt, Inc: - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
If the world pushes look it in the eye and GRR. Then push back harder. - Salamander

In response to

pgsql-odbc by date

Next:From: Klaus UmmenhoferDate: 2009-10-10 15:50:45
Subject: Re: Problem with C# TableAdapter
Previous:From: Klaus UmmenhoferDate: 2009-10-10 14:33:14
Subject: Problem with C# TableAdapter

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group