title: Insert multiple rows in SQL as sqlparameter
body: <p>I got 1000 rows in my data-table <code>dt</code> and I want to insert all this data to my sql table in one shot.I know how to do this with a for loop..but I wonder is there any other better way to do this all rows to datatbase in single shot.
  My current code to insert this data is like this</p>
  
  <pre><code> DataTable dt = result.Tables[0];
  
  
          SqlHelper.ExecuteScalar(GlobalSettings.DbDSN, CommandType.Text,
                                    "INSERT INTO tbl_Projects (Project,Owner,Consultant ,Contractor,Value ,Level1,Level2 ,Status  ,Country ,CreatedDate  ,CreatedByID ,CreatedByName) VALUES (@Project,@Owner,@Consultant ,@Contractor,@Value ,@Level1,@Level2 ,@Status  ,@Country ,@CreatedDate  ,@CreatedByID ,@CreatedByName)",
                                    new SqlParameter("@Project",dt.Rows[0].ItemArray[0]),
                                    new SqlParameter("@Owner", dt.Rows[0].ItemArray[1]),
                                    new SqlParameter("@Consultant", dt.Rows[0].ItemArray[2]),
                                    new SqlParameter("@Contractor", dt.Rows[0].ItemArray[3]),
                                    new SqlParameter("@Value", dt.Rows[0].ItemArray[4]),
                                    new SqlParameter("@Level1", dt.Rows[0].ItemArray[5]),
                                    new SqlParameter("@Level2", dt.Rows[0].ItemArray[6]),
                                    new SqlParameter("@Status", dt.Rows[0].ItemArray[7]),
                                    new SqlParameter("@Country", dt.Rows[0].ItemArray[8]),
                                    new SqlParameter("@CreatedDate", System.DateTime.Now),
                                    new SqlParameter("@CreatedByID", ""),
                                    new SqlParameter("@CreatedByName", ""));
  </code></pre>
  
  <p>Can any one give me a hand on this..</p>