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 )
{
MySqlCommand cmd;
string query = String.Empty;
mySqlConnection.Open ( );
query = "INSERT INTO SignalDetails ( Action, " +
"Object, " +
"Buyat, " +
"TP1, " +
"TP2, " +
"SL, " +
"isActive ) " +
"VALUES ( @Action, " +
"@Object, " +
"@Buyat, " +
"@TP1, " +
"@TP2, " +
"@SL, " +
"@isActive)";
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 )
{
DisplayAlert ( "Error", ex.Message, "ok" );
throw ex;
}
}
What I have tried:
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