Excel data reader , query join ??? help needed RRS feed

  • Question

  • User-360218696 posted

    i have two sheets in excel with two column

    Name        number

    AAAA          111

    BBBB           112

    CCCC          114

    DDDD        115

    and sheet 2 also has similar data

    currently i am using a textbox and a data reader where the data reader connects to the excel sheet gets all the name and shows them on the textbox as a live search.

    i am also able to get the names from the sheet 2 by using a 2nd data reader to read sheet 2. now my problem is when i read name and i also want to get the number assigned to that name. the name can be either from sheet 1 or sheet2 which i have managed to displace in live search box but i am not able to get the number. any one has done this before??




    Saturday, January 28, 2012 12:00 AM


  • User-101068015 posted


    If you want to achieve your function, you need to use Ajax, and aslo you can use linq to excel to get all you want.

    1. Ajax for live search

    2. Linq to excel

    Hope it helpful.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, January 29, 2012 11:00 PM