title: How to bulk insert by checking every row in datagrid if there is data in some columns
body: <p>The data grid in the front end interface looks like below. At least one of the color textbox should have value when the insert button is clicked. And insert a new row if there is data in any one of the color columns. And the table design in the database is like below. The status column refers to the colors in the interface. When the button is clicked, it should do a bulk insert, where it loops through every row and if there is data in the color columns, it should create at least 3 records per row.</p>
  <p><a href="https://i.stack.imgur.com/WSWXj.png" rel="nofollow noreferrer">enter image description here</a>
  <a href="https://i.stack.imgur.com/c8kIr.png" rel="nofollow noreferrer">enter image description here</a></p>
  <p><a href="https://i.stack.imgur.com/5L5ZN.png" rel="nofollow noreferrer">enter image description here</a></p>
  <p><a href="https://i.stack.imgur.com/BjZ2J.png" rel="nofollow noreferrer">enter image description here</a></p>