62,254
社区成员
发帖
与我相关
我的任务
分享
#region 引用命名空间
Imports System
Imports System.Collections
Imports System.ComponentModel
Imports System.Data
Imports System.Drawing
Imports System.Web
Imports System.Web.SessionState
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Web.UI.HtmlControls
Imports System.Text
Imports System.IO
Imports System.Data.OleDb
Imports System.Security
Imports System.Text.RegularExpressions
Imports System.Configuration
#endregion
Partial Class sjsws1 Inherits System.Web.UI.Page
#region 变量定义
Dim etgbdata = (ConfigurationSettings.AppSettings("etgbdata"))
Dim strdsn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(etgbdata)
Dim objconn As OleDbConnection
#endregion
#region 页面载入
'页面载入事件
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
//如果是第一次加载,则执行下列代码
If Not Page.IsPostBack() Then
topgd()
topdhgsjj()
topdhxwzx()
topdhsjsw()
topdhtsjm()
topurl()
sjswsdh()
sjswsbody()
probody()
End If
End Sub
#endregion
#region 自定义函数
/// <summary>
/// 获取数据及数据绑定
/// </summary>
Sub topgd()
objconn = New OleDbConnection(strdsn) //初始化数据库连接对象
Dim strsql As String = "select * from wz where id=13" //SQL语句
Dim rs As New OleDbDataAdapter(strsql, objconn) //实例化一数据适配器对象
Dim ds As New DataSet //实例化一数据集
rs.Fill(ds, 0) //使用数据适配器根据SQL语句填充数据集
topgds.DataSource = ds.Tables(0).DefaultView //指定topgds的数据源为数据集的第1张表
topgds.DataBind() //topgds数据绑定
End Sub
#endregion
#region 事件
Public Sub sjswsdhs_ItemCreated(ByVal sender As Object, ByVal e As RepeaterItemEventArgs)
//如果当前的DataItem不为空则执行
If e.Item.DataItem IsNot Nothing Then
Dim iid As Integer //变量定义
If Request("sx_id") <> "" Then //如果能从URL中获取到sx_id则执行
iid = Request("sx_id") //将获取到的sx_id的值赋予iid
Else
iid = 1 //设iid=1
End If
//如果当前行的sx_id列的值不等于iid,则隐藏rowIMGLink1控件,显示rowWordLink1控件
If e.Item.DataItem.Row("sx_id") <> iid Then
e.Item.FindControl("rowIMGLink1").Visible = False
e.Item.FindControl("rowWordLink1").Visible = True
//如果当前行的sx_id列的值不等于iid,则显示rowIMGLink1控件,隐藏rowWordLink1控件
Else
e.Item.FindControl("rowIMGLink1").Visible = True
e.Item.FindControl("rowWordLink1").Visible = False
End If
End If
End Sub
#endregion