当查询在程序中触发时，Mysql在语句之间给出错误。 [英] Mysql gives error in between statement when query firing in program.

问题描述

我最近得到了非常不同的错误。我写了一个查询，当从mysql工作台执行时，它成功执行并显示结果，但是当从c＃代码执行相同的查询时它给出了错误？

我的查询有什么问题请告诉我在哪里问题？



这是我的代码和查询声明，

I recently got very different error. that I wrote a query which when execute from mysql workbench it executes successfully and showing result as required but when same query executing from c# code it is giving error?
whats wrong with my query please tell me where is the problem ?

here is my code and query statement,

string query = "SELECT DISTINCT indent_no as 'Indent No'," +
                " approved_date as 'Approved Date'," +
                " from_store_name as 'From Store'," +
                " to_store_name as 'To Store'," +
                " indent_status as 'Indent Status'," +
                " processing_status as 'Processing Status'" +
                " FROM vw_DSInfo_indent_details" +
                " WHERE indent_status like 'Approved'" +
                " AND processing_status Not like 'Fully Processed'" +
                " AND from_store_name = @fmstore" +
                " AND to_store_name = @tostore" +
                " AND approved_date between @from and @to;"; 
                         
cmd = new MySqlCommand();
cmd.CommandText = query;
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
cmd.Parameters.Add(new MySqlParameter("from", datetimefrm));
cmd.Parameters.Add(new MySqlParameter("to", datetimeto));
cmd.Parameters.Add(new MySqlParameter("fmstore", txtfromstore.SelectedItem));
cmd.Parameters.Add(new MySqlParameter("tostore", txttostore.SelectedItem));
table = new DataTable();
adapter = new MySqlDataAdapter(cmd);
adapter.Fill(table);
int c = table.Rows.Count;
}

:

如果我在没有此行的情况下执行则以粗体显示错误显示结果，但是这一行没有给出任何结果。

edited::
error at bold line if i execute without this line then shows result but with this line not gives any result.

推荐答案

以这种方式试试（注意你的cmd.Parameters.Add（...）行的mods）

try it this way (note my mods to your cmd.Parameters.Add(...) lines)

cmd.Parameters.Add(new MySqlParameter("@from", datetimefrm));
cmd.Parameters.Add(new MySqlParameter("@to", datetimeto));
cmd.Parameters.Add(new MySqlParameter("@fmstore", txtfromstore.SelectedItem));
cmd.Parameters.Add(new MySqlParameter("@tostore", txttostore.SelectedItem));

这篇关于当查询在程序中触发时，Mysql在语句之间给出错误。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！