cant insert into a postgre sql table from c# please help to solve this......... |Thanks very much in advance

From: kona ajay <konaajay(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: cant insert into a postgre sql table from c# please help to solve this......... |Thanks very much in advance
Date: 2014-04-14 10:20:13
Message-ID: CA+4EtZvxp9tVajdpsSHV9eQLTzTdS8xSH_yaKPTH9WSSLRJKDA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

here i am sending my actual code

string employee = "insert into VSP_Employee values ('" + txtEmpid.Text +
"','" + txtEmpname.Text + "','" + txtEmailid.Text + "','" + txtphnum.Text +
"','" + txtDOB.Text + "','" +txtDOJ.Text + "','" + txtNOD.Text + "','" +
txtSalary.Text + "','" + txtLeavestaken.Text + "','" +
txtLeavesBalance.Text + "','" + txtPlannedleaves.Text+"')";
NpgsqlDataAdapter da = new NpgsqlDataAdapter(employee,
conn);
cmd = new NpgsqlCommand(employee, conn);
da = new NpgsqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds, "VSP_Employee");

Please help me in fixing this . Thanking you

Browse pgsql-bugs by date

  From Date Subject
Next Message John R Pierce 2014-04-14 17:54:23 Re: Fwd: cant insert into a post gre sql table...Can u please help in fixing this
Previous Message aleksey.vitaliev 2014-04-14 08:42:48 BUG #10014: Does not work PQfn in libpq with array