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 );
}