asp.net C＃数据库表列中列出(asp.net C# database table column to list)

 我有一个在C＃中完成的asp.net项目（我的C＃语法非常生疏），并使用它与项目创建的内置数据库。 我创建了一个名为aspnet_Tutorials的表（目前）存储两列用户提交的数据：TutorialName和TutorialContent。 很简单，这是一个学习项目。 
 
 我需要做的是从aspnet_Tutorials的第一列创建一个列表，用它在页面上创建教程的“目录”。 我遇到困难的部分，主要是语法上，连接到并遍历列以将值存入列表。 任何人都可以提供一个简单的例子吗？ 并可能解释代码中发生了什么。 
 
public class TutorialsDirDAL
    {
            SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString);
            SqlCommand cmd = new SqlCommand();
            SqlDataAdapter da = new SqlDataAdapter();
            DataSet ds = new DataSet();


        public List<string> DisplayTutorials() //parameters? String qry?
        {
           //query the database table, foreach loop over the data, place it into a list?
        }
    }
 
 我知道如何编写简单的SQL查询。 但我在谷歌搜索中看到了一些不同的设置。 我目前有以下查询，可以随意选择它或提供比使用查询更好的解决方案。 
 
cmd.CommandText = "SELECT * FROM ASPNET_TUTORIALS (TutorialTitle)"
                + "VALUES (@tutorialTitle)";
 
 谢谢！ 

I have an asp.net project done in C# (my C# syntax is very rusty) and am using the built in database it creates with the project. I've created a table called aspnet_Tutorials that (for now) stores two columns of user submitted data: TutorialName and TutorialContent. Very simple, it's a learning project. 
 
What I need to do is create a list from the first column of aspnet_Tutorials to use it to create a "directory" of the tutorials on a page. The part I'm having trouble with, mostly syntactically, is connecting to and iterating over the column to get the values into a list. Could anyone provide a straight forward example of this? And possibly explain what's going on in the code.
 
public class TutorialsDirDAL
    {
            SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString);
            SqlCommand cmd = new SqlCommand();
            SqlDataAdapter da = new SqlDataAdapter();
            DataSet ds = new DataSet();


        public List<string> DisplayTutorials() //parameters? String qry?
        {
           //query the database table, foreach loop over the data, place it into a list?
        }
    }
 
I know how to write simple sql queries. But I've seen a couple different set ups for this in my Googling spree. I currently have the following for a query, feel free to pick it apart or offer a better solution than using a query.
 
cmd.CommandText = "SELECT * FROM ASPNET_TUTORIALS (TutorialTitle)"
                + "VALUES (@tutorialTitle)";
 
Thank you!

原文：https://stackoverflow.com/questions/11414504