insert multiple records at once in database

foreach (Employee item in employees)
{

   if (iCounter == 0)
  {
    cmd.BeginTransaction;
  }
  string sql = @"INSERT INTO Mytable (id, name, salary) 
    values ('@id', '@name', '@salary')";
 //add parameters
  cmd.CommandText = sql; 
  cmd.ExecuteNonQuery();
  iCounter ++;
  if(iCounter >= 500)
  {
     cmd.CommitTransaction;
     iCounter = 0;
  }
}

if(iCounter > 0)
   cmd.CommitTransaction;

var db = new StoreDataContext();
using(var scope = new TransactionScope()){
    foreach(var emp in employee){
        db.employee.Insert();
        db.SubmitChanges(ConflictMode.FailOnFirstConflict);
    }
    scope.Complete();
}

CREATE PROCEDURE [dbo].[multipleInsert]
(
	@xmlData NVARCHAR(max)
)
AS
BEGIN
INSERT INTO employee (id, name, dob)
	SELECT		
	node.trnl.value('id', 'varchar(10)') id,
	node.trnl.value('name', 'nvarchar(100)') name,
	node.trnl.value('dob', 'nvarchar(8)') dob,
FROM @xml.nodes('/root/employee') node(trnl)

<root>
		<employee id="00163500C6" xml:space="preserve">
		<name>Rafeeq</name>
		<dob>12-12-2011</dob>    
	  </empoloyee>
	 </root>
END

for(int i = 0; i<gridview1.rows.count; i++)
{
// put your insert query here
}

public void InsertData(string name)
{
   for(int ctr=0; ctr < maxCount; ctr++)
   {
      //DO CALL FOR INSERT WITH DYNAMIC PARAMETERS
      InsertData(name);
   }
}