ILIST到GridView控件(选择HQL)
问题描述:
我选择在HQL:ILIST到GridView控件(选择HQL)
Dim query As IQuery = sessao.CreateQuery("SELECT PS.PseObs, P.PacNome " +
"FROM PacientesServicos AS PS INNER JOIN PS.Pacientes AS P " +
"INNER JOIN PS.Servicos AS S " +
"INNER JOIN PS.Usuarios AS U " +
"WHERE PS.Pacientes.PacNome like :nome")
query.SetParameter("nome", "HA%")
query.SetMaxResults(5)
Dim Listagem As IList = query.List
Return Listagem
我不知道摆在gridview.datasource这个名单。我尝试修改gridview的列,但没有找到数据字段。名称属性不同,当我使用select属性其他对象?但是当我删除SELECT时,可以放入gridview.datasource。
...
<asp:templatefield headertext="Pacientes">
<itemtemplate>
<asp:label id="Id"
Text= '<%# Eval("Pacientes.PacNome") %>'
runat="server"/>
</itemtemplate>
</asp:templatefield>
<asp:boundfield headertext="Observações" datafield="PseObs" ControlStyle-Width = "600" />
请,我需要帮助。我不知道。 我想获得Ilist并直接放入gridview.datasource,
我需要的想法。
答
我用构造函数创建了一个类。 我的HQL波纹管:
Dim query As IQuery = sessao.CreateQuery("SELECT New Teste(P.PacNome,PS.PseObs) " +
"FROM PacientesServicos AS PS INNER JOIN PS.Pacientes AS P " +
"INNER JOIN PS.Servicos AS S " +
"INNER JOIN PS.Usuarios AS U " +
"WHERE PS.Pacientes.PacNome like :nome")
query.SetParameter("nome", "HALL%")
Dim Listagem As IList(Of Teste) = query.List(Of Teste)()
类创建阿泰斯特:
Public Class Teste
Private nome_ As String
Private obs_ As String
Public Sub New(ByVal nome As String, ByVal obs As String)
Me.nome_ = nome
Me.obs_ = obs
End Sub
Public Property Nome As String
Get
Return nome_
End Get
Set(ByVal value As String)
nome_ = value
End Set
End Property
Public Property Obs As String
Get
Return obs_
End Get
Set(ByVal value As String)
obs_ = value
End Set
End Property
End Class
末命名空间
,我不得不创建teste.hbm.xml
<?xml version="1.0" encoding="utf-8" ?> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="Modelo" namespace="Modelo.Cidadania.Modelo" > <import class="Teste"/> </hibernate-mapping>
有你试过 – 2011-02-10 19:54:35