Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'在此处放置初始化页的用户代码
If Not IsPostBack Then
Dim Opus_id As Int64 = CInt(Request.Params("id")) Repeater1.DataSource = LSopus.Customer.GetCustomers(Opus_id)
Repeater1.DataBind() Sqlconn = New SqlConnection(Getconnstring())
Sqlcomm = New SqlCommand("GetOpusCustomer", Sqlconn)
Sqlcomm.CommandType = CommandType.StoredProcedure Dim ParameterOpus_id As SqlParameter = New SqlParameter("@opus_id", SqlDbType.Int, 4)
ParameterOpus_id.Direction = ParameterDirection.Input
ParameterOpus_id.Value = Opus_id
Sqlcomm.Parameters.Add(ParameterOpus_id) Sqlconn.Open()
Repeater2.DataSource = Sqlcomm.ExecuteReader(CommandBehavior.CloseConnection)
Repeater2.DataBind()
End If
End Sub Private Sub Repeater2_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.RepeaterItemEventArgs) Handles Repeater2.ItemDataBound
‘’‘’‘我想在这里获取当前行的某一列的数据,应该怎么转换?它的数据源不是dataset,如果是dataset可以利用' Dim myrow As DataRow = CType(e.Item.DataItem, DataRowView).Row来获取, End Sub
'在此处放置初始化页的用户代码
If Not IsPostBack Then
Dim Opus_id As Int64 = CInt(Request.Params("id")) Repeater1.DataSource = LSopus.Customer.GetCustomers(Opus_id)
Repeater1.DataBind() Sqlconn = New SqlConnection(Getconnstring())
Sqlcomm = New SqlCommand("GetOpusCustomer", Sqlconn)
Sqlcomm.CommandType = CommandType.StoredProcedure Dim ParameterOpus_id As SqlParameter = New SqlParameter("@opus_id", SqlDbType.Int, 4)
ParameterOpus_id.Direction = ParameterDirection.Input
ParameterOpus_id.Value = Opus_id
Sqlcomm.Parameters.Add(ParameterOpus_id) Sqlconn.Open()
Repeater2.DataSource = Sqlcomm.ExecuteReader(CommandBehavior.CloseConnection)
Repeater2.DataBind()
End If
End Sub Private Sub Repeater2_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.RepeaterItemEventArgs) Handles Repeater2.ItemDataBound
‘’‘’‘我想在这里获取当前行的某一列的数据,应该怎么转换?它的数据源不是dataset,如果是dataset可以利用' Dim myrow As DataRow = CType(e.Item.DataItem, DataRowView).Row来获取, End Sub
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货