SqlDataReader And SqlCommand读取数据

最新推荐文章于 2020-06-23 13:46:39 发布

原创最新推荐文章于 2020-06-23 13:46:39 发布 · 752 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#exception #string #null #border #object #table

asp.net 专栏收录该内容

29 篇文章

订阅专栏

本文介绍了一种使用C#从SQL数据库中读取数据并将其格式化为HTML表格的方法。包括连接数据库、执行SQL查询、处理多个结果集以及异常处理等关键步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

protected void Page_Load(object sender, EventArgs e)
    {
        ReadSingleResult(); ReadMultiResult();
    }
    private void ReadSingleResult()
    {
        string conString = ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ConnectionString;
        SqlConnection myCon = new SqlConnection(conString);

        SqlCommand myCmd = new SqlCommand("select top 15 * from Catalog order by id desc",myCon);
        SqlDataReader dr = null;
        try
        {
            myCon.Open();
            dr = myCmd.ExecuteReader();
            ShowData(dr);
            dr.Close();
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
        }
        finally
        {
            myCon.Close();
        }

}

    private void ShowData(SqlDataReader dr)
    {
        StringBuilder sb = new StringBuilder();
        sb.Append("<table border=1>");
        sb.Append("<tr>");
        //Response.Write(dr.FieldCount);
        for (int i = 0; i < dr.FieldCount; i++)
        {
            sb.Append("<td bgcolor=gray width=100px>");
            sb.Append(dr.GetName(i));
            sb.Append("</td>");
        }
        sb.Append("</tr>");
        while (dr.Read())
        {
            sb.Append("<Tr>");
            for (int i = 0; i < dr.FieldCount; i++)
            {
                sb.Append("<td width=100px>");
                sb.Append(dr[i].ToString());
                sb.Append("</td>");
            }
            sb.Append("</tr>");
        }
        sb.Append("</table>");
        sb.Append("<hr>");
        Response.Write(sb.ToString());

}

    private void ReadMultiResult()
    {
        string conString = ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ConnectionString;
        using (SqlConnection myCon = new SqlConnection(conString))
        {
            using (SqlCommand myCmd = new SqlCommand("Pr_GetMultiResult", myCon))
            {
                SqlDataReader dr = null;
                try
                {

                        myCon.Open();

                    dr = myCmd.ExecuteReader(CommandBehavior.CloseConnection);
                    do
                    {
                        ShowData(dr);
                    }
                    while (dr.NextResult());
                    dr.Close();
                }
                catch (Exception ex)
                {
                    Response.Write(ex.Message);
                }
                finally
                {
                    myCon.Close();
                }
            }
        }
    }