INSERT Statements

To insert into a table, use the standard INSERT SQL syntax.

In order to retrieve the Id of the last inserted record, use the SCOPE_IDENTITY function.

C#

String connectionString = "Account Id=XABC123456;Password=password;User=user;Role Id=3;Version=2013_1;Location=C:\\myfolder\\;Offline=false;";
using (NetSuiteConnection connection = new NetSuiteConnection(connectionString)) {
  NetSuiteCommand cmd = new NetSuiteCommand("INSERT INTO Account (AcctName) VALUES ('Petty Cash')", connection);
  cmd.ExecuteNonQuery();
    
  cmd = connection.CreateCommand();
  cmd.CommandText = "SELECT SCOPE_IDENTITY()";
  Object returnedValues = cmd.ExecuteScalar();
  String Id = (String)returnedValues;
}

VB.NET

Dim connectionString As [String] = "Account Id=XABC123456;Password=password;User=user;Role Id=3;Version=2013_1;Location=C:\\myfolder\\;Offline=false;"
Using connection As New NetSuiteConnection(connectionString)
  Dim cmd As New NetSuiteCommand("INSERT INTO Account (AcctName) VALUES ('Petty Cash')", connection)
  cmd.ExecuteNonQuery()
  cmd = connection.CreateCommand()
  cmd.CommandText = "SELECT SCOPE_IDENTITY()"
  Dim returnedValues As [Object] = cmd.ExecuteScalar()
  Dim Id As [String] = returnedValues
End Using