C# and PostgreSQL INSERT INTO

Question

I have this:

NpgsqlConnection c = new NpgsqlConnection(conx.getConexion());
c.Open();
NpgsqlDataAdapter da = new NpgsqlDataAdapter("Insert into \"Marca\" (\"NombreMarca\") values ('" + cbMarca.Text + "')", c);
c.Close();

And the table is:

CREATE SEQUENCE idmarca
  INCREMENT 1
  MINVALUE 1
  MAXVALUE 2147483647
  START 10
  CACHE 1;

CREATE TABLE "Marca"
( "idMarca" integer NOT NULL DEFAULT nextval('idmarca'::regclass),
  "NombreMarca" character varying(100) NOT NULL,
  CONSTRAINT "PKMarca" PRIMARY KEY ("idMarca" ),
  CONSTRAINT "UNombreMarca" UNIQUE ("NombreMarca" )
);

The problem is, when I try to insert into the table, for some reason nothing happens. That's on a try - catch, so no exceptions are being generated from the query. cbMarca is a combobox. The connection with the database is already tested.

Also, this works:

cbMarcaB.Items.Clear();
DataTable dt = cons.Select("Select \"NombreMarca\" From \"Marca\" Order by \"NombreMarca\"");
for (int i = 0; i < dt.Rows.Count; i++)
     {
         cbMarcaB.Items.Add(dt.Rows[i]["NombreMarca"]);
     }

So I don't know what the problem is ...

Have you checked resulting query string?

Timur Sadykov
– Timur Sadykov

2012-02-24 02:25:24 +00:00
Commented Feb 24, 2012 at 2:25 — Timur Sadykov
– Timur Sadykov, Commented Feb 24, 2012 at 2:25

shenku · Accepted Answer · 2012-02-24 01:35:26Z

2

I don't think you should be using the NpgsqlDataAdapter to do an insert rather use the NpgsqlCommand see the example below found here.

string insertQuery = "INSERT INTO npdata VALUES (@key, @ndata)";
NpAdapter.InsertCommand = new NpgsqlCommand(insertQuery, conn);

NpParam = NpAdapter.InsertCommand.Parameters.Add("@key", NpgsqlTypes.NpgsqlDbType.Text);
NpParam.SourceColumn = "key";
NpParam.SourceVersion = DataRowVersion.Current;

NpParam = NpAdapter.InsertCommand.Parameters.Add("@ndata", NpgsqlTypes.NpgsqlDbType.Bigint);
NpParam.SourceVersion = DataRowVersion.Current;
NpParam.SourceColumn = "ndata";

answered Feb 24, 2012 at 1:35

shenku

12.5k14 gold badges67 silver badges126 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

dbncourt Over a year ago

I saw that, but theres no NpAdapter in the library. Thats why i was using DataAdapter. What reference do i have to import to be able to use the Adapter?

shenku Over a year ago

Sorry, at the top of his code, private NpgsqlDataAdapter NpAdapter;

Collectives™ on Stack Overflow

C# and PostgreSQL INSERT INTO

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related