Error - Cannot convert from string to Exception

Ramco Ramco

5y2.6k.NET

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted 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))
Ramco Ramco5y ago
Hi Sachin

I wanted to save this information

var query = from state in ModelState.Values
from error in state.Errors
select error.ErrorMessage;

Thanks
Sachin Singh5y ago
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
}

}