title: Retrieve the last id from the SQL Server database table
body: <p>How do I get the last id created in the policy table and store it into a variable so that I can use it for another table called backupspec table.</p>
  
  <pre><code>System.Data.SqlClient.SqlConnection dataConnection = new SqlConnection();
              dataConnection.ConnectionString =
                  @"Data Source=JAGMIT-PC\SQLEXPRESS;Initial Catalog=SumooHAgentDB;Integrated Security=True";
  
              System.Data.SqlClient.SqlCommand dataCommand = new SqlCommand();
              dataCommand.Connection = dataConnection;
  
              //tell the compiler and database that we're using parameters (thus the @first, @last, @nick)  
              dataCommand.CommandText = ("Insert Policies ( PolicyName, PolicyDesc, TimeAdded,OSFlag, CreateVSSSnapshot, CreateAuditLogForRecoveries, AllowUsersToOverwriteFiles, AutoHandleEnvErrors, NotifyOnEnvErrorCount, NotifyOnFileFailure, NotifyOnFileFailureCount, NotifyOnLackOfPCContact, NotifyOnLackOfPCContactDays, NotifyOnRecoveryFailures, NotifyOnRecoveryFailureReason) values (@pn,@pd,@TimeAdded,@os,@vss,@al,@uow,@hee,@oeec,@off,@offc,@oloc,@olocd,@orf,@orfr)");
  
  
  
  
          dataCommand.Parameters.AddWithValue("@pn",pn);
          dataCommand.Parameters.AddWithValue("@pd",pd);
          dataCommand.Parameters.AddWithValue("@TimeAdded",TimeAdded);
          dataCommand.Parameters.AddWithValue("@os",os);
          dataCommand.Parameters.AddWithValue("@vss",vss);
          dataCommand.Parameters.AddWithValue("@al",al);
          dataCommand.Parameters.AddWithValue("@uow",uow);
          dataCommand.Parameters.AddWithValue("@hee",hee);
          dataCommand.Parameters.AddWithValue("@oeec",oeec);
          dataCommand.Parameters.AddWithValue("@off",off);
          dataCommand.Parameters.AddWithValue("@offc",offc);
          dataCommand.Parameters.AddWithValue("@oloc",oloc);
          dataCommand.Parameters.AddWithValue("@olocd",olocd);
          dataCommand.Parameters.AddWithValue("@orf",orf);
          dataCommand.Parameters.AddWithValue("@orfr",orfr);
  
          dataConnection.Open();
  
          dataCommand.ExecuteNonquery();
  
  
          dataConnection.Close();
  
  
          ArrayList jaja = (ArrayList)Session["BackupSpecList"];
  
  
          for (int i = 0; i &lt; jaja.Count; i++)
          {
              BackupSpecEntry bsp = (BackupSpecEntry)jaja[i];
              string path = bsp.path;
              string inclExcl = bsp.inclExcl;
              byte inclExclFlags = bsp.inclExclFlags;
              bool indexContents = bsp.indexContents;
              int serverBackupSpecId = bsp.serverBackupSpecId;
              int freq = bsp.freq;
              int retention = bsp.retention;
              int policyID =DONT KNOW HOW TO GET THIS VALUE;
              long specChangeTime = 0;
              long backupTime = 0;
  
              dataCommand.CommandText = ("Insert BackupSpec (PolicyID, Path, ServerBackupSpecID, Freq, Retention, InclExclFlags, InclExcl, IndexContents, SpecChangeTime, BackupTime) values (@policyID,@path,@serverBackupSpecId,@freq,@retention,@inclExclFlags,@inclExcl,@indexContents,@specChangeTime,@backupTime)");
  
              dataCommand.Parameters.AddWithValue("@policyID", policyID);
              dataCommand.Parameters.AddWithValue("@path", path);
              dataCommand.Parameters.AddWithValue("@serverBackupSpecId", serverBackupSpecId);
              dataCommand.Parameters.AddWithValue("@freq", freq);
              dataCommand.Parameters.AddWithValue("@retention", retention);
              dataCommand.Parameters.AddWithValue("@inclExclFlags", inclExclFlags);
              dataCommand.Parameters.AddWithValue("@inclExcl", inclExcl);
              dataCommand.Parameters.AddWithValue("@indexContents", indexContents);
              dataCommand.Parameters.AddWithValue("@specChangeTime", specChangeTime);
              dataCommand.Parameters.AddWithValue("@backupTime", backupTime);
  
  
              dataConnection.Open();
              dataCommand.ExecuteNonQuery();
              dataConnection.Close();
  
          }
  </code></pre>
  
  <p>I am getting error with the label id...</p>
  
  <p>can some 1 help me with this..??</p>
  
  <p>I am not getting the last policyID created after inserting please help...
  Please help</p>