Hello all, I'm having a bit of trouble finding out how to do this with google so I figured I would give this a shot.

 

What I'm looking to do is have a textbox on my webpage where someone can type in their phone number (restricted to numerical values only), which then will search a csv file for the row that starts with their phone number and return all of the separated values in that row.  For example in c# it would look something like this:

 

lets say my csv file, openorders.csv contains 3 columns with a phone number, name, and email and I separated each value with a pound sign instead of a comma

 

9999999999#Joe Smith#joesmith@joesmithrocks#4

8888888888#Jack Smith#jacksmith@joesmithrocks#3

7777777777#Jane Smith#janesmith@joesmithrocks#2

 

var openorders = File.ReadAllLines(openOrders.csv)

 

foreach(var line in openOrders)

{

      string[] parts = line.Split('#');

      if(parts[0] == txtPhone.Text)

      {

            lblName.Text = parts[1];

            lblEmail.Text = parts[2];

      }

      if(parts[3] == 4)

            lblStatus.Image = COMPLETE.png;

      if(parts[3] == 3)

            lblStatus.Image = FINALIZING.png;

      if(parts[3] == 2)

            lblStatus.Image = WORKING.png;

}

 

I want to do this, but I want to display the name and email on a webpage.  I also want to display separate images depending on one of the values contained in the row.