Hi guys need your helps. Now i doing the update part for my program. How to i get data from two table after i type the badge id and employee id then i will show other detail in the same form. So how to do that, need to use what method on it. need what sql?
Other question is how to move the data form table 1 to table 2 after the user update the data. Like active = yes table1 and active=no table two ? Need to do what in the sql statement?
use inner join in SQL.....it is available as a sample example in MSDN or anywhere on the net
similarly, for the next transaction try and insert the relevant record into table2 and then delete it from table1 on some unique key using sql.
Use the same methods as I have described and given examples of in your other threads that already solve this problem.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.