I have a table called bank_details in the database with all the bank details like bank name branch address ifsc code micr code . Now i have a form in vb .net , with list of employees , I want to select a employee then select bank name , acording to bank name all the branch will show into dropdown list , then select branch name , after that all the center will show, the district then state then ifsc code . and then submit the form., another table i have that is empbank where all the details of employee and bank details will saved. How to do that
That I know, But in this, I have a Single table with all the details of the bank like
[Bank_Name],[IFSC],[Branch],[Centre],[District],[State],[Address],[CONTACT1],[Contact],[Email]
now from this how can I select a single row.
example
Bank_Name IFSC Branch Centre District State
AndhraBank ANDB0000038 Bargarh BARGARH BARGARH ORISSA
AndhraBank ANDB0000056 Bolangir BOLANGIR BALANGIR ORISSA
now in a form i have dropdownlist called
Bank name Branch Centre District state IFSC
where I have select bankName from the list of Banks after selection of Bank like Andhra bank al the braNch will found in branch name drop-down list, then select branch name after that all center will found in the center drop-down list. and in last dropdown list that is ifsc code will be found the single one . then I have to submit that. with all the data and employee details also will save in a table called empbank.