foreach loop through database table .net c#

Question

It's been a long day and I seem to have drawn a blank with my current issue. Below is code contained in my HomeController:

 public ActionResult About()
        {
            SqlDataReader rdr; 
            string fileName = "";
            const string connect = @"Server=localhost;Database=Images;user id=user; password=password;";

            using (var conn = new SqlConnection(connect))
            {

                var qry = "SELECT FileName FROM FileStore";
                var cmd = new SqlCommand(qry, conn);
                conn.Open();
                rdr = cmd.ExecuteReader();

                if (rdr.HasRows)
                {
                    rdr.Read();
                    fileName = rdr["FileName"].ToString();
                }

            }
            return View();
        }

I simply want to display a list of the fileNames from the database in a view. I remember how to do this but I'm stuck on how to write the loop statement that will loop through my sql table.

Can someone point me in the right direction please?

Lorenzo · Accepted Answer · 2010-10-29 21:53:01Z

3

if (rdr.HasRows) {
    while (rdr.Read()) {
        fileName = rdr["FileName"].ToString();
    }
}

answered Oct 29, 2010 at 21:53

Lorenzo

29.4k50 gold badges129 silver badges224 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

steinar · Accepted Answer · 2010-10-29 21:54:51Z

3

Do you mean as in while (rdr.Read())?

while (rdr.Read()) 
{ 
    fileName = rdr["FileName"].ToString(); 
}

NOTE: Using this pattern, you don't need .HasRows.

answered Oct 29, 2010 at 21:54

steinar

9,7011 gold badge27 silver badges39 bronze badges

Comments

anivas · Accepted Answer · 2010-10-29 21:54:50Z

2

    if (rdr.HasRows)
    {
        while (rdr.Read())
        {
            Console.WriteLine("{0}",rdr.GetString(0));
        }
    }

answered Oct 29, 2010 at 21:54

anivas

6,5776 gold badges40 silver badges45 bronze badges

Collectives™ on Stack Overflow

foreach loop through database table .net c#

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related