更新查询问题asp.net C＃和使用ODBC的Mysql [英] Update Query problem in asp.net c# and Mysql using odbc

问题描述

当我在更新查询指定值查询工作正常和数据库得到更新，但是当我在查询中使用参数数据库没有更新

when i specify values in my update query the query works fine and the database gets updated, but when i use parameters in my query the database does not update

这里是code我写

try
        {
            OdbcConnection MyConnection = new OdbcConnection(ConfigurationManager.ConnectionStrings["myconn"].ConnectionString);

MyConnection.Open();
            String MyString = "UPDATE orddetpabak SET jud1=@jud1,jud2=@jud2,jud3=@jud3,adv=@adv where fil_no=@fil_no AND orderdate=@orderdate";
            OdbcCommand MyCmd = new OdbcCommand(MyString, MyConnection);
            String j1=DropDownList4.SelectedValue;
            String j2=DropDownList5.SelectedValue;
            String j3=DropDownList6.SelectedValue;
            String j4=TextBox4.Text;
            String j5 = HiddenField1.Value;
            String j6 = TextBox3.Text;

            MyCmd.Parameters.AddWithValue("@jud1",j1);
            MyCmd.Parameters.AddWithValue("@jud2",j2);
            MyCmd.Parameters.AddWithValue("@jud3",j3);
            MyCmd.Parameters.AddWithValue("@adv",j4);
            MyCmd.Parameters.AddWithValue("@fil_no",j5);
            MyCmd.Parameters.AddWithValue("@orderdate",j6);

            Response.Write(DropDownList4.SelectedValue);
            Response.Write("    " + DropDownList5.SelectedValue);
            Response.Write("    " + DropDownList6.SelectedValue);
            Response.Write("    " + TextBox4.Text);
            Response.Write("    " + HiddenField1.Value);
            Response.Write("    " + TextBox3.Text);


            MyCmd.ExecuteNonQuery();
            //MyConnection.Close();
        }
        catch(Exception epp)
        {
            Response.Write(epp);
        }

请帮助

推荐答案

据我知道你不能在MySQL中使用命名参数。如果你改变你的字符串为

As far as I know you cannot use named parameters in MySQL. If you change your string to be

String MyString = "UPDATE orddetpabak SET jud1=?,jud2=?,jud3=?,adv=? 
where fil_no=? AND orderdate=?";

和您的参数为：

MyCmd.Parameters.AddWithValue("",j1);
MyCmd.Parameters.AddWithValue("",j2);
MyCmd.Parameters.AddWithValue("",j3);
MyCmd.Parameters.AddWithValue("",j4);
MyCmd.Parameters.AddWithValue("",j5);
MyCmd.Parameters.AddWithValue("",j6);

希望这有助于。

这篇关于更新查询问题asp.net C＃和使用ODBC的Mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！