recursion - recursive function in c# get a parameter -
i'm trying parameter function...
public static int subsumer(string id,int acc,sqlconnection connection)  {     acc++;     sqlcommand cercas = new sqlcommand("select * common_relation id_source ='" + id + "' , type='@' ", connection);     sqldatareader leggsyn = null;     leggsyn = cercas.executereader();      int f = 0;     while (leggsyn.read())      {         f=  subsumer(leggsyn["id_target"].tostring(),acc,connection);         if (acc <= f)          {              acc = f;          }       }       //siamo arrivati alla fine     return acc-1; }   each cycle parameter acc increment , debugging see in case reach value 3, in final recursion 0...i can't it...thank all
by returning acc - 1, decrementing f returned recursive call , don't think that's expect.
public static int subsumer(string id,int acc,sqlconnection connection)  {     sqlcommand cercas = new sqlcommand("select * common_relation id_source ='" + id + "' , type='@' ", connection);     sqldatareader leggsyn = null;     leggsyn = cercas.executereader();      int f = 0;     while (leggsyn.read())      {         f=  subsumer(leggsyn["id_target"].tostring(),acc + 1,connection);         if (acc <= f)          {              acc = f;          }       }       //siamo arrivati alla fine     return acc; }   on side note, querying recursively isn't design choice. querying recursively readers open each call on stack worse. not using query parmeters bad thing.
Comments
Post a Comment