Recent content by ghost807

object does not match target type but...................... if i change mytype to AddInfo then (sweet) it works You guys are my hero's everytime i have problems you are there to help out and point me in the right direction.

chmohan i sat up last night thinking about what you told me to do..... but still i don't understand. everytime i try to do what you want i get integer cannot but 1 dimensional array.

Glad to hear it. i find that i forget to look and see what names/words i'm using and depending on if i'm using msaccess or sql it always gets me into trouble.

C:\Documents and Settings\DaveEJr\My Documents\Visual Studio Projects\testapp\DBGeneric.vb(90): Value of type 'Integer' cannot be converted to '1-dimensional array of System.Object'. i guess that's what i thought i was doing with (i) already at the begining of my for loop. i guess i don't...

For existing objects with names that contain reserved words, you can avoid errors by surrounding the object name with brackets ([ ]).

ok, now what you should do is use access and create a query just like what you want and test it there.(you'll have to make up some of the data but in sql view that should be ok.) i'm willing to bet it's a simple punc. error. also these words are reserved Reserved Words...

no, i've been here several times to see what i'm missing. but i don't see it. according to what i see there what i have now should work correctly. i can change myType to myPropInfo or myPropertyInfo and i still get the same errors. if i don't use an index i will get does not accept arguments...

ok all seems to be going well. this is the last problem that i seem to be having. thanx for your help so far. any suggestions? Public Sub AddInfo(ByVal AddItem As Object) Dim myType As Type = AddItem.GetType Try Dim Connect As String =...

i frequently run into using a reserved name on accident recently is was indicators(reserved) we sell weight indicators these are some examples from a recent project i have worked on. maybe they will help you out. i mostly use access(for the cost reasons) for my databasing so this might be the...

ok so far so good. the link you provided was fantastic. but....... i need to make it so that i can substitute in the table name that is taken from my class Dim myType As Type = AddItem.GetType Dim tblName As String = "tbl" & myType.Name.Substring(3) Dim cRow...

i have several classes that i have created customer job material truck each class has a bunch of different properties what i would like to do is create a generic database connection that i could use to update, retreive, delete, or add to the database. now the question is how do i do this the...

ok last item. the password name seems to be reserved by SQL. once i changed the field name in access to passcode it works just fine. this is the final code for now, until i learn to use sql params Dim connect As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBPath Dim conn As...

sorry the password field is the item i have been having problems with since the begining. so....... this time i just tried to imput some text into it. nothing do difficult for it. but i still have a problem syntax error in update command

ok i'm not sure what's wrong now. i am lookin at the data that is being imported into the database. i thought i would just see if i was having a problem with the data that was being entered or if there was a problem with the code behind it. well it looks like there is a problem with the code...

i'm not sure how this is going to help me but i'm going to ask some more questions first. I am connecting to an access database, in this example you are telling me to do a sql connection. is this correct? i have never used a connection like your describing so some of the terms your using do not...