Mysql查询不返回任何内容 [英] Mysql query does not return anything

问题描述

mycnOptionPanel.Open();
                  mycmdOptionPanel = mycnOptionPanel.CreateCommand();
                  mycmdOptionPanel.CommandText = "select Device_ID from DEVICE_INFO where Device_name=@Device_name";
                    mycmdOptionPanel.Parameters.AddWithValue("@Device_name",LabelDeviceName.Text);
           string strDeviceID =Convert.ToString(mycmdOptionPanel.ExecuteScalar());

这是我的查询，但它在strDeviceID中没有返回任何内容，即只在调试时显示strDeviceID =。我正在使用带有asp.net4.0 c＃的Mysql数据库，而我的connetor是

mysql-connector-odbc-5.1.13-win32这个connetor的问题意味着它是否需要其他查询格式？因为在此之前我使用mysql-connector-NET和查询工作。

我想用mysql-connector-odbc连接器做这个。

如果我直接在qurey使用'+ textbox.text +'然后它可以工作，但它允许sqlinjection，

所以plz给出任何解决方案，谢谢。

This is my query but it return nothing in strDeviceID i.e just show strDeviceID="" when debug. I am using Mysql database with asp.net4.0 c#, and my connetor is
mysql-connector-odbc-5.1.13-win32 is this problem of this connetor means is it required other query format ? because before this i used mysql-connector-NET and query works.
I want to do this with mysql-connector-odbc connector.
if i used "'"+textbox.text+"'" directly in qurey then it works but its allow sqlinjection,
so plz give any solution, thank you.

推荐答案

尝试使用

try with

mycnOptionPanel.Open();
mycmdOptionPanel = mycnOptionPanel.CreateCommand();
mycmdOptionPanel.CommandText = "select Device_ID from DEVICE_INFO where Device_name=?";               mycmdOptionPanel.Parameters.AddWithValue("@Device_name",LabelDeviceName.Text);
string strDeviceID =Convert.ToString(mycmdOptionPanel.ExecuteScalar());

这篇关于Mysql查询不返回任何内容的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！