here attached code
Ccmd22.CommandText = "call prc_DistChallan ( 1 ," + Session["distributorid"].ToString() + ",'" + pubid + "'," + '"' + bookid + '"' + ",'" + queryval + "' ,'" + pubqry + "'," + quantity + ") ";
Ccmd22.ExecuteNonQuery();
when excuting
Ccmd22.CommandText = "call prc_DistChallan ( 1 ," + Session["distributorid"].ToString() + ",'" + pubid + "'," + ) ";
Ccmd22.ExecuteNonQuery(); here is my connection terminated automatically.
but when killing sleep process in mysql it work .
thanks.