使用SqlDataAdapter对象填充数据集

  protected void Page_Load(object sender, EventArgs e)
    {
        FillData();
    }

    private void FillData()
    {
        string conString = ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ConnectionString;
        using (SqlConnection myCon = new SqlConnection(conString))
        {
            using (SqlDataAdapter da = new SqlDataAdapter("select top 10 * from catalog order by id desc", myCon))
            {
                DataSet ds = new DataSet();
                try
                {
                    myCon.Open();
                    da.Fill(ds);
                    ShowData(ds);
                }
                catch (Exception ex)
                {
                    throw ex;
                }
                finally
                {
                    myCon.Close();
                }
            }
        }
    }

    private void ShowData(DataSet ds)
    {
        if (ds.Tables.Count <= 0)
        {
            return;
        }

        StringBuilder sb = new StringBuilder();
        sb.Append("<table border=1>");
        sb.Append("<tr>");
        for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
        {
            sb.Append("<td bgcolor=gray>");
            sb.Append(ds.Tables[0].Columns[i].ColumnName);
            sb.Append("</td>");
        }
        sb.Append("</tr>");

        foreach (DataRow row in ds.Tables[0].Rows)
        {
            sb.Append("<tr>");
            for (int i = 0; i < row.ItemArray.Length; i++)
            {
                sb.Append("<td>");
                sb.Append(row.ItemArray[i].ToString());
                sb.Append("</td>");
            }
            sb.Append("</tr>");
        }
        sb.Append("</table>");
        sb.Append("<hr>");
        Response.Write(sb.ToString());
    }