Error - Cannot convert from string to Exception

Question

Hi

I am getting error - Cannot convert from string[] to System.Exception

var errors = query.ToArray();
ExceptionLogging.SendExcepToDB(errors);

public static void SendExcepToDB(Exception exdb)
{
connecttion();
exepurl = HttpContext.Current.Request.Url.ToString();
SqlCommand com = new SqlCommand("ExceptionLoggingToDataBase", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@ExceptionMsg", exdb.Message.ToString());
com.Parameters.AddWithValue("@ExceptionType", exdb.GetType().Name.ToString());
com.Parameters.AddWithValue("@ExceptionURL", exepurl);
com.Parameters.AddWithValue("@ExceptionSource", exdb.StackTrace.ToString());
com.ExecuteNonQuery();
}

Thanks

Sachin Singh · Answer

If you just want to store the ModelState.The message, then it is a string[], so change the method as public static void SendExcepToDB(string[] errors) { using (SqlConnection con= new SqlConnection( "your connection string" )) { foreach(string error in errors) { SqlCommand com = new SqlCommand( "insert into table values(@error)" , con); com.Parameters.AddWithValue( "@error" , error); com.ExecuteNonQuery(); } } } Note:- you need a table with just two columns Id(Identity)and error(varchar(MAX))

Sachin Singh · Answer

Exception in your method is a special .Net class (Exception) that keeps all information regarding exception, so just pass the exception to that method and do nothing as shown below. public ActionResult Insert() { try { // Save to DB } catch (Exception ex) { ExceptionLogging.SendExcepToDB( ex ); // notice here } }

Ramco Ramco · Answer

Hi Sachin I wanted to save this information var query = from state in ModelState.Values from error in state.Errors select error.ErrorMessage; Thanks