第一日: 读取SQL数据(C#)

        //string strCn = ConfigurationSettings.AppSettings["conn"];
        SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["conn"]);
        conn.Open();

        string sqltext = "select * from menu";
        SqlCommand sqltxt=new SqlCommand(sqltext,conn);
        SqlDataReader rs = sqltxt.ExecuteReader();

        while (rs.Read())
        {
            string id=rs["id"].ToString();
            string name = rs["M_name_cn"].ToString();
            Console.WriteLine("编号:{0} 名称:{1}", id, name);
        }

        rs.Close();
        conn.Close();
        Console.ReadLine();