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>
