Normal
Thank you gemxI hate that if the recordings going to "manual", my wife asks me everytime: where is my recording??? 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.ConfigDo 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 What do you think about that?thank you for your help MoPhat
Thank you gemx
I hate that if the recordings going to "manual", my wife asks me everytime: where is my recording???
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
What do you think about that?
thank you for your help
MoPhat