![]() |
DataGrid en asp.net Hola a todos: Estoy haciendo una pagina que contiene un campo (un TextBox) un boton y un DataGrid. Esta pagina busca por codigo de articulo osea que si yo en el textbox pongo el codigo de articulo 1 por ejemplo. Me aparece la mercaderia con ese codigo. Espero que hasta hay me ayan entendido. El problema es este: Cuando yo le pongo al datagrid botones de delete y de edit, los botones no ejecutan sus funciones. Yo queria saber donde puedo poner las funciones de los botones del datagrid y que funcionen. Por las dudas le mando el codigo: <%@ Page Language="VB" %> <%@ Register TagPrefix="wmx" Namespace="Microsoft.Saturn.Framework.Web.UI" Assembly="Microsoft.Saturn.Framework, Version=0.5.464.0, Culture=neutral, PublicKeyToken=6f763c9966660626" %> <script runat="server"> Function Seleccionar(ByVal codigo As Integer) As System.Data.SqlClient.SqlDataReader Dim connectionString As String = "server='localhost'; trusted_connection=true; Database='aps'" Dim sqlConnection As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(connectionStri ng) Dim queryString As String = "SELECT [aps1].[Familia], [aps1].[Detalle], [aps1].[Cantidad], [aps1].[Fecha compra], [aps1].[Fecha venta], [aps1].[Precio c], [aps1].[Precio v] FROM [aps1] WHERE ([aps1].[Codigo] = @Codigo)" Dim sqlCommand As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand(queryString, sqlConnection) sqlCommand.Parameters.Add("@Codigo", System.Data.SqlDbType.Int).Value = codigo sqlConnection.Open Dim dataReader As System.Data.SqlClient.SqlDataReader = sqlCommand.ExecuteReader(System.Data.CommandBehavi or.CloseConnection) Return dataReader End Function Function l(ByVal numero As Integer) As Integer Dim connectionString As String = "server='localhost'; trusted_connection=true; Database='aps'" Dim sqlConnection As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(connectionStri ng) Dim queryString As String = "UPDATE [aps1] SET [Numero]=@Numero" Dim sqlCommand As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand(queryString, sqlConnection) sqlCommand.Parameters.Add("@Numero", System.Data.SqlDbType.Int).Value = numero Dim rowsAffected As Integer = 0 sqlConnection.Open Try rowsAffected = sqlCommand.ExecuteNonQuery Finally sqlConnection.Close End Try Return rowsAffected End Function Sub Button1_Click(sender As Object, e As EventArgs) DataGrid1.DataSource = Seleccionar(CInt(TextBox2.Text)) DataGrid1.DataBind() Message.Text = "Paso por el boton" End Sub </script> <html> <head> </head> <body> <form runat="server"> <p> <asp:TextBox id="TextBox2" runat="server"></asp:TextBox> Codigo <asp:RequiredFieldValidator id="RequiredFieldValidator1" runat="server" ControlToValidate="TextBox2" ErrorMessage="Falta ingresar"></asp:RequiredFieldValidator> <asp:ValidationSummary id="ValidationSummary1" runat="server" ShowSummary="False" ShowMessageBox="True"></asp:ValidationSummary> </p> <p> <asp:Label id="Message" runat="server"></asp:Label> </p> <p align="center"> <wmx:SqlDataSourceControl id="SqlDataSourceControl1" runat="server" UpdateCommand="UPDATE [aps1] SET [Familia]=@Familia,[Codigo]=@Codigo,[Detalle]=@Detalle,[Cantidad]=@Cantidad,[Fecha compra]=@param5,[Fecha venta]=@param6,[Precio c]=@param7,[Precio v]=@param8 WHERE [Codigo]=@Codigo" SelectCommand="SELECT * FROM [aps1]" AutoGenerateUpdateCommand="False" ConnectionString="server='localhost'; trusted_connection=true; Database='aps'" DeleteCommand=""></wmx:SqlDataSourceControl> </p> <p align="center"> </p> <p align="center"> <asp:Button id="Button1" onclick="Button1_Click" runat="server" Text="Button"></asp:Button> </p> <p align="center"> </p> <p align="center"> <asp:DataGrid id="DataGrid1" runat="server" GridLines="Vertical" BorderStyle="None" BorderWidth="1px" BorderColor="#999999" BackColor="White" CellPadding="3" Width="279px" Height="174px" EditItemIndex="0"> <FooterStyle forecolor="Black" backcolor="#CCCCCC"></FooterStyle> <HeaderStyle font-bold="True" forecolor="White" backcolor="#000084"></HeaderStyle> <PagerStyle horizontalalign="Center" forecolor="Black" backcolor="#999999" mode="NumericPages"></PagerStyle> <SelectedItemStyle font-bold="True" forecolor="White" backcolor="#008A8C"></SelectedItemStyle> <AlternatingItemStyle backcolor="Gainsboro"></AlternatingItemStyle> <ItemStyle forecolor="Black" backcolor="#EEEEEE"></ItemStyle> <Columns> <asp:ButtonColumn Text="Delete" CommandName="Delete"></asp:ButtonColumn> <asp:EditCommandColumn ButtonType="LinkButton" UpdateText="Update" CancelText="Cancel" EditText="Edit"></asp:EditCommandColumn> </Columns> </asp:DataGrid> </p> <p align="center"> </p> <!-- Insert content here --> </form> </body> </html> |
| La zona horaria es GMT -6. Ahora son las 10:50. |
Desarrollado por vBulletin® Versión 3.8.7
Derechos de Autor ©2000 - 2026, Jelsoft Enterprises Ltd.