显示文章.aspx.vb

用户登录新闻发布系统,其中的设计ASP_NET新闻管理系统

Imports System.Data.SqlClient
Imports CasingCNCls.clsArticles
Imports System.IO
Public Class 显示文章
    Inherits System.Web.UI.Page
    Dim sql As String
    Protected WithEvents DataGrid2 As System.Web.UI.WebControls.DataGrid
    Dim mid As String

#Region " Web 窗体设计器生成的代码 "

    '该调用是 Web 窗体设计器所必需的。
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

    End Sub
    Protected WithEvents DataGrid1 As System.Web.UI.WebControls.DataGrid

    '注意: 以下占位符声明是 Web 窗体设计器所必需的。
    '不要删除或移动它。
    Private designerPlaceholderDeclaration As System.Object

    Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
        'CODEGEN: 此方法调用是 Web 窗体设计器所必需的
        '不要使用代码编辑器修改它。
        InitializeComponent()
    End Sub

#End Region

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        '在此处放置初始化页的用户代码
        view()
    End Sub
    Sub view()
        read()
        Dim str As CasingCNCls.clsArticles
        mid = Request.QueryString("id")
        Dim conn As SqlConnection
        conn = New SqlConnection(sql)
        Dim comm As SqlCommand
        Dim comm2 As SqlCommand
        comm = New SqlCommand("select 摘要 from tblArticles where 文章代码='" & mid & "' ", conn)
        comm2 = New SqlCommand("select 标题,加入时间 from tblArticles where 文章代码='" & mid & "'", conn)
        conn.Open()
        datagrid2.datasource = comm2.ExecuteReader
        DataGrid2.DataBind()
        conn.Close()
        conn.Open()
        DataGrid1.DataSource = comm.ExecuteReader
        DataGrid1.DataBind()
        conn.Close()
        conn = Nothing
        comm = Nothing
        '  str.文章代码 = mid
    End Sub
    Sub read()
        Dim str As System.IO.StreamReader
        str = File.OpenText(Server.MapPath("sql.txt"))
        sql = str.ReadToEnd
        str.Close()
    End Sub
End Class