I did try doing that. I have a line of code that reads
"Select count(*) from ppchecktest where kpppp (which is my pay period) = @Payperiod AND kemp# (which is my employee id column) = @EmpNo"
mycommand.parameters.add("@Payperiod", ddlpayperiod.selecteditem)
mycommand.parameters.add("@empno"...
You have to make sure that you put your connection in the line that says
Dim conn as string = ""
Your connection to your database goes inside of those quotes. Once you have established that connection there, you should be able to run the program and it work
I had a problem similar to that. Here is the code that I ended up using!! Hope this helps you out!!!!
'This is the connection to the database
Dim conn As String = "(Your connection goes here)"
'Creates a new Sql Connection
Dim Securityconn As New SqlConnection(conn)
'Creates a Sql command and...
I am currently working on a program that is allowing users to login to a database and look at their pay check details. I am having one problem though. I have created my login form with an employee id and password. I have gotten it to work and validate that both a employer Id and password...
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.