asp.net 4.5 练习~test7-2

最新推荐文章于 2024-09-20 18:37:24 发布

虾米大王

最新推荐文章于 2024-09-20 18:37:24 发布

阅读量165

点赞数

分类专栏： asp.net c# 文章标签： c#

本文链接：https://blog.csdn.net/modern358/article/details/114401157

版权

c# 同时被 2 个专栏收录

284 篇文章 0 订阅

订阅专栏

asp.net

258 篇文章 2 订阅

订阅专栏

webform1.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="test7_2.WebForm1" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
    </div>
    </form>
</body>
</html>

webform1.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;

namespace test7_2
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            //数据库连接字符串，@表示忽略错误，因为字符串中有反斜杠
            string connectionString =@"Data Source=LAPTOP-AQKEN65V\SQLEXPRESS08;Initial Catalog=db_news;User ID=sa;Password=123456;";
            //建立数据库连接
            SqlConnection myConnection = new SqlConnection(connectionString);
            //打开连接
            myConnection.Open();

            //新建命令
            SqlCommand myCmd = new SqlCommand();
            //关联数据库连接
            myCmd.Connection = myConnection;
            //SQL语句
            myCmd.CommandText= "select * from tb_news";

            //新建读写器
            SqlDataReader myReader = myCmd.ExecuteReader();

            //输出表格
            Response.Write("<h3>使用SqlDataReader对象查询数据库</h3>");
            Response.Write("<table border='1' >");
            Response.Write("<tr bgcolor='gray'>");
            //输出列标题
            for(int i=0;i<myReader.FieldCount;i++)
            {
                Response.Write("<td>" + myReader.GetName(i) + "</td>");
            }
            Response.Write("</tr>");
            //循环输入内容
            while(myReader.Read())
            {
                Response.Write("<tr>");
                for(int j=0;j<myReader.FieldCount;j++)
                {
                    Response.Write("<td>" + SubStr(myReader[j].ToString(),20) + "</td>");
                }
                Response.Write("</tr>");
            }
            //输出表格尾
            Response.Write("</table>");
            //关闭
            myReader.Close();
            myConnection.Close();
        }
        //截取字符串的方法
        public string SubStr(string str,int length)
        {
            if(str.Length <= length)
            {
                return str;
            }
            string newString = str.Substring(0,length);
            newString = newString + "......";
            return newString;
        }
    }
}

建表sql

CREATE DATABASE db_news
USE db_news
GO

CREATE TABLE dbo.tb_news(
id int identity(1,1) not null primary key,
title varchar(50) not null,
content varchar(2000) not null,
categories varchar(50) not null,
type1 varchar(50) not null,
issueDate datetime not null default getdate())

GO

insert into tb_news(title,content,categories,type1)
values('创业板开板','新浪财经讯10月17日上午消息 中国证监会主席在企业投融资论坛上透露，经国务院批准成立创业板。','环球经济','国内新闻');