Android

public void InsertUser()
{

    try
    {
        string dbstring = @"data source=xxx.xx.xx.xx,1433;initial catalog=MyDatabase;user id=XamarinUser;password=myPassword;Connect Timeout=10";
        SqlConnection Con = new SqlConnection(dbstring);
        if (Con.State == ConnectionState.Open) { Con.Close(); }
        Con.Open();
        SqlCommand cmd = new SqlCommand("INSERT INTO tblUSERS (Username, Password, Email, Active)  VALUES ('" + txtUserName.Text + "','" + password1.Text + "','" + txtEmail.Text + "',0);", Con);
        cmd.ExecuteNonQuery();
        Con.Close();
        Con = null;
        cmd = null;
        this.Dismiss();
    }
    catch (Exception)
    {

        throw new Exception("Application run into errors. Please contact us.");

    }

}

Hello my dear friends .  How can I get the geographic coordinates in which I am offline? Thank you for your reply.

hi !

I have a small win32 (18k) app that i developed years ago for my electronic hobby project. Basically, it takes the text from the screen or from a file, stores it internally in arrays and writes at regular time intervals data packets to the COM1 port(as a file). On windows and linux(using wine) on my PC i used a virtual COM port and installed a driver for a rs232 to usb adapter(ft232 chipset). I want the same on android. The win32 app was written in C, the only language i know, and i would like to port the app "as is"(no code rewriting) to android, because i have no clue of android programming at all. The search on the internet returned no results - i didn't find any solution. Is the following way possible :

General : Installing a minimal linux distro on android with usb acces/ Installing FT232 driver in the terminal

1.compiling the code for arm(32) linux/ Run it in the terminal
Or

2. Port the exe to windows rt/arm / Run the .exe with wine in the terminal ?

The linux distros in the android app(userland, andronix) are bare-bone ones and do not seem to provide usb support( when i run lsusb i get -99 code error) I've also installed visual studio 2019 (win 10 SDK) and cannot build my project because .h files are not found, even if i change the path in the project properties. If i enter the complete path in my code file they are found, but then i still have 200 error messages because things like Bool, Handle, are not defined. The original/initial application i build 10 years ago was generated by CodeBlocks on my old PC which i dont have anymore(broken,but i still have all original project files).
The project files can be found here (link temporary available for your analisys and answers): https://drive.google.com/file/d/1DTcnfRDubXJN12wzhC8KzvhW97AQn1uA/view?usp=drivesdk

Thanks.

Hello everyone.
I’ve decided to program Android in IntelliJ IDEA 2018.3 using Kotlin.
When I determine the SDK path and create the Android project, I face the "MyProject sync faild" message. Furthermore I am using JDK 8.
The errors shown to me are:

Could not find com.android.tools.build:gradle:3.1.0.
Searched in the following locations: https://dl.google.com/dl/android/maven2/com/android/tools/build/gradle/3.1.0/gradle-3.1.0.pom
https://dl.google.com/dl/android/maven2/com/android/tools/build/gradle/3.1.0/gradle-3.1.0.jar
https://jcenter.bintray.com/com/android/tools/build/gradle/3.1.0/gradle-3.1.0.pom
https://jcenter.bintray.com/com/android/tools/build/gradle/3.1.0/gradle-3.1.0.jar
Required by:
project :
Add Google Maven repository and sync project
Open File

Please help me.
Thank you.

 Hey,I want a text box that take value from other device via Bluetooth. For example,
when a person ,measures blood glucose level from a Bluetooth embedded device(Glucometer), the value should appear on that text box of android app.<pre>

public async void SendStatisticsToEmail(string subject, string address, int port, string from, string to, bool useSSL, bool saveDateSent = false, string username = "", string password = "", bool sendNowButtonUsed = false)
        {
            var fileName = System.IO.Path.Combine(
                GetString(Resource.String.Statistics_ExportAllExportPrefix,
                firstResult.ToString("MM-dd-yyyy"),
                DateTime.Today.ToString("MM-dd-yyyy")));

            var message = new MimeMessage();
            message.From.Add(new MailboxAddress(from));
            message.To.Add(new MailboxAddress(to));
            message.Subject = subject + " " + fileName;

            var statistics = new Statistics();
            var reportsForXML = statistics.ConvertRecordsForExport(MyData);
            MemoryStream stream = new MemoryStream();

            var builder = new BodyBuilder();
            var image = BitmapFactory.DecodeResource(Resources, Resource.Drawable.get_started);
            byte[] imgbyte;
            using (var bitmap = image)
            {
                var streamByte = new MemoryStream();
                bitmap.Compress(Bitmap.CompressFormat.Png, 100, streamByte);
                bitmap.Recycle();
                imgbyte = streamByte.ToArray();
            }
            var imageAttach = builder.LinkedResources.Add(@"get_started.png", imgbyte);
            imageAttach.ContentId = MimeUtils.GenerateMessageId();
            builder.HtmlBody = string.Format(@"<p align=""center""><center><img height=""150"" width=""328"" src=""cid:{0}""></center></p><p align=""center"">{1}</p><p align=""center"">{2}</p><p align=""center"">{3}</p>", new object[] { imageAttach.ContentId, GetString(Resource.String.EmailExportSettings_MessageBodyLine1), GetString(Resource.String.EmailExportSettings_MessageBodyLine2), GetString(Resource.String.EmailExportSettings_MessageBodyLine3) });

            using (System.IO.StreamWriter writer = new System.IO.StreamWriter(stream))
            {
                reportsForXML.WriteXml(writer, XmlWriteMode.WriteSchema, false);
                stream.Position = 0;
                builder.Attachments.Add(fileName, stream);
            }
            message.Body = builder.ToMessageBody();

            try
            {
                using (var client = new SmtpClient())
                {
                    // For demo-purposes, accept all SSL certificates (in case the server supports STARTTLS)
                    client.ServerCertificateValidationCallback = (s, c, h, e) => true;

                    if (useSSL)
                        await client.ConnectAsync(address, port, SecureSocketOptions.SslOnConnect);
                    else
                        await client.ConnectAsync(address, port, false);

                    // Note: only needed if the SMTP server requires authentication
                    if (!string.IsNullOrEmpty(username) && !string.IsNullOrEmpty(password))
                        client.Authenticate(username, password);

                    await client.SendAsync(message);
                    await client.DisconnectAsync(true);
                    if (saveDateSent)
                    {
                        Preferences.Set(Settings.ExportToEmailLastEmailSentKey, DateTime.Now);
                        ScheduleNextEmailForSend(DateTime.Now,
                            Preferences.Get(Settings.ExportToEmailEmailFrequencyPositionKey, Settings.ExportToEmailEmailFrequencyPositionDefault)
                            );
                    }
                    if (sendNowButtonUsed)
                        Toast.MakeText(this, GetString(Resource.String.Statistics_EmailSendSuccess), ToastLength.Long).Show();
                }
            }
            catch //(Exception exception)
            {
                if (sendNowButtonUsed)
                    Toast.MakeText(this, GetString(Resource.String.Statistics_EmailSendFailure), ToastLength.Long).Show();
            }
        }



private async void SendStatisticsToEmailBySchedule()
        {
            do
            {
                if (MyData.Count != 0)
                {
                    var currentConnectivity = Connectivity.NetworkAccess;
                    NextScheduledDateForReport = Preferences.Get(Settings.ExportToEmailNextEmailForKey, CurrentDateSettings.ExportToEmailNextEmailForDefault);

                    if (DateTime.Now > NextScheduledDateForReport)
                    {
                        if (currentConnectivity == NetworkAccess.Internet)
                        {
                            try
                            {
                                SendStatisticsToEmail(Preferences.Get(Settings.ExportToEmailSubjectKey, Settings.ExportToEmailSubjectDefault),
                                    Preferences.Get(Settings.ExportToEmailServerAddressKey, Settings.ExportToEmailServerAddressDefault),
                                    Preferences.Get(Settings.ExportToEmailPortKey, Settings.ExportToEmailPortDefault),
                                    Preferences.Get(Settings.ExportToEmailFromKey, Settings.ExportToEmailFromDefault),
                                    Preferences.Get(Settings.ExportToEmailToKey, Settings.ExportToEmailToDefault),
                                    Preferences.Get(Settings.ExportToEmailUseSSLKey, Settings.ExportToEmailUseSSLDefault),
                                    true,
                                    Preferences.Get(Settings.ExportToEmailUsernameKey, Settings.ExportToEmailUsernameDefault),
                                    Preferences.Get(Settings.ExportToEmailPasswordKey, Settings.ExportToEmailPasswordDefault)
                                );
                            }
                            catch
                            {

                            }
                        }
                    }
                }
                await Task.Delay(21600);
            } while (true);
        }



 private void ScheduleNextEmailForSend(DateTime nextScheduledEmailDate, int frequency)
    {
        nextScheduledEmailDate = DateTime.Now;
        frequency = Preferences.Get(Settings.ExportToEmailEmailFrequencyPositionKey, Settings.ExportToEmailEmailFrequencyPositionDefault);
        switch (frequency)
        {

            case 0:
                Preferences.Set(Settings.ExportToEmailNextEmailForKey, nextScheduledEmailDate.AddDays(1));
                break;
            case 1:
                Preferences.Set(Settings.ExportToEmailNextEmailForKey, nextScheduledEmailDate.AddDays(7));
                break;
            case 2:
                Preferences.Set(Settings.ExportToEmailNextEmailForKey, nextScheduledEmailDate.AddDays(30));
                break;
        }
    }

Please I just created an admob app but after installing it on my phone it keeps showing unfortunately, app has stopped when I try opening the app