I am using vs.net 2008 vb and mysql I am using datasets alot in this application, however I am having a few small snags I am running into.
I created a login system that works quite well, but I need using the db or settings or a variable keep the logged in staffid and username constant on all the forms through out the forms. I have no idea how to do this. as it is information that in the end also has to be printed on the printout.
I can do a search that works very well when comparing to a table and row say example I can search by clientid2 if it does not exist it opens up a new window for the information to start to be gathered which holds dataset information in it to be accumulated. That kind of search I am ok with.
My search problem is I need to do a filter I guess with a dataset search and if it does exist it will pull that record up in detail view for editing or updating. There is a small catch to this though I need it to not overwrite the old data but keep the clientid1 and write a whole new set of information to the table or move the old set to a historical table and write the new set with everything updated and changed and the old information that is propagated to the form to the original table. I tried to do the search with a filter similar to
SELECT * FROM `hinfo` WHERE `clientid1` LIKE '%'
But it never gives me the fillby text box just a fillby button
My Last Problem is I have tables with all known zipcodes, I need it to when filled out on a form the zip code to fill in the City and State and County my tables for this are zip_code City State County.
To many of you this may be easy stuff, but I have been trying to solve these problem for the last 3 days. So any help in this would be greatly appreciated.
Thank you for your time