Reply to thread

Thank you gemx


I hate that if the recordings going to "manual", my wife asks me everytime: where is my recording??? :mad:


In my code i have normaly sql statements like this:


 [CODE]public static void update_ScheduleEntry(cProgram schedule)

        {

            SqlConnection SqlCon = new SqlConnection(myConnection);

            try

            {

                SqlCon.Open();

                SqlCommand SqlCmd = new SqlCommand("UPDATE Schedule SET  startTime = @startTime, endTime = @endTime WHERE id_Schedule = @id_Schedule", SqlCon);

                SqlCmd.Parameters.AddWithValue("@id_Schedule", schedule.id_Schedule);

                SqlCmd.Parameters.AddWithValue("@startTime", schedule.startTime);

                SqlCmd.Parameters.AddWithValue("@endTime", schedule.endTime);

                SqlCmd.ExecuteNonQuery();

            }

            catch (Exception exp)

            {

                Log.Error(exp.Message, new object[0]);

            }

            finally

            {

                if (SqlCon.State == ConnectionState.Open)

                {

                    SqlCon.Close();

                }

            }

        }[/CODE]

and i need just for the "myConnection" the connection string of Gentle.Config


Do i get with "LoadConnectionDetails" a SqlConnection  object?


Can i fire at last the method RemoteControl.Instance.OnNewSchedule();" or on every table change?



P.S.


I have a idea for documentations:

Everyone ho create/change a interface / namespace / method etc. must update/create a wiki entry for this piece of code.


Without that, the code/patch etc. is not inserted in the SVN!

Then we had a well docu of all this classes :p


What do you think about that?


thank you for your help :D :D :D :D :D :D

MoPhat


Top Bottom