Consulta de DataGrid en ASP.NET ?

[raab99]

este es el codigo vb.net

' String de conexion de la Aplicacion
Dim ConnectionString As String = "server='localhost';database=pradb2000;truste d_connection=true"
Dim SelectCommand As String = "SELECT * from chart"
Dim isEditing As Boolean = False
'+---------------------------------------------------------------+
Sub Page_Load(Sender As Object, E As EventArgs)
If Not Page.IsPostBack Then
' llama la información cuando es abierta la pagina
' y permite refrescar la pagina cuando se adiciona,elimina o edita los registros
BindGrid()
End If
End Sub
'+---------------------------------------------------------------+
'! Rutinas para Edit, Delete, Update, Cancel y Add registros
'+---------------------------------------------------------------+
Sub DataGrid_ItemCommand(Sender As Object, E As DataGridCommandEventArgs)
' Determina el comando a ejecutar
CheckIsEditing(e.CommandName)
End Sub
'+---------------------------------------------------------------+
Sub CheckIsEditing(commandName As String)
If DataGrid1.EditItemIndex <> -1 Then
' Cuando se edita una fila
If commandName <> "Cancel" And commandName <> "Update" Then
' si el usuario cancela la actualizacion
Message.Text = "Your changes have not been saved yet. Please press update to save your changes, or cancel to discard your changes, before selecting another item."
isEditing = True
End If
End If
End Sub
'+---------------------------------------------------------------+
Sub DataGrid_Edit(Sender As Object, E As DataGridCommandEventArgs)
' Activa la Celda Donde se presiono Edit
If Not isEditing Then
DataGrid1.EditItemIndex = e.Item.ItemIndex
BindGrid()
End If
End Sub