User Profile

Collapse

Profile Sidebar

Collapse
chanlichin
chanlichin
Last Activity: Nov 2 '09, 12:17 PM
Joined: Aug 3 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • chanlichin
    started a topic Data type mismatch in criteria expression.
    in Visual Basic .NET

    Data type mismatch in criteria expression.

    Code:
    Select Case (cbMonth.Text)
            Case "January"

                Dates = "1"

            Case "February"

                Dates = "2"

            Case "March"

                Dates = "3"

            Case "April"

                Dates = "4"
    ...
    See more | Go to post
    • chanlichin
      replied to How to retrives only years from date time picker
      in .NET
      Display in Combo box

      I am using Ms Access. My field name(dates),dat a type(date/time) in the format mm/d/yyyy
      So i just want retrieve only year from database without duplicate the year. So i have the problem in writting sql statement
      .
      See more | Go to post

        Leave a comment:

      • chanlichin
        started a topic How to retrives only years from date time picker
        in .NET

        How to retrives only years from date time picker

        Hi, I am now want to retrieve only year from my table(summary), field name(dates). So i am facing the problem on how to display the year in combo Box. my sql statement as below. Thanks

        If i put SELECT DATES, that means day,month and year will display. So, what should i put after SELECT.
        Code:
        con.Open()

            sql = "SELECT dates FROM summary WHERE plants = '" & yieldsummary.cbPlant.Text & "'"
        ...
        See more | Go to post
        • chanlichin
          started a topic i want to retrieved data from MS Access into combo box
          in Visual Basic .NET

          i want to retrieved data from MS Access into combo box

          Can any one help me, thanks.My problem is retrieved data from database but when i run the coding, the combo box do not display anything.The below is my coding:

          Code:
          Dim conn As New OleDb.OleDbConnection
        Dim ds1 As New DataSet
        Dim da1 As OleDb.OleDbDataAdapter
        Dim sql1 As String

        Dim maxrow3 As Integer
        Dim x3 As Integer

        Try
          ...
          See more | Go to post
          Last edited by tlhintoq; Aug 3 '09, 05:50 PM. Reason: [CODE] ...your code goes here... [/CODE] tags added
          No activity results to display
          Show More
          Working...