validating data from two tables in access

Question

please am new to c# i need help i want to create a login that can validate data from two different tables. please if there is any article to direct me to i will be glad

Pankaj Kumar Choudhary · Answer

hello @israel your question is not clear I means i can't understand what do you want . But as i got your qyestion you can use the join for creation the single table from two table then you can use this single table . it will be easy for you..........

Joginder Banger · Answer

first of all why are you used two table for validate user is correct or not. In single table is enough for validate the user. I create a single table for you and validate records. Create table TableName(id intUserName varchar(50)Password varchar(max)) insert into TableName values(1'testingOne'India') you have two option for communicate with database. First direct used in .cs page and another one is make a store procedure. I have create one Store procedure create proc Proceudre_name ( @userName varchar(max) @password varchar(max) ) as begin select count(id) from tableName where UserName=@username and Password=@password end I hope this code is help full for you.