Visual Basic

Re: Run-time error '-2147217913 (80040e07)': Data type mismatch in criteria expression

30-Jan-12 14:02

is that so?but that's statement seem doesn't effect the running program..but when i run the program, the error appear and it's point to this code:

Dim SimpanGaji As String
SimpanGaji = " Insert into Gaji1 _ (NomorSlp,Tanggal,Jam,NIP,Pendapatan,Potongan,GajiBersih,KodeKsr) values " & _
        "('" & LblNomorSlp & "','" & CDate(LblTanggal) & "','" & LblJam & "', " & _
        "'" & Combo1 & "','" & LblPendapatan & "','" & LblPotongan & "', " & _
        "'" & LblTotal & "','" & LblKodeKsr & "')"
        Conn.Execute (SimpanGaji)----> point to this code

debug the error point to --> Conn.Execute (SimpanGaji)
Thank you..

Dave Kreskowiak30-Jan-12 15:21

Re: Run-time error '-2147217913 (80040e07)': Data type mismatch in criteria expression

30-Jan-12 15:21

Yes, it is so.

Wow. This little gem could very easily be causing your problem. Your INSERT statement is treating every single value as a string. Your database table (Gaji1) probably doesn't have every field defined as some variant of char.

The second LARGE problem with this code is that you're using string concatentation to build the SQL statement. This is a HUGE security risk which can end up detroying your entire database.

Google for ".NET Parameterized Queries" for explanations as to why I said that and how you can avoid it as well as makding your SQL related code much easier to understand and debug.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

rizaky201130-Jan-12 16:59

Re: Run-time error '-2147217913 (80040e07)': Data type mismatch in criteria expression

30-Jan-12 16:59

so i have to change the INSERT statement?this the data type of each filed in my table Gaji1,
NomorSlp data type = Text
Tanggal = Date/Time
Jam = Date/Time
Pendapatan = Number
Potongan = Number
GajiBersih = Number
NIP = Text
KodeKsr = Text

so it's could not be defined as string?should i change into variant, all of them?
Sorry to much asking, cause this is 1st time i made a program Big Grin | :-D

modified 30-Jan-12 23:07pm.

Dave Kreskowiak30-Jan-12 18:04

Re: Run-time error '-2147217913 (80040e07)': Data type mismatch in criteria expression

30-Jan-12 18:04

Yes. You have three numeric fields in that table and your INSERT statement is treating them as strings. See the ' characters you're putting around those values??? Don't. And don't build the SQL statement the way you are now. Learn about parameterized queries and use them. Had you done so alreay, you may not have even seen this problem.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

rizaky201131-Jan-12 17:02

Re: Run-time error '-2147217913 (80040e07)': Data type mismatch in criteria expression

31-Jan-12 17:02

so should i change the statement? can You suggest me the right code..
the samples? please? cause i'm newbie..
thank You

Dave Kreskowiak1-Feb-12 1:32

Re: Run-time error '-2147217913 (80040e07)': Data type mismatch in criteria expression

1-Feb-12 1:32

Apparently you don't know anything about the SELECT statement format. For numeric fields, you don't put ' characters around the values.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

rizaky20116-Feb-12 14:37

Re: Run-time error '-2147217913 (80040e07)': Data type mismatch in criteria expression

6-Feb-12 14:37

Ya,you right specially bout the ' character,so could you give me the samples please? t
Thank you..

Dave Kreskowiak6-Feb-12 16:43

Re: Run-time error '-2147217913 (80040e07)': Data type mismatch in criteria expression

6-Feb-12 16:43

You're kidding, right? Ever hear of experimenting a little? It's the best way to teach yourself something. Make a little change, see what it does.

Dim query As String = "INSERT INTO table (numericField1, stringField1) VALUES (23, 'SomeString')"

BTW, the way you built your SQL statement is the worst possible method you could use to do it. Google for ".net parameterized query" and start reading. Seriously.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

rizaky20116-Feb-12 17:39

Re: Run-time error '-2147217913 (80040e07)': Data type mismatch in criteria expression

6-Feb-12 17:39

i know that statement.. i shouldn't put the ' character to numeric fields..
btw .net parameterized query thats for vb.net or vb?

Dave Kreskowiak7-Feb-12 1:45

Re: Run-time error '-2147217913 (80040e07)': Data type mismatch in criteria expression

7-Feb-12 1:45

VB.NET is what you're using, isn't it??

The concept is exactly the smae for any language.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

rizaky20117-Feb-12 14:31

Re: Run-time error '-2147217913 (80040e07)': Data type mismatch in criteria expression

7-Feb-12 14:31

No, i use VB..
Btw, can i ask again? How to delete record in DataGrid direct from DataGrid control when the program running,and it could effect to database, i use access database.. Thank you..

Dave Kreskowiak7-Feb-12 15:10

Re: Run-time error '-2147217913 (80040e07)': Data type mismatch in criteria expression

7-Feb-12 15:10

VB6?? If so, you'r using a dead language. One I haven't touched in over 10 years. So no, I can't tell you.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Bernhard Hiller26-Jan-12 21:03

Bernhard Hiller

26-Jan-12 21:03

An idea:
Your program uses a COM component. The versions of that component differ on the computers, and between the versions the interface was broken.
But that's only an idea, due to the fact that you do not provide more information I cannot tell you more than this guess.

Re: Run-time error '-2147217913 (80040e07)': Data type mismatch in criteria expression

rizaky201129-Jan-12 19:08

29-Jan-12 19:08

sorry, whats COM component?btw, i already write the code above..
thanks for your concern..

Tamper-proof service

Brandon-X1200024-Jan-12 0:30

24-Jan-12 0:30

Hello,

For people out there who know and/or have Symantec, COMODO Antivirus, and some monitoring programs for school (for example: LanSchool or Netop Vision), when you go into task manager or other third-party utility or program you made of your own for process termination, if you select any of these programs, and try to terminate it, even with the process terminating utility running as admin , it gives you the message "Access denied!". I wonder how this is possible, I do have the Windows Service template for Visual Basic 2010 .NET, but I've been doing a lot of research on how this is possible, could there be a OnTerminate (Byval as ex, Byval ex) function or sub, if this is possible,I've heard of the O.S. Kernel drivers, could you make one? just wondering how these programs could do such a thing.....Any answers would be greatly appreciated Smile | :)

Regards,
Brandon T. H.
CodeProject Member

Eddy Vluggen24-Jan-12 5:10

24-Jan-12 5:10

It's a genuine bad idea[^]. If you "really must", Google for "unkillable service" - StackOverflow has an archive on the topic.

Bastard Programmer from Hell Suspicious | :suss:

Brandon-X1200024-Jan-12 7:48

24-Jan-12 7:48

Not always true, COMODO has an exit function, user enters the password, prompts if the user really wanted to close the program, and it closes, automatically, then you could go to task manager and kill it's service from there without that "Access denied!" message. If COMODO was still running (it's program), then you would get that message.

Eddy Vluggen24-Jan-12 12:08

24-Jan-12 12:08

I didn't say that it wasn't possible, only that it's a bad idea - and those keywords should be enough to find some interesting links. I'm not going to link to it directly, for the same reason that I don't like to key-loggers.

Bastard Programmer from Hell Suspicious | :suss:

Brandon-X1200031-Jan-12 11:33

31-Jan-12 11:33

Yeah there are some people out there who would LOVE, to integrate that into their pesky programs.

Wes Aday25-Jan-12 3:13

Wes Aday

25-Jan-12 3:13

Brandon T. H. wrote:
Not always true

Just because comodo does it doesn't make it a good idea.

Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Individuality is fine, as long as we do it together - F. Burns

Brandon-X1200031-Jan-12 11:34

vb.net - Show the name of Table and Fields in DB Ms access

31-Jan-12 11:34

Wes Aday wrote:
Just because comodo does it doesn't make it a good idea.

True.

Mangore7523-Jan-12 10:51

Mangore75

23-Jan-12 10:51

I'm using vb.net 2008 and ms access2007.
I create project connection with DB ms access saving by ms access2003
I want to create a code to show me the name of Table and Field in the DB

Re: vb.net - Show the name of Table and Fields in DB Ms access

Eddy Vluggen23-Jan-12 11:07

Re: vb.net - Show the name of Table and Fields in DB Ms access

23-Jan-12 11:07

Mangore75 wrote:
I want to create a code to show me the name of Table and Field in the DB

Which table? Any table[^]?

What have you tried so far?

Bastard Programmer from Hell Suspicious | :suss:

Mangore7524-Jan-12 3:32

Mangore75

24-Jan-12 3:32

The Table in the DB(MyDB) which connection to my project :

Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source =" & Application.StartupPath & "\MyDB.mdb")

-Nothing

Re: vb.net - Show the name of Table and Fields in DB Ms access

Eddy Vluggen24-Jan-12 5:13