[VB.NET] Mon repeater renvoi 3 rows /5, mon datagrid 5/5!?
Bonjour,
Une requete SQL sur ma base SQL Server me renvoi 5 enregistrements. La mm requete dans mon webcontrol ne m'en retourne que 3.
Qqn a une idée?
Merci d'avance
Voici la requete:
Code:
1
2
3
4
5
| SELECT Ct_Status, COUNT(Xchg_Ct_ID) AS SumOfContract
FROM Xchg_Staffing INNER JOIN [Contract] ON Xchg_Staffing.Xchg_Ct_ID = [Contract].Ct_ID
WHERE (Xchg_User_ID = 347)
GROUP BY Ct_Status
ORDER BY Ct_Status |
Voici le bout de code:
Code:
1
2
3
4
5
6
7
8
|
Dim myDataAdapter As New SqlDataAdapter(strSql.ToString(), myConnection)
Dim myDataSet As New DataSet
myDataAdapter.Fill(myDataSet, "countofcontract")
Dim myDataView As New DataView(myDataSet.Tables("countofcontract"))
rptuserstaffingcountbystatus.DataSource = myDataView
rptuserstaffingcountbystatus.DataBind() |
Si je met un datagrid ça marche!!
Je ne comprend pas.
