public static void ShowErrors(SqlCeException e) { SqlCeErrorCollection errorCollection = e.Errors; StringBuilder bld = new StringBuilder(); Exception inner = e.InnerException; foreach (SqlCeError err in errorCollection) { bld.Append("\n Error Code: " + err.HResult.ToString("X")); bld.Append("\n Message : " + err.Message); bld.Append("\n Minor Err.: " + err.NativeError); bld.Append("\n Source : " + err.Source); foreach (int numPar in err.NumericErrorParameters) { if (0 != numPar) { bld.Append("\n Num. Par. : " + numPar); } } foreach (string errPar in err.ErrorParameters) { if (String.Empty != errPar) { bld.Append("\n Err. Par. : " + errPar); } } Console.WriteLine(bld.ToString()); bld.Remove(0, bld.Length); } }
public static void ShowErrors(SqlCeException e) { SqlCeErrorCollection errorCollection = e.Errors; StringBuilder bld = new StringBuilder(); Exception inner = e.InnerException; foreach (SqlCeError err in errorCollection) { bld.Append("\n Error Code: " + err.HResult.ToString("X", System.Globalization.CultureInfo.CurrentCulture)); bld.Append("\n Message : " + err.Message); bld.Append("\n Minor Err.: " + err.NativeError); bld.Append("\n Source : " + err.Source); foreach (int numPar in err.NumericErrorParameters) { if (0 != numPar) { bld.Append("\n Num. Par. : " + numPar); } } foreach (string errPar in err.ErrorParameters) { if (String.Empty != errPar) { bld.Append("\n Err. Par. : " + errPar); } } } MessageBox.Show(bld.ToString()); }
/// <summary> /// Point d'entrée principal de l'application. /// </summary> static void Main() { try { Application.Run(new Form1()); } catch (SqlCeException e) { SqlCeErrorCollection errorCollection = e.Errors; StringBuilder bld = new StringBuilder(); Exception inner = e.InnerException; if (null != inner) { MessageBox.Show("Inner Exception: " + inner.ToString()); } foreach (SqlCeError err in errorCollection) { bld.Append("\n Error Code: " + err.HResult.ToString("X")); bld.Append("\n Message : " + err.Message); bld.Append("\n Minor Err.: " + err.NativeError); bld.Append("\n Source : " + err.Source); foreach (int numPar in err.NumericErrorParameters) { if (0 != numPar) { bld.Append("\n Num. Par. : " + numPar); } } foreach (string errPar in err.ErrorParameters) { if (String.Empty != errPar) { bld.Append("\n Err. Par. : " + errPar); } } MessageBox.Show(bld.ToString()); bld.Remove(0, bld.Length); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public List <GardenEntity> PlantsToPlantInThisMonth(GardenEntity.Month thisMonth) { List <GardenEntity> gardenEntities = new List <GardenEntity>(); using (SqlCeConnection con = new SqlCeConnection(conString)) { try { con.Open(); } catch (SqlCeException ee) { //unable to open SqlCe connection SqlCeErrorCollection errorCollection = ee.Errors; StringBuilder bld = new StringBuilder(); Exception inner = ee.InnerException; if (inner != null) { bld.AppendLine("Inner Exception: " + inner.ToString()); } foreach (SqlCeError err in errorCollection) { bld.AppendLine(err.ToString()); } } string tmp = ((int)thisMonth).ToString(); using (SqlCeCommand com = new SqlCeCommand("SELECT * FROM Plant WHERE SeedStartMonths LIKE '% " + tmp + " %'", con)) { SqlCeDataReader reader = com.ExecuteReader(); while (reader.Read()) { try { AddReaderToGardenEntityList(gardenEntities, reader); } catch (Exception) { //unable to parse datas } } } } return(gardenEntities); }
public List <GardenEntity> ListAnnual() { List <GardenEntity> gardenEntities = new List <GardenEntity>(); using (SqlCeConnection con = new SqlCeConnection(conString)) { try { con.Open(); } catch (SqlCeException ee) { //unable to open SqlCe connection SqlCeErrorCollection errorCollection = ee.Errors; StringBuilder bld = new StringBuilder(); Exception inner = ee.InnerException; if (inner != null) { bld.AppendLine("Inner Exception: " + inner.ToString()); } foreach (SqlCeError err in errorCollection) { bld.AppendLine(err.ToString()); } } using (SqlCeCommand com = new SqlCeCommand("SELECT Plant.ID, Plant.Name, Plant.Description, Plant.Maintenance, Plant.Type, Plant.LightExposure, Plant.SeedStartMonths, Plant.WithstandColdestZone, Plant.WithstandHottestZone, PlantType.ID AS Expr1, PlantType.Type AS Expr2 FROM Plant INNER JOIN PlantType ON Plant.Type = PlantType.ID WHERE (PlantType.Type = 'Annual')", con)) { SqlCeDataReader reader = com.ExecuteReader(); while (reader.Read()) { try { AddReaderToGardenEntityList(gardenEntities, reader); } catch (Exception) { //unable to parse datas } } } } return(gardenEntities); }
public List <GardenEntity> ViewAllPlantsInGarden() { List <GardenEntity> gardenEntities = new List <GardenEntity>(); using (SqlCeConnection con = new SqlCeConnection(conString)) { try { con.Open(); } catch (SqlCeException ee) { //unable to open SqlCe connection SqlCeErrorCollection errorCollection = ee.Errors; StringBuilder bld = new StringBuilder(); Exception inner = ee.InnerException; if (inner != null) { bld.AppendLine("Inner Exception: " + inner.ToString()); } foreach (SqlCeError err in errorCollection) { bld.AppendLine(err.ToString()); } } using (SqlCeCommand com = new SqlCeCommand("SELECT * FROM Plant", con)) { SqlCeDataReader reader = com.ExecuteReader(); while (reader.Read()) { try { AddReaderToGardenEntityList(gardenEntities, reader); } catch (Exception) { //unable to parse datas } } } } return(gardenEntities); }
public List <GardenEntity> ListPlantsInZone(GardenEntity.hardinessZone myZone) { List <GardenEntity> gardenEntities = new List <GardenEntity>(); using (SqlCeConnection con = new SqlCeConnection(conString)) { try { con.Open(); } catch (SqlCeException ee) { //unable to open SqlCe connection SqlCeErrorCollection errorCollection = ee.Errors; StringBuilder bld = new StringBuilder(); Exception inner = ee.InnerException; if (inner != null) { bld.AppendLine("Inner Exception: " + inner.ToString()); } foreach (SqlCeError err in errorCollection) { bld.AppendLine(err.ToString()); } } using (SqlCeCommand com = new SqlCeCommand("SELECT * FROM Plant WHERE Plant.WithstandColdestZone <= '" + (int)myZone + "' AND Plant.WithstandHottestZone >= '" + (int)myZone + "'", con)) { SqlCeDataReader reader = com.ExecuteReader(); while (reader.Read()) { try { AddReaderToGardenEntityList(gardenEntities, reader); } catch (Exception) { //unable to parse datas } } } } return(gardenEntities); }
/// <summary> /// Handle for the server messages. /// </summary> /// <param name="sender">The sender.</param> /// <param name="e"> /// The <see cref="System.Data.SqlClient.SqlInfoMessageEventArgs"/> instance containing the message data. /// </param> private void InfoMessageHandler(object sender, SqlCeInfoMessageEventArgs e) { SqlCeErrorCollection errors = e.Errors; if (errors == null || errors.Count == 0) { DbMessageEventArgs eventArgs = new DbMessageEventArgs(e.Message); OnDbMessage(eventArgs); } else { foreach (SqlCeError error in errors) { TraceLevel severity = GetSeverity(error); SqlCeMessage message = new SqlCeMessage(error); DbMessageEventArgs eventArgs = new DbMessageEventArgs(message); OnDbMessage(eventArgs); } } }
public static void ShowErrors(SqlCeException e) { SqlCeErrorCollection errors = e.Errors; Exception inner = e.InnerException; StringBuilder builder = new StringBuilder(); if (inner != null) { MessageBox.Show(inner.ToString(), "Inner Exception"); } foreach (SqlCeError error in errors) { builder.Append("\r Error Code: " + error.HResult.ToString("X")); builder.Append("\r Message : " + error.Message); builder.Append("\r Minor Err.: " + error.NativeError); builder.Append("\r Source : " + error.Source); foreach (int param in error.NumericErrorParameters) { if (param != 0) { builder.Append("\r Num. Par. : " + param.ToString()); } } foreach (string errPar in error.ErrorParameters) { if (errPar != String.Empty) { builder.Append("\r Err. Par. : " + errPar); } } if (builder.ToString().Length > 0) { MessageBox.Show(builder.ToString(), "SqlCE Error"); } builder.Remove(0, builder.Length); } }
internal static void ShowErrors(SqlCeException e) { SqlCeErrorCollection errorCollection = e.Errors; StringBuilder bld = new StringBuilder(); Exception inner = e.InnerException; if (null != inner) { Console.Error.WriteLine("Inner Exception: " + inner.ToString()); } // Enumerate the errors to a message box. foreach (System.Data.SqlServerCe.SqlCeError err in errorCollection) { bld.Append("\n Error Code: " + err.HResult.ToString("X", System.Globalization.CultureInfo.InvariantCulture)); bld.Append("\n Message : " + err.Message); bld.Append("\n Minor Err.: " + err.NativeError); bld.Append("\n Source : " + err.Source); // Enumerate each numeric parameter for the error. foreach (int numPar in err.NumericErrorParameters) { if (0 != numPar) { bld.Append("\n Num. Par. : " + numPar); } } // Enumerate each string parameter for the error. foreach (string errPar in err.ErrorParameters) { if (!string.IsNullOrEmpty(errPar)) { bld.Append("\n Err. Par. : " + errPar); } } Console.Error.WriteLine(bld.ToString()); bld.Remove(0, bld.Length); } }
public void ShowErrors(SqlCeException e) { SqlCeErrorCollection errorCollection = e.Errors; StringBuilder bld = new StringBuilder(); Exception inner = e.InnerException; if (inner != null) { MessageBox.Show(("Inner Exception: " + inner.ToString())); } foreach (SqlCeError err in errorCollection) { bld.Append("\n" + " Error Code: " + err.HResult.ToString()); bld.Append("\n" + " Message : " + err.Message); bld.Append("\n" + " Minor Err.: " + err.NativeError); bld.Append("\n" + " Source : " + err.Source); foreach (int numPar in err.NumericErrorParameters) { if (0 != numPar) { bld.Append("\n" + " Num. Par. : " + numPar); } } foreach (string errPar in err.ErrorParameters) { if (string.Empty != errPar) { bld.Append("\n" + " Err. Par. : " + errPar); } } MessageBox.Show(bld.ToString()); bld.Remove(0, bld.Length); } }
// pas dispo avec le compact framework // [STAThread] static void Main() { try { splash = new SplashForm(); splash.Show(); splash.Label = "Connexion à la base..."; splash.Label = "Vérification des versions..."; if (!CheckVersion()) { throw new Exception("Erreur de version"); } splash.Label = "Création de la fenêtre principale..."; mainform = new Repertoire(); System.Threading.Thread splashClose = new System.Threading.Thread(new System.Threading.ThreadStart(CloseSplash)); splashClose.Start(); System.Windows.Forms.Application.Run(mainform); } catch (SqlCeException e) { SqlCeErrorCollection errorCollection = e.Errors; StringBuilder bld = new StringBuilder(); Exception inner = e.InnerException; if (null != inner) { MessageBox.Show("Inner Exception: " + inner.ToString()); } foreach (SqlCeError err in errorCollection) { bld.Append("\n Error Code: " + err.HResult.ToString("X", CultureInfo.CurrentCulture)); bld.Append("\n Message : " + err.Message); bld.Append("\n Minor Err.: " + err.NativeError); bld.Append("\n Source : " + err.Source); foreach (int numPar in err.NumericErrorParameters) { if (0 != numPar) { bld.Append("\n Num. Par. : " + numPar); } } foreach (string errPar in err.ErrorParameters) { if (errPar.Length > 0) { bld.Append("\n Err. Par. : " + errPar); } } MessageBox.Show(bld.ToString()); bld.Remove(0, bld.Length); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }