sql server - vb.net SQL date to time conversion issue -

-

error is:. Conversion failed when changing date and / or time from character string

Actually I'm trying to make it so that when someone clicks on a location in a list box, this figure is correct with 1 in the table. The field increases so that they can click on the location. I'm trying to solve it for a while and can not find anywhere. My date is in date format, and so on my statistics table has a date field. My code can be seen below. String Dim Check String as String ObjCmd2 Object dim as iCount integer dim tDate as current current as dirty current = LocBox.SelectedItem check = LocList.FindString (Current) if check & gt; -1 Then the MsgBox ("you have already selected this place to travel") or else LocList.Items.Add (current) ObjDataReader.Close () tDate = Date.Today MessageBox.Show (tDate) tDate = tDate .toString () objCmd2 = New SqlCommand ("select" & replace (current, "", "_") & "where data from date = to" "& amp; tDate & amp; ObjConn ObjDataReader = objCmd2.ExecuteReader ObjDataReader.HasRows then ObjDataReader.Read () if ObjDataReader (0) is DBNull.Value then iCount = 0 otherwise iCount = ObjDataReader (0) ends if else iCount = 0 end then objCmd = New SqlCommand ("INSERT INTO Statistics (Date," & Change (current, "", "_") & amp; ") value ('' & amp; tDate.Date & amp;" ', & amp; Mp; iCount & amp; "), objConn ObjDataReader.Close (objCmd.ExecuteNonQuery) Thanks in advance objConn.

This issue comes with another SQL statement which I think. I'm not going to have an issue to add a date to a date field, I tried to add it as a string that did not work. Thanks so far for all the answers.

I think this issue is here: Show the message box (TDT)

TDT to you date Using toasting, you need to convert to a string or another method you want.

Are you compiling errors? I always code the option with strict on, and your code will definitely bring errors where you are not changing the variable.

Comments

Post a Comment

Popular posts from this blog

qt - switch/case statement in C++ with a QString type -

-
I want to use switch-case in my program but the compiler generates an error. How can I use the switch statement with QString ? The compiler gives me this error: The expression of the switch type 'QString' is invalid My code is as follows : boolStopWord (the word QString) {bool flag = false; Switch (word) {case "the": flag = true; break ; "On" case: flag = true; break ; Case "in": flag = true; break ; Case "your": flag = true; break ; Case "near": flag = true; break ; Case "all": flag = true; break ; Case "this": flag = true; break ; } Return flag; } How do I use the switch statement with a Caststring ? You can not use the switch statement in C ++ language with integral or enum types. You can formally enter the square type of object in the switch statement, but this means that the compiler will look for a user-defined conversion to convert it to an integral or enum type.
Read more

python - sqlite3.OperationalError: near "REFERENCES": syntax error - foreign key creating -

-
I'm trying to create a predefined key after checking the manual and I wrote it: Db.execute ("create table" Table 2 (id, integer primary key, somedata integer) "db.execute" (table creation table 2 does not exist (name text, maintain reference (id) ") and found this: sqlite 3. Operation error: near" references ": syntax error Your second ligne is wrong db.execute ("create table if table does not exist 2 (name text, my_id integer, foreign key (my_id) reference Maintenance (ID)) ") as explained
Read more

Python's equivalent for Ruby's define_method? -

-
What is a Python equivalent for Ruby's define_method , which is the dynamic generation of class methods will allow? (As can be seen in Wikipedia) Functions are first-class objects in Python and assign them The properties of a class or an example can be a way of doing the same thing as a Wikipedia example: colors = {"black": "000", "red": "F00", "green": "0f0", "yellow": "ff0", "blue": "00f", "magenta": "fff", "cyan": "0ff", "white": " FFF "} Class MyStream (ARR): Pass for Name, Code in colors.iteritems (): def _in_colour ( W code = code): return '& lt; Span style = "color:% s" & gt;% s & lt; / Span & gt; ' % (Code, self) setter (histrive, "in_" + name, _in_ color)
Read more