Read,Update & Delete in SQLite - Xamarin Forms in Hindi

Поділитися
Вставка
  • Опубліковано 17 січ 2025

КОМЕНТАРІ • 88

  • @prathapkarthick
    @prathapkarthick 4 роки тому

    Awesome basics coverage brother.. Following all your basis videos one by one. Got by basics very clear and simple approach. cheers.. thank you

  • @Husdajukies
    @Husdajukies 3 роки тому

    thank you for sharing your knowledge with us

  • @chandrasekharpatra6317
    @chandrasekharpatra6317 3 роки тому

    Plz suggest how to encrypt sqlite db in xamarin forms

  • @rainiertimbol9031
    @rainiertimbol9031 3 роки тому

    How do you show delete from menu? It doesn’t appear on mine.

  • @DheerajBarad
    @DheerajBarad 4 роки тому

    Have a problem with this line private void PopulateDetails(Receipts details)
    txtEntry.Date = details.Date;
    i took Datepicker in place of name will updating its
    giving an error: System.NullReferenceException: 'Object reference not set to an instance of an object.'

    • @SPTutorials
      @SPTutorials  4 роки тому

      Your data is getting null,thatvis the reason you are getting this error.always check null before setting value.

  • @alkabhatnagar9473
    @alkabhatnagar9473 4 роки тому

    nice Lecture..Can You Pls. Tell how can we change background colour of selected item in listview.

    • @SPTutorials
      @SPTutorials  4 роки тому +1

      See the video of MasterMenu from my playlist,this already have custom viewcell with specified background color

  • @varunSharma-ew4pq
    @varunSharma-ew4pq 5 років тому

    Main page add employee button click code not explained

  • @prathapkarthick
    @prathapkarthick 4 роки тому

    I have a issue in navigating between pages. I am getting the following exception. Do you have any better solution for it? Not sure if any had already posted this error.
    System.InvalidOperationException: 'PushAsync is not supported globally on Android, please use a NavigationPage.'

    • @SPTutorials
      @SPTutorials  4 роки тому +1

      Its a basics things.When your application have multiple pages,and while you are using Navigation.PushAsync for navigating a page to another,then have to use Navigation stack.
      Simply add this line to your App.xaml.cs after InitializeComponent().
      MainPage = new NavigationPage(new YourRootPage());

    • @prathapkarthick
      @prathapkarthick 4 роки тому +1

      @@SPTutorials Thank you brother, that works. All your videos are very useful for a beginner.

  • @saadsalam
    @saadsalam 6 років тому

    Very good and thank you sir. Please post videos on connecting and posting data through API.

  • @pardeepahlawat5983
    @pardeepahlawat5983 6 років тому

    Sir, Xamarin Forms Tutorial no 34 and 42 is not available. Is it missing from list?

    • @SPTutorials
      @SPTutorials  6 років тому

      Dear,I removed that Videos for few reasons.

    • @pardeepahlawat5983
      @pardeepahlawat5983 6 років тому

      @@SPTutorials What we missed in that, are you providing that topics again.

  • @SaqibAli-do7yg
    @SaqibAli-do7yg 2 роки тому

    When i made apk then application crash whats the reason

    • @SPTutorials
      @SPTutorials  2 роки тому +1

      Implement app centre so that you will get release logs

    • @SaqibAli-do7yg
      @SaqibAli-do7yg 2 роки тому

      @@SPTutorials Thanks you sir.Now its work fine.

  • @MRC0MM1T
    @MRC0MM1T 4 роки тому

    Why didn't you code from scratch with us instead of showing a code (showing only some parts) we don't understand ?

  • @طالبالدعاء-ط9ق
    @طالبالدعاء-ط9ق 6 років тому

    Good morning brother
    I hope you are good
    Sorry for my bad english
    I want to ask .. do you have an english version of your xamarin form teaching ?
    Best regard

  • @acv7698
    @acv7698 5 років тому

    Hi, Can i suggest you to make a project that can search peoples in database.

  • @multi-topic4743
    @multi-topic4743 5 років тому

    hi sir how to find the db file ?? i want to extract that database thank you

    • @SPTutorials
      @SPTutorials  5 років тому

      you will find your solution here.
      forums.xamarin.com/discussion/comment/14745#Comment_14745

  • @buntykumar-ey3ii
    @buntykumar-ey3ii 4 роки тому

    Sir, In Insert data video you are using Homepage.xaml for designing now in Read,Update and Delelte you are using AddEmployeePage.xaml. It's looking confusing for beginners.

    • @SPTutorials
      @SPTutorials  4 роки тому

      Dear,if you are a beginner then you can join my xamarin training,so that you can learn xamarin easily and quickly to be a professional.To learn more about training contact whatsapp +918444835044

  • @acv7698
    @acv7698 5 років тому

    Hi,
    im having a problem with this line.
    public List GetEmployees()
    {
    string sql = "SELECT * FROM Employee";
    List employees = con.Query(sql);
    return employees;
    }
    thanks

    • @SPTutorials
      @SPTutorials  5 років тому

      what is the exception?

    • @acv7698
      @acv7698 5 років тому

      @@SPTutorials
      Unhandled Exception:
      System.NullReferenceException:

    • @SPTutorials
      @SPTutorials  5 років тому

      @@acv7698 put that codes inside try catch block and see what is the proper exception.

    • @acv7698
      @acv7698 5 років тому

      @@SPTutorials
      Severity Code Description Project File Line Suppression State
      Warning IDE0006 Error encountered while loading the project. Some project features, such as full solution analysis for the failed project and projects that depend on it, have been disabled. CRUDXamarin.Android 1 Active

    • @SPTutorials
      @SPTutorials  5 років тому

      @@acv7698 try
      {
      // pur your code
      }
      catch(Exception ex)
      {
      string msg=ex.Message;
      }
      set a break point on catch block first curly bracket and mouse over on the "ex" and you see the proper exception
      then tell me.

  • @AMIRKHAN-dm2fm
    @AMIRKHAN-dm2fm 6 років тому

    sir very nice.
    But please datagrid ko use krain. i mean k database say data fetch kr k DataGrid main show krwayen.
    Thanks alot

  • @acv7698
    @acv7698 5 років тому

    Hi Sir,
    I want to ask if, you've tried to make an APK file and run it to a mobile device?. If YES, Are functions all working properly?. In my case only CREATING Employee is working, But DELETING AND UPDATING the Employee are having some error.
    But in the EMULATOR, It's working properly. Kindly advise how to working on this. Thanks :)

  • @youvi3516
    @youvi3516 3 роки тому

    Can we get the source code please

    • @SPTutorials
      @SPTutorials  3 роки тому

      Sorry,it’s not under source control.

  • @patel5resh
    @patel5resh 5 років тому

    pls sir, multi delete record video upload

  • @tariqansr
    @tariqansr 4 роки тому

    public AddEmployeePage(Employee details)
    ... show the code please there is an exception
    AddEmployeePage(Employee details)
    {
    ???????;
    }

  • @Usman_AsgharBT
    @Usman_AsgharBT 5 років тому

    sir i am facing Null reference exception during insert method of SQLite and i am following you videos kindly give solution. thank You!

    • @SPTutorials
      @SPTutorials  5 років тому

      Use it properly,and make sure that you have included the assembly of the sqlite class for ddpendency.

    • @Usman_AsgharBT
      @Usman_AsgharBT 5 років тому

      @@SPTutorials Sir by Debugging i have tested that all values are coming in parameter but not inserting data and showing exception like............ System.NullReferenceException: Object reference not set to an instance of an object.
      at OnDoorStep.Droid.SQLite_Android.SaveAdmin (OnDoorStep.Model.Admins admins) [0x00004] in I:\THSS\ODSWork9\OnDoorStep\OnDoorStep\OnDoorStep.Android\SQLite_Android.cs:65 }

    • @SPTutorials
      @SPTutorials  5 років тому

      can you show me your full code?

    • @Usman_AsgharBT
      @Usman_AsgharBT 5 років тому

      @@SPTutorials Sir, complete file? or just problem page?

    • @Usman_AsgharBT
      @Usman_AsgharBT 5 років тому

      @@SPTutorials Sir, how i can attach my code file? there is no option available here. for file attachment.

  • @ashishgarggarg5379
    @ashishgarggarg5379 4 роки тому

    How to save this json :
    {
    "status": "success",
    "data": {
    "name": "Ashish",
    "salary": "1",
    "age": null,
    "id": 85
    }
    }

  • @rubinakhan7054
    @rubinakhan7054 5 років тому

    i have some problem in reading from a query and storing the result in list of table. Kindly provide me your email id to connect to you . I am a Lecturer in the university and has just 3 days to complete the work. Its really urgent

  • @yusufmohamedsalh8321
    @yusufmohamedsalh8321 5 років тому

    in English !?

  • @acv7698
    @acv7698 5 років тому

    Hi, How can i do search filter/Search data with this project. Can youteach me. I will appreciate. I couldn't solve this problem.
    Thanks

    • @SPTutorials
      @SPTutorials  5 років тому

      you are searching/filtering from where?

    • @acv7698
      @acv7698 5 років тому

      @@SPTutorials I want to filter or search the name and it will show in the listview

    • @SPTutorials
      @SPTutorials  5 років тому +1

      I need to know,where the data is coming from?
      local database/your list variable/from server

    • @acv7698
      @acv7698 5 років тому

      @@SPTutorials in local database. I used your project. And adding some search filter. But i couldnt understand the flow. Can you please add it?

    • @acv7698
      @acv7698 5 років тому

      @@SPTutorials so i have an idea. Thanks