ADO.net Batch

Go back to: Code Samples
sql = "INSERT INTO employees VALUES (?, ?, ?)" +
";INSERT INTO employees VALUES (?, ?, ?)" +
...
";INSERT INTO employees VALUES (?, ?, ?)";
cmd.CommandText = sql;
cmd.Prepare();
cmd.Parameters[0].Value = id[0];
cmd.Parameters[1].Value = name[0];
cmd.Parameters[2].Value = salary[0];
...
cmd.Parameters[27].Value = id[9];
cmd.Parameters[28].Value = name[9];
cmd.Parameters[29].Value = salary[9];
cmd.ExecuteNonQuery();




Like what you see? Share and Enjoy:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google
  • LinkedIn
  • Reddit
  • StumbleUpon
  • Technorati
  • TwitThis

Book Content Copyright © 2009 by Prentice Hall PTR. All rights reserved. | Corporate Sponsor DataDirect Technologies.