无法生成SQL查询 [英] Unable to generate SQL query

问题描述

我正在使用MySql数据库并想更新数据；并行记录每个查询.为此，我需要跟踪由C#程序准备的Sql命令.我试图通过使用下面的代码来获取Sql Command；但它不起作用.

谢谢&问候
Thahir

Hi,

I am using MySql database and want to update data; parallel to record each and every query. For achieving this I need to track Sql commands those are prepared by C# program. I tried to get Sql Command by using below code; but it is not working.

Thanks & Regards
Thahir

private void UpdateData()
{
preUpdate();
DataTable changes = data.GetChanges();
if (changes != null)
{
MessageBox.Show(da.UpdateCommand.CommandText);
da.Update(changes);
data.AcceptChanges();
}
}

推荐答案

您到底想要什么???我认为您想在执行之前查看查询???如果我没错，请使用debugger 并使用

exactly what do you want??? I think you want to view your query before executing??? If I am right use debugger and use

SQL profiler

..来预览查询..

谢谢

.. for previewing your query..

Thanks

这篇关于无法生成SQL查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！