How to connect Xamarin.Android to SQL Server

Ahsan_SiddiqueAhsan_Siddique PKMember ✭✭✭✭

I want to add and get data from SQL Server using Xamarin Android. Please i need complete producer of connecting SQL Server with Xamarin Android.

Best Answers

Answers

  • Ali_LashariAli_Lashari USMember ✭✭

    Use Web Service/Web Api to Connect Android Device To Sql Server.....E.g Asp.Net Web Service

  • Ahsan_SiddiqueAhsan_Siddique PKMember ✭✭✭✭

    If i want to connect my local SQL Server.?

  • Ali_LashariAli_Lashari USMember ✭✭

    Yes u can Also Connect with Local Server ...I have Tested It n Working fine .I Tested two Methods through web api and direct connect with sql server.But Second Method is Not Highly Recommended Because It Contain Security Risks .But Working Although

  • Ahsan_SiddiqueAhsan_Siddique PKMember ✭✭✭✭

    Can you share with me your code??

  • Ahsan_SiddiqueAhsan_Siddique PKMember ✭✭✭✭

    Test Phase - Problem Statement
    You are required to develop a user feedback and feedback retrieval module for android application.
    In this Task, you are required to make two interfaces:
    1. User Feedback Form
    2. Feedback Retrieval

    1. User Feedback Form
      In user feedback form there must be three text boxes for email, subject and message. A send button should also be available in this interface.
      After user fills feedback form and clicks send button this information should be stored in database. After successful data entry, message should be displayed “Your feedback is saved”.
      The sample android user feedback interface is given below:

    2. Feedback Retrieval
      In this interface a text box labeled as “your email here!”, and a button with label “Show my last Feedback” is required. After a user enters email address in text box and click the “Show my last Feedback” button, the last message and subject, related to given email ID should be displayed. If there is no message found for given email ID then message should be displayed “No message found”.
      The sample android user feedback retrieval interface is given below:

    Tools & Technologies:
    For interface design: Android Studio\ Eclipse
    For Database: MY SQL\SQL Server etc.
    For Server Side Scripting: PHP\ASP\ASP.net etc.

  • Ali_LashariAli_Lashari USMember ✭✭

    I can help u with Connecting to Sql In Both Methods But Not Share Any Code .Do Some Gooogling n Then when u Stuck in Something I can Help U ......:)

  • Ahsan_SiddiqueAhsan_Siddique PKMember ✭✭✭✭
    Accepted Answer

    I have done with Azure SQL Database and its working fine.

  • Ali_LashariAli_Lashari USMember ✭✭

    Ok Goood

  • Dear Team,
    How to Connect to a SQL Server Database in Local Area Connection from Xamarin Android , where the Android device will connect to the Network via Wifi , can anyone suggest the possible way.
    Thanks & Regards,
    Balaji Dharani

  • Ahsan_SiddiqueAhsan_Siddique PKMember ✭✭✭✭
    Accepted Answer

    @balajiid78 said:
    Dear Team,
    How to Connect to a SQL Server Database in Local Area Connection from Xamarin Android , where the Android device will connect to the Network via Wifi , can anyone suggest the possible way.
    Thanks & Regards,
    Balaji Dharani

    Developing RESTful API in ASP.Net With Azure Database.

    Part 1
    https://c-sharpcorner.com/article/creating-sql-database-in-azure-portal/

    part 2
    https://c-sharpcorner.com/article/developing-restful-api-in-asp-net-with-add-method/

    Part 3
    https://c-sharpcorner.com/article/developing-restful-apis-in-asp-net-with-retrieve-update-and-delete-functions/

    Consuming RESTful API in Xamarin.Android

    part 4
    https://c-sharpcorner.com/article/consuming-restful-apis-in-xamarin-android/

Sign In or Register to comment.