blocks|key|1909850|text|看起来您的插入字符串的格式不正确？参数列表中缺少()。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1909851|commandText="INSERT+INTO+Logs+(Machine_Name,+Username,+Logon_Time,+Screensaver_On,+Screensaver_Off,+Logoff_Time,+Program_Start)+Values+(@MachineName,+@Username,+@LogonTime,+@Screensaver_On,+@Screensaver_Off,+@LogoffTime,+@ProgramStart)+"|code-block|syntax|javascript|1909852|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

It looks your insert string is not in the right format? You are missing () around the parameters list.

<pre><code>commandText="INSERT INTO Logs (Machine_Name, Username, Logon_Time, Screensaver_On, Screensaver_Off, Logoff_Time, Program_Start) Values (@MachineName, @Username, @LogonTime, @Screensaver_On, @Screensaver_Off, @LogoffTime, @ProgramStart) "
</code></pre>

blocks|key|1909858|text|您似乎缺少要插入的参数。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1909859|请参阅http://justinpdavis.blogspot.com/2010/04/logging-to-database-with-nlog.html上的示例|offset|length|1909860|nLog的网页并没有明确指出这些是必需的，但如果你斜眼看https://github.com/nlog/NLog/wiki/Database-target，你会发现它们是必需的。|1909861|entityMap|0|LINK|mutability|MUTABLE|url|http://justinpdavis.blogspot.com/2010/04/logging-to-database-with-nlog.html|1|https://github.com/nlog/NLog/wiki/Database-target^0|0|3|23|0|0|S|1D|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@$D|X|E|Y|1|Z]]|A|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]|P|$5|K|L|M|A|$N|Q]]]]

You seem to be missing the parameters that are to be inserted.

See the examples at <a href="http://justinpdavis.blogspot.com/2010/04/logging-to-database-with-nlog.html">http://justinpdavis.blogspot.com/2010/04/logging-to-database-with-nlog.html</a> 

The nLog web page doesn't make it very clear that these are required, but if you squint your eyes and read <a href="https://github.com/nlog/NLog/wiki/Database-target">https://github.com/nlog/NLog/wiki/Database-target</a> you should find that they are required.

blocks|key|1909867|text|你还写了两个目标。还有很多你不需要设置的属性。应该是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1909868|<target+name="DbLog"+xsi:type="Database"+connectionString="YourConStr"+
++++++++commandText="insert+into+[blablablabal]+(Col1)+values+(@val1)">
++<parameter+name="@val1"+layout="${level}"+/></target>|code-block|syntax|javascript|1909869|就像这样。容易吗？:)|1909870|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

U also wrote 2 targets. And also a lot of attributes that u don't need to set. Should just be:

<pre class="lang-xml prettyprint-override"><code>&lt;target name="DbLog" xsi:type="Database" connectionString="YourConStr" 
 commandText="insert into [blablablabal] (Col1) values (@val1)"&gt;
 &lt;parameter name="@val1" layout="${level}" /&gt;&lt;/target&gt;
</code></pre>

Something like this. Easy no? :)

blocks|key|1696294|text|一个简单的例子，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1696295|配置：|1696296|<target+type="Database"+name="database"+connectionstring="Server=localhost;Database=NLog;Trusted_Connection=True;">
++<commandText>
++++INSERT+INTO+NLogEntries+([Origin],+[Message],+[LogLevel],[CreatedOn],[OrderId])+VALUES+(@Origin,@Message,@LogLevel,@Date,+@OrderId);
++</commandText>
++<parameter+name="@Date"+layout="${date}"+dbType="DbType.Date"/>
++<parameter+name="@Origin"+layout="${callsite}"/>
++<parameter+name="@LogLevel"+layout="${level}"/>
++<parameter+name="@message"+layout="${message}"/>
++<parameter+name="@OrderId"+layout="${event-properties:MyOrderId}"+dbType="DbType.Int32"/>+
</target>|code-block|syntax|javascript|1696297|请注意，NLog+4.6还支持DbType+-请参阅https://nlog-project.org/2019/03/20/nlog-4-6-is-live.html|offset|length|1696298|entityMap|0|LINK|mutability|MUTABLE|url|https://nlog-project.org/2019/03/20/nlog-4-6-is-live.html^0|0|0|0|Q|1L|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@$K|Y|L|Z|1|10]]|A|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

A simple example,

Config:

<pre class="lang-xml prettyprint-override"><code>&lt;target type="Database" name="database" connectionstring="Server=localhost;Database=NLog;Trusted_Connection=True;"&gt;
 &lt;commandText&gt;
 INSERT INTO NLogEntries ([Origin], [Message], [LogLevel],[CreatedOn],[OrderId]) VALUES (@Origin,@Message,@LogLevel,@Date, @OrderId);
 &lt;/commandText&gt;
 &lt;parameter name="@Date" layout="${date}" dbType="DbType.Date"/&gt;
 &lt;parameter name="@Origin" layout="${callsite}"/&gt;
 &lt;parameter name="@LogLevel" layout="${level}"/&gt;
 &lt;parameter name="@message" layout="${message}"/&gt;
 &lt;parameter name="@OrderId" layout="${event-properties:MyOrderId}" dbType="DbType.Int32"/&gt; &lt;!-- custom field! Note also the DB Type. Using Logger.WithProperty --&gt;
&lt;/target&gt;
</code></pre>

Note, NLog 4.6 has also support for DbType - See <a href="https://nlog-project.org/2019/03/20/nlog-4-6-is-live.html" rel="nofollow noreferrer">https://nlog-project.org/2019/03/20/nlog-4-6-is-live.html</a>

I'm trying to get NLog to write to a database, however with my current code it throws an exception when I attempt to debug, the exception is: The type initializer for 'NotifyIcon.Program' threw an exception.

my NLog configuration file code is below, as this seems to be causing the issue as it's the only code I've changed.

<pre class="lang-xml prettyprint-override"><code>&lt;?xml version="1.0" encoding="utf-8" ?&gt;
&lt;nlog xmlns="http://www.nlog-project.org/schemas/NLog.xsd"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" autoReload="true"&gt;

 &lt;!-- 
 See http://nlog-project.org/wiki/Configuration_file 
 for information on customizing logging rules and outputs.
 --&gt;
 &lt;targets&gt;
 &lt;!-- add your targets here --&gt;

 &lt;target name="database" xsi:type="Database" /&gt;
 &lt;target xsi:type="Database"
 name="String"
 dbUserName="Layout"
 dbProvider="sqlserver"
 useTransactions="false"
 connectionStringName="String"
 connectionString="Data Source=AC-02\SQLEXPRESS;Initial Catalog=master;Integrated Security=True"
 keepConnection="true"
 dbDatabase="Layout"
 dbPassword="Layout"
 dbHost="Layout"
 installConnectionString="Layout"
 commandText="INSERT INTO Logs (Machine_Name, Username, Logon_Time, Screensaver_On, Screensaver_Off, Logoff_Time, Program_Start) Values @MachineName, @Username, @LogonTime, @Screensaver_On, @Screensaver_Off, @LogoffTime, @ProgramStart "/&gt;

 &lt;/targets&gt;

 &lt;rules&gt;

 &lt;logger name="*" minlevel="Trace" writeTo="database" /&gt;

 &lt;/rules&gt;
&lt;/nlog&gt;
</code></pre>

any and all help would be greatly appreciated =]

How do I configure NLog to write to a database?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在尝试让NLog写入数据库，但是在我当前的代码中，当我尝试调试时，它抛出了一个异常，异常是：'NotifyIcon.Program‘的类型初始化器抛出了一个异常。我的NLog配置文件代码如下，因为这似乎是导致问题的原因，因为这是我更改的唯一代码。<?xml version="1.0" encoding="utf-8...

问如何配置NLog以写入数据库？
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何配置NLog以写入数据库？EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何配置NLog以写入数据库？
EN