Inserting records in a database v6.0.2.1

Suggest edits

You can use the ExecuteNonQuery() method of EDBCommand to add records to a database stored on an EDB Postgres Advanced Server host with an INSERT command.

In the example that follows, the INSERT command is stored in the variable cmd. The values prefixed with a colon (:) are placeholders for EDBParameters that are instantiated, assigned values, and then added to the INSERT command's parameter collection in the statements that follow. The INSERT command is executed by the ExecuteNonQuery() method of the cmdInsert object.

The example adds an employee to the emp table:

<% @ Page Language="C#" Debug="true"%>
<% @Import Namespace="EnterpriseDB.EDBClient" %>
<% @Import Namespace="System.Data" %>
<% @Import Namespace="System.Configuration" %>

<script language="C#" runat="server" >

private void Page_Load(object sender, System.EventArgs e)
{
  string strConnectionString = ConfigurationManager.AppSettings
  ["DB_CONN_STRING"];
  EDBConnection conn = new EDBConnection(strConnectionString);

  try
  {
    conn.Open();

    string cmd = "INSERT INTO emp(empno,ename) VALUES(:EmpNo, :EName)";

    EDBCommand cmdInsert = new EDBCommand(cmd,conn);

    cmdInsert.Parameters.Add(new EDBParameter(":EmpNo",
      EDBTypes.EDBDbType.Integer));

    cmdInsert.Parameters[0].Value = 1234;

    cmdInsert.Parameters.Add(new EDBParameter(":EName",
      EDBTypes.EDBDbType.Text));

    cmdInsert.Parameters[1].Value = "Lola";

    cmdInsert.ExecuteNonQuery();
    Response.Write("Record inserted successfully");
  }

  catch(Exception exp)
    {
      Response.Write(exp.ToString());
  }
  finally
{
      conn.Close();
  }
}
</script>

Save the sample code in a file named insertEmployee.aspx in a web root directory.

To invoke the sample code, enter the following in a browser: http://localhost/insertEmployee.aspx