C#开发之访问数据库表数据

上一篇：C#开发之调用数据库存储过程
http://blog.csdn.net/whuarui2010/article/details/7786061

string sql = "select * from Area";                SqlDataAdapter da = new SqlDataAdapter(sql, myConnection);                DataSet ds = new DataSet();                da.Fill(ds, "Area");                foreach (DataRow row in ds.Tables["Area"].Rows)                {                    Console.WriteLine("id    " + row[0] + "area   " + row[1]);                    s_return.Append( "<id>" + row[0] + "</id>" + "<area>" + row[1] + "</area>");                }