I seem to keep getting an error when configuring the TableAdapter. Mty query is
SELECT UserID, UserN FROM tblPersonnel WHERE UserN = @UserParam
and the error is:
Error in WHERE clause near '@'. Unable to parse text.
Does this mean that a parameter cannot be a string?
Thanks CJARD. I have tried this already but got bogged down with the parameter. In my case the form control already has a value that I want to pick up and use as the parameter, but I cannot get the control.value into the parameter. That's the vital bit that I am struggling with.
Sorry, been away from the PC. Also sorry but I went off at a tangent and didn't really think through your advice.
Can we go back a step or two please? My database is in MS Access. What I am struggling with is how to set a parameter on a query that is in the database itself. Should I be thinking...
I have tried setting a parameter, but encountered problems with the syntax. The reference literature doesn't help by referring to @ as a parameter symbol for SQL Server data sources and ? for Ms Access sources. My data source is Ms Access so I tried using ? but to no avail.
Maybe I'll try @ to...
I think I need to explain what I am trying to do. The system I am developing is a personnel time-recording system. The datagridview in form2 is populated from a query (
;). This selects all the data from tblTimeData that is still 'live', i.e. the employee can still enter and amend times. So...
It doesn't matter. The only user to see form2 will be the logged on user. So the only data they will retrieve, from either the dataset or the database will be their own records. If one way is quicker than the other then we should venture down the quickest I guess.
Thanks
I am new to Visual Studio.
I have a VS project connected to a Microsoft Access 2007 database (flex.accdb). I am using VS 2005. Old but good!
I have created a windows form (form1) that includes a control that contains the network user name (from environment.username). Form1 also contains a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.