How to pass value from string array to Select statement?
                            
                         
                        
                     
                 
                
                    Hi,
I have a List and there I have stored customerNo from database like this
                    List<string[]> _customerDetails = new List<string[]>();
                    while (readerCus.Read())
                    {
                        string[] fields = new string[2];
                        fields[0] = readerCus["Customer"].ToString();
                        _customerDetails.Add(fields);
                    }
Inside a foreach I need to get this "Customer" no one by one and pass it to SQL select statement.
foreach (string[] fields in _customerDetails)
                    {
                        string cusId = fields[0];
  using (SqlConnection con2 = new SqlConnection(connectionString))
                        {
                            con2.Open();
                            using (SqlCommand command2 = new SqlCommand("SELECT * FROM dbo.Customers WHERE Customer = '" + fields[0].ToString() + "'", con2))
                            using (SqlDataReader reader2 = command2.ExecuteReader())
                            {
 
                                while (reader2.Read())
                                {
                                        //My code and here I am generating a token for customer
                                }
                            }
                         }
                      }
My issue is all the time it runs one time and generate a token.Not continuing and not completing all available customers (say 1000 customers).Any one can point me how can I loop through all customers one by one.
Thank