Hi You can use BatchUpdate for this try { Craete SQL COmmand Object cmd.CommandType = CommandType.StoredProcedure; cmd.UpdatedRowSource = UpdateRowSource.None; cmd.Parameters.Add("@Param1", SqlDbType.Int, 4, argDt.Columns[0].ColumnName); cmd.Parameters.Add("@Pram2", SqlDbType.Bit, 5, argDt.Columns[1].ColumnName); cmd.CommandTimeout = 0; SqlDataAdapter da = new SqlDataAdapter(); da.InsertCommand = cmd; da.UpdateBatchSize = 100; conn.Open(); int recordsInserted = da.Update(argDt); conn.Close(); }
Inderjeet Kaur Sr. Software Engg