数据库中一个表的内容

最新推荐文章于 2023-11-28 16:45:58 发布

doitok

最新推荐文章于 2023-11-28 16:45:58 发布

阅读量830

点赞数

分类专栏： c# 文章标签：数据库 string database dataset table webservice

本文链接：https://blog.csdn.net/doitok/article/details/1658625

版权

c# 专栏收录该内容

26 篇文章 0 订阅

订阅专栏

aspx代码:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" Debug="true" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>default.aspx</title>
</head>
<body>
    <form id="form1" runat="server">
    <div style="font-size:12px; text-align:center;">数据库中一个表的内容(循环的思路可以看一下)</div>
    <asp:Label ID="lblComment" runat="server"></asp:Label>
    </form>
</body>
</html>

cs代码:

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //WebService ws = new WebService();
        lblComment.Text = getTableContent(".//SQLEXPRESS", "video", "sa", "111", "v_rate");
    }
    /// <summary>
    /// 查看一个表中的内容(5个参数)
    /// </summary>
    /// <param name="host">数据库服务器名</param>
    /// <param name="database">数据库名</param>
    /// <param name="uid">数据库用户名</param>
    /// <param name="pwd">数据库用户密码</param>
    /// <param name="table">数据库中的表名</param>
    /// <returns></returns>
    public string getTableContent(string host,string database,string uid,string pwd,string table)
    {
        string cnstr = "server=" + host + ";database=" + database + ";uid=" + uid + ";pwd=" + pwd + ";";
        SqlConnection conn = new SqlConnection(cnstr);
        SqlDataAdapter cmd = new SqlDataAdapter("select * from " + table, conn);
        DataSet ds = new DataSet();
        cmd.Fill(ds, "table");
        DataTable dt;
        dt = ds.Tables["table"];

        string rsString;
        rsString = "<table width=/"100%/" border=/"0/" bgcolor=/"#333333/" cellpadding=/"1/" cellspacing=/"1/" style=/"font-size:12px;/">"
                  + "<tr bgcolor=/"white/">";
        for (int i = 0; i <= dt.Columns.Count - 1; i++)
        {
            rsString += "<td>" + dt.Columns[i].ColumnName + "</td>";
        }
        rsString += "</tr>";
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            rsString += "<tr bgcolor=/"white/">";
            for (int j = 0; j <= dt.Columns.Count - 1; j++)
            {
                rsString += "<td>" + dt.Rows[i][j] + "</td>";
            }
            rsString += "</tr>";
        }
        rsString += "</table>";
        return rsString;
    }
}