mysql - 由于 vbcrlf 尝试插入 Mysql 数据库 ex.tostring 时出错

Question

我写了这段代码:

Try
    Uff_IdW = Me.DataGridView1.Item(DgvCol, IdWInsDB).Value.ToString.Trim().Split("_")
    If Uff_IdW.Length = 2 Then SplitOk = True Else SplitOk = False
Catch ex As Exception
    mErr = "split error: " & ex.ToString
    SQLStr = "INSERT INTO errlog (Sect, ErrDescr) VALUES ('GP', '" & Errore & "')"
    InsertDBase(cnString, SQLStr)
    SplitOk = False
End Try

但是由于 ex.tostring 中存在“vbcrlf”，因此插入查询不起作用。

代码生成的查询字符串如下所示:

"INSERT INTO errlog (Sect, ErrDescr) VALUES ('GP', 'split error: System.NullReferenceException: Object reference not set to an instance of an object." & vbCrLf & "   in Test_GP.Form1.FirstOption_DGV_Click(Int32 DgvRow, Int32 DgvCol)')"

如何修复此问题并将 ex.tostring 插入到我的数据库中而不出现错误？

Answer 1

在字符串上使用Replace函数去掉回车符:

SQLStr = "INSERT INTO errlog (Sect, ErrDescr) VALUES ('GP', '" & Errore & "')"
SQLStr = SQLStr.Replace(Environment.NewLine, " ")
InsertDBase(cnString, SQLStr)