Muthu vj

Muthu vj

  • 1.2k
  • 162
  • 9.3k

Packet received out-of-order. Expected 1; got 2.'

Apr 25 2021 4:01 AM
private async void SectionASubmit_Clicked(object sender, EventArgs e)
{
try
{
SignalDetails deserialized = new SignalDetails();
MySqlConnection mySqlConnection = new MySqlConnection("Server=sql6.freesqldatabase.com;Port=3306;database=sql6407915;User Id=sql6407915;Password=Telliant@123;charset=utf8");
if (mySqlConnection.State == ConnectionState.Closed)
{
mySqlConnection.Open();
string query = "INSERT INTO SignalDetails(Action,Object,Buyat,TP1,TP2,SL,isActive) VALUES(@Action,@Object,@Buyat,@TP1,@TP2,@SL,@isActive)";
MySqlCommand cmd = new MySqlCommand(query, mySqlConnection);
cmd.Parameters.AddWithValue("@ticker", deserialized.Action);
cmd.Parameters.AddWithValue("@bid", deserialized.Object);
cmd.Parameters.AddWithValue("@ask", deserialized.Buyat);
cmd.Parameters.AddWithValue("@open", deserialized.TP1);
cmd.Parameters.AddWithValue("@low", deserialized.TP2);
cmd.Parameters.AddWithValue("@high", deserialized.SL);
cmd.Parameters.AddWithValue("@isActive","true");
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
cmd.Connection.Close();
}
DisplayAlert("Success", "Signal Send Successfully", "ok");
await Navigation.PushAsync(new ItemsPage());
}
catch(Exception ex)
{
throw ex;
DisplayAlert("Error", ex.Message, "ok");
}
}
 
 
 
i am using this code for save the details first time its hitting correctly but second time i am getting  Packet received out-of-order. Expected 1; got 2.' this Error can you please help me on this.. i tried but didn't get answer for this

Answers (1)