Consulta de DataGrid en ASP.NET ?

[raab99]

Alguien Sabe :

1.- como puedo manipular a nivel de programacion el DataGrid y sus propiedades en tiempo de ejecucion

2.- Donde Consigo Manuales,tutoriales hacerca del tema

3.- Donde Consigo información de VB.NET ?

Saludos y Gracias :)

y Gano Brasil ( <IMG SRC="images/futbol.gif" WIDTH="15" HEIGHT="15" HSPACE="3"> )

[Gurrutello]

hola
data grid??
pon exacto, digo mas o menos algo de codigo de lo que deseas informacion.
data grid es algo como datos de celdas si no me equivoco quiere decir como datos de base de datos?
no se
un saludo
ESPAÑA US COREA
jeje

<a href="http://www.publicentral.com">Publicentral.com</a>

[raab99]

este es el codigo vb.net

' String de conexion de la Aplicacion
Dim ConnectionString As String = &quot;server='localhost';database=pradb2000;truste d_connection=true&quot;
Dim SelectCommand As String = &quot;SELECT * from chart&quot;
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 &lt;&gt; -1 Then
' Cuando se edita una fila
If commandName &lt;&gt; &quot;Cancel&quot; And commandName &lt;&gt; &quot;Update&quot; Then
' si el usuario cancela la actualizacion
Message.Text = &quot;Your changes have not been saved yet. Please press update to save your changes, or cancel to discard your changes, before selecting another item.&quot;
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

[raab99]

Sub DataGrid_Update(Sender As Object, E As DataGridCommandEventArgs)
' Actualiza la base de datos con los nuevos valores
' tomando los valores del texbox
Dim glnum As String = CType(e.Item.Cells(2).Controls(0), TextBox).Text
Dim descri As String = CType(e.Item.Cells(3).Controls(0), TextBox).Text
' Actualiza los datos de la aplicacion
Dim myConnection As New SqlConnection(ConnectionString)
Dim UpdateCommand As SqlCommand = new SqlCommand()
UpdateCommand.Connection = myConnection
If AddingNew = True Then
UpdateCommand.CommandText = &quot;INSERT INTO chart(glnum, descri) VALUES (@glnum, @descri)&quot;
Else
UpdateCommand.CommandText = &quot;UPDATE chart SET glnum = @glnum, descri = @descri WHERE glnum = @glnum&quot;
End If
UpdateCommand.Parameters.Add(&quot;@glnum&quot;, SqlDbType.VarChar, 15).Value = glnum
UpdateCommand.Parameters.Add(&quot;@descri&quot;, SqlDbType.VarChar, 40).Value = descri
' Ejecuta el Comando
Try
myConnection.Open()
UpdateCommand.ExecuteNonQuery()
Catch ex as Exception
Message.Text = ex.ToString()
Finally
myConnection.Close()
End Try
' Restaura el grid con los nuevos registros (Refresh)
If AddingNew = True Then
DataGrid1.CurrentPageIndex = 0
AddingNew = false
End If
DataGrid1.EditItemIndex = -1
BindGrid()
End Sub
'+---------------------------------------------------------------+
Sub DataGrid_Cancel(Sender As Object, E As DataGridCommandEventArgs)
' Cancela la Edicion sin ningun cambio en la base de datos
DataGrid1.EditItemIndex = -1
BindGrid()
AddingNew = False
End Sub
'+---------------------------------------------------------------+
Sub DataGrid_Delete(Sender As Object, E As DataGridCommandEventArgs)
' Elimina la fila seleccionada
If Not isEditing Then
' Selecciona la llave para ejecutar la operacion en la base de datos
Dim keyValue As String = Cstr

[raab99]

&lt;form runat=&quot;server&quot;&gt;
&lt;p align=&quot;center&quot;&gt;
&lt;asp:datagrid id=&quot;DataGrid1&quot; runat=&quot;server&quot; BorderColor=&quot;#CC9966&quot; OnItemCommand=&quot;DataGrid_ItemCommand&quot; OnEditCommand=&quot;DataGrid_Edit&quot; OnUpdateCommand=&quot;DataGrid_Update&quot; OnCancelCommand=&quot;DataGrid_Cancel&quot; OnDeleteCommand=&quot;DataGrid_Delete&quot; AllowPaging=&quot;True&quot; OnPageIndexChanged=&quot;DataGrid_Page&quot; BackColor=&quot;White&quot; CellPadding=&quot;4&quot; width=&quot;80%&quot; OnSelectedIndexChanged=&quot;DataGrid1_SelectedInd exChanged&quot; BorderStyle=&quot;Double&quot; BorderWidth=&quot;3px&quot; AutoGenerateColumns=&quot;False&quot; DataKeyField=&quot;glnum&quot;&gt;
&lt;FooterStyle forecolor=&quot;#330099&quot; backcolor=&quot;#FFFFCC&quot;&gt;&lt;/FooterStyle&gt;
&lt;HeaderStyle font-names=&quot;Century Gothic&quot; font-bold=&quot;True&quot; forecolor=&quot;#FFFFCC&quot; bordercolor=&quot;Black&quot; backcolor=&quot;CornflowerBlue&quot;&gt;&lt;/HeaderStyle&gt;
&lt;PagerStyle nextpagetext=&quot;Next&quot; font-size=&quot;Smaller&quot; prevpagetext=&quot;Previous&quot; horizontalalign=&quot;Right&quot; forecolor=&quot;#330099&quot; position=&quot;TopAndBottom&quot; backcolor=&quot;#FFE0C0&quot;&gt;&lt;/PagerStyle&gt;
&lt;SelectedItemStyle font-bold=&quot;True&quot; forecolor=&quot;Red&quot; backcolor=&quot;#FFCC66&quot;&gt;&lt;/SelectedItemStyle&gt;
&lt;EditItemStyle font-bold=&quot;True&quot; borderstyle=&quot;Groove&quot; bordercolor=&quot;#FF8000&quot;&gt;&lt;/EditItemStyle&gt;
&lt;AlternatingItemStyle borderwidth=&quot;2px&quot; borderstyle=&quot;Solid&quot; bordercolor=&quot;White&quot;&gt;&lt;/AlternatingItemStyle&gt;
&lt;ItemStyle forecolor=&quot;#330099&quot; backcolor=&quot;White&quot;&gt;&lt;/ItemStyle&gt;
&lt;Columns&gt;
&lt;asp:EditCommandColumn ButtonType=&quot;LinkButton&quot; UpdateText=&quot;Update&quot; CancelText=&quot;Cancel&quot; EditText=&quot;Edit&quot;&gt;
&lt;ItemStyle font-size=&quot;Smaller&quot; width=&quot;10%&quot;&gt;&lt;/ItemStyle&gt;
&lt;/asp:EditCommandColumn&gt;
&lt;asp:ButtonColumn Text=&quot;Delete&quot; CommandName=&quot;Delete&quot;&gt;
&lt;ItemStyle font-size=&quot;Smaller&quot; width=&quot;10%&quot;&gt;&lt;/ItemStyle&gt;
&lt;/asp:ButtonColumn&gt;
&lt;asp:BoundColumn DataField=&quot;glnum&quot; HeaderText=&quot;Gl Account&quot;&gt;&lt;/asp:BoundColumn&gt;

[TomaHawkk]

Hola!

Aquí te dejo un Link donde podras encontrar un buen ejemplo con el DataGrid:

<a href='ir.asp?http://es.gotdotnet.com/quickstart/aspplus/' target='_blank'>http://es.gotdotnet.com/quickstart/asppl...</a>

Un saludo.