Sending SQL string in for every calculated date

See more:

C#

SQL

Hello there,

I have a sql string now, and I need to send it in, for every day between 2 dates. like, if the first date yould be, 01.01.0001 and the last date would be 03.01.0001 then, the string should be send 3 times in with every date (01. + 02. + 03.01.0001)

Any ideas for I can integrate that in my script when I already need to send the string in for every selected member ID?

That means, if I have 3 IDs, and 3 days, there would be 3 strings for every ID = 9 strings per total.

Please note, that the dates are dynamic as well as the amout of IDs.

What I have tried:

foreach (DataRow row in m_dt.Rows) {
                foreach (var item in row.ItemArray) {
                    string sqlString = "INSERT INTO [table] ([id] ,[day] ,[month] ,[year]) VALUES('" + item + "', '" + reason + "', '10', '08', '2016', '1' )";
                    Sendin( sqlString );
                }