Bon j ai trouvé qqche qui fonctionne avec un Sqlhelper
Imports Microsoft.ApplicationBlocks.Data
Imports System
Imports System.Collections
Imports System.Data
Imports System.Web
Imports System.Web.UI.WebControls
Public Class WebForm1
Inherits System.Web.UI.Page
Protected WithEvents DataGrid1 As System.Web.UI.WebControls.DataGrid
Protected WithEvents Button1 As System.Web.UI.WebControls.Button
#Region " Web Form Designer Generated Code "
'This call is required by the Web Form Designer.
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
End Sub
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: This method call is required by the Web Form Designer
'Do not modify it using the code editor.
InitializeComponent()
End Sub
#End Region
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Session("Customers" ) = SQLhelper.ExecuteDataset(ConfigurationSettings.AppSettings.Get("con" ), CommandType.Text, "SELECT * FROM Customers" )
DataGrid1.DataSource = Session("Customers" )
DataGrid1.DataBind()
End Sub
Private Sub DataGrid1_SortCommand(ByVal source As System.Object, ByVal e As System.Web.UI.WebControls.DataGridSortCommandEventArgs) Handles DataGrid1.SortCommand
Dim dv As DataView
dv = New DataView(CType(Session("Customers" ), DataSet).Tables(0))
dv.Sort = e.SortExpression
DataGrid1.DataSource = dv
DataGrid1.DataBind()
End Sub
End Class
Pour ceux que ca intéresse
---------------
Le Smiley de la mort !! (8÷þ