C# Tutorial - Filter records between two dates | FoxLearn

Поділитися
Вставка
  • Опубліковано 24 гру 2024

КОМЕНТАРІ • 42

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

    The text to speech you are using is really very beautiful! Can you bring up a tutorial on how you create these wonderful videos?

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

    Hi, I'm pretty new at coding but this fits what I need perfectly, however when I search for dapper in visual studio, I can only find Dapper Crud Generator, is that the same thing?

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

      You should install dapper from manage nuget packages

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

      @@foxlearn haha told you I was new! I got it now, thanks so much for the fast reply!

  • @zeud7664
    @zeud7664 8 років тому

    very good

  • @satyajeetpawar4806
    @satyajeetpawar4806 2 роки тому

    Sir / Madam If there are two dates in a form then how to search for a single date.
    For example licence registration date & expire date & form register date. How to search record form registration date in a one month.

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

    Can u please suggest me how to do this in access DB based Datagridview

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

      OK. Thank you for your suggestion. I'll upload soon !

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

    How i do it for one table plz send me SQL command fr 1 table because inner join used for 2 tables plz guide

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

      select *from youtable where yourDate between @fromDate and @toDate

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

      Thank you so much👌

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

    how to add rows only column due dates cell value

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

      Not clear your idea

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

      @@foxlearn
      i'm having one calibration excel document which consists of item ,serial no, due date.
      now i want to display only the due items row after comparing with datetimepicker in the datagridview using c#.
      please help

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

    Fox Learn I have an error: " Conversion failed when converting date and/or time from character string."

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

      Please input your date with format correctly dd/mm/yyyy or mm/dd/yyyy base on your datetime computer

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

      @@foxlearn So actually I should input date whic is based on my computer datetime?

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

      @@foxlearn And anyways it's not working

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

    I am trying there is no built error but when i try to load it show incorrent syntanx near 'o'; on last line of code beneath:
    can anyone help: Thanks
    if (db.State == ConnectionState.Closed)
    db.Open();
    string query = "select o.OrderID, c.ContactName, C.Address, c.PostalCode, c.City, c.Phone, o.OrderDate" +
    "from Orders o inner join Customers c on o.CustomerID=c.CustomerID" +
    $" where o.OrderDate between'{dateTimePicker1.Value}' and '{dateTimePicker2.Value}' ";
    ordersBindingSource.DataSource = db.Query(query, commandType: CommandType.Text);

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

      You missing, it should " from Orders o inner join Customers c on o.CustomerID=c.CustomerID", add a backspace

  • @foxmanfox9810
    @foxmanfox9810 8 років тому

    thank you

  • @feravladimirovna1044
    @feravladimirovna1044 8 років тому

    please without music very good thanks

    • @foxlearn
      @foxlearn  8 років тому

      Thank you for your suggestion

  • @AhmedSamir951
    @AhmedSamir951 8 років тому

    very good

    • @foxlearn
      @foxlearn  8 років тому

      Thank you so much :)