c# - translate my code to a batch file for me -

i need write batch file run automatically @ particular time of day , got many solutions forums working fine in case need write sql query quite complex state c# code need run , need in sql query

my c# code looking as:

public void mark_absent()         {             int userid = 0, last_rec = last_record();             bool isapproved;               cmd = new sqlcommand("select top(1) userid,isapproved tbluser ", conn);             conn.open();             dr = cmd.executereader();             if (dr.read())             {                  userid = convert.toint32(dr["userid"].tostring());                 isapproved = convert.toboolean(dr["isapproved"].tostring());                  dr.close();                 conn.close();             }             else             {                 dr.close();                 conn.close();             }              (int = userid; <= last_rec; i++)             {                 cmd = new sqlcommand("select userid,isapproved tbluser userid='" + userid + "' , isapproved='true'", conn);                 conn.open();                 dr = cmd.executereader();                 if (dr.read())                 {                     dr.close();                     conn.close();                     cmd = new sqlcommand("select userid,atndate tblattend convert(date,atndate)='" + datetime.now.date + "' , userid='" + userid + "'", conn);                     conn.open();                     dr = cmd.executereader();                     if (dr.read())                     {                         conn.close();                         dr.close();                         //count++;                      }                     else                     {                         dr.close();                         conn.close();                         cmd = new sqlcommand("insert tblattend (atndate,checkin,chkout,status,workhrs,extrahrs,userid,crtupdate) values ('" + datetime.now + "','00:00:00','00:00:00','absent','00:00:00','-09:00:00','" + userid + "','" + datetime.now + "')", conn);                         conn.open();                         cmd.executenonquery();                         conn.close();                     }                 }                 else                 {                     conn.close();                     dr.close();                  }                 userid = userid + 1;              }         } 

in batch file found select or delete or insert command here need sqldatareader looping

so how can write c# code in sql query. if wrong best solution people suggest me...?

thanks help.

the simplest solution, since have working c# code, create console application, , use existing code in main() method.

compile exe, , place exe somewhere on computer code must run.

use windows task scheduler schedule exe run needed.

make sure add logging can keep track of errors happen when program runs unattended. nlog place start.