上一篇: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>");
}