为什么mysql程序给我一个错误？ [英] why mysql procedure gives me an error?

问题描述

我的项目在localhost运行良好



但我发送服务器的程序给了我这个错误我不明白

 MySql.Data.MySqlClient.MySqlException：第1行konum栏中列''pzorunlu''的超出范围值：MySql.Data.MySqlClient.MySqlStream.OpenPacket （）konum：MySql.Data.MySqlClient.NativeDriver.ReadResult（UInt64& affectedRows，Int64& lastInsertId）konum：MySql.Data.MySqlClient.MySqlDataReader.GetResultSet（）konum：MySql.Data.MySqlClient.MySqlDataReader.NextResult（）konum： MySql.Data.MySqlClient.MySqlCommand.ExecuteReader（CommandBehavior behavior）konum：MySql.Data.MySqlClient.MySqlCommand.ExecuteReader（）konum：MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery（）konum：ekderswebapp.usercontrols.ders_prog_kayit_kismi.Button2_Click1（Object发件人，EventArgs e）< br /> 

这是我的代码边

 MySqlConnection conn =  new  MySqlConnection（xxxx.connStr）; 
 MySqlCommand cmd =  new  MySqlCommand（  update_ders ，conn）; 
 cmd.CommandType = System.Data.CommandType.StoredProcedure; 
 
 cmd.Parameters.Add（  @ pzorunlu，MySqlDbType。< span class =code-sdkkeyword> Int32 ）。Value = FpSpread1.ActiveSheetView.Cells [j， 6 ]。值; 

这是程序pzorunlu整数值





< pzorunlu int ，

out zorunlu int

）
BEGIN


case pzorunlu

何时 0 然后

........... ...........................

时 1 然后
........ ..............................

解决方案

交叉验证服务器和localhost上DB表和sp变量的数据类型长度。可能是服务器数据库和本地数据库的数据类型不同。

my project run good in localhost

but I sended server iss procedure gives me this error I dont understand

MySql.Data.MySqlClient.MySqlException: Out of range value for column ''pzorunlu'' at row 1 konum: MySql.Data.MySqlClient.MySqlStream.OpenPacket() konum: MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) konum: MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() konum: MySql.Data.MySqlClient.MySqlDataReader.NextResult() konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteReader() konum: MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() konum: ekderswebapp.usercontrols.ders_prog_kayit_kismi.Button2_Click1(Object sender, EventArgs e)<br />

this is my codeside

                    MySqlConnection conn = new MySqlConnection(xxxx.connStr);
                    MySqlCommand cmd = new MySqlCommand("update_ders", conn);
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;
                    
cmd.Parameters.Add("@pzorunlu", MySqlDbType.Int32).Value = FpSpread1.ActiveSheetView.Cells[j, 6].Value;

this is the procedure pzorunlu integer value

in pzorunlu int,

out zorunlu int

)
BEGIN


 case pzorunlu

 when 0 then

    ......................................

 when 1 then 
......................................

解决方案

Cross verify datatypes length of DB table''s and sp variables on server and localhost.May be there is difference in datatypes of server database and local database.

这篇关于为什么mysql程序给我一个错误？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！