Click here to Skip to main content
15,867,308 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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

C#
                    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



SQL
in pzorunlu int,

out zorunlu int

)
BEGIN


 case pzorunlu

 when 0 then

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

 when 1 then 
......................................
Posted
Updated 11-Apr-13 1:26am
v2
Comments
CHill60 11-Apr-13 6:47am    
What is the value of FpSpread1.ActiveSheetView.Cells[j, 6].Value
Member-2338430 11-Apr-13 7:29am    
I found this is the problem fpspread grapecity grid takes value different cell in server side may be not loading procedure correct
Member-2338430 11-Apr-13 7:30am    
this cell takes 0 -1 or 2 but this cell takes firt cell value 11 digits so range out of error givess
Member-2338430 11-Apr-13 7:31am    
but localhost correctly runn really bad situation for me
AmitGajjar 11-Apr-13 8:16am    
check data for cells[j,6]. is there any non number data in that column ?

1 solution

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.
 
Share this answer
 
v2
Comments
AmitGajjar 11-Apr-13 8:15am    
why you have posted two different solution even you can post your answer in single one or your can improve your solution.
Shobhana.n 11-Apr-13 9:17am    
I have submited once but Some error has been occured.And Given msg that failed to submit ans.So again I typed on same text box and submitted once again.And without checking I closed the window.bcoz of that it posted 2 times.But now I corrected.Now you got your ans.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900