Hola necesito borrar un registro de la base de datos que estoy realizando con asp y cuando genero toda la hoja y todo no borra, todo el codigo es:
<%@ 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 borrararticulo(ByVal Numero As Integer) As Integer
Dim connectionString As String = "server='localhost'; trusted_connection=true; Database='art'"
Dim sqlConnection As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(connectionStri ng)
Dim queryString As String = "DELETE FROM [Artic] WHERE ([Artic].[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)
If borrararticulo(Numero.Text) > 0
Message.Text = "Success"
Else
Message.Text = "Failure"
End If
End Sub
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<p>
Numero<asp:TextBox id="Numero" runat="server"></asp:TextBox>
</p>
<p>
Codigo<asp:TextBox id="Txtcod" runat="server"></asp:TextBox>
</p>
<p>
<asp:Label id="Message" runat="server"></asp:Label>
</p>
<p>
<asp:Button id="Button1" runat="server" Text="Borrar"></asp:Button>
</p>
<p>
<wmx:SqlDataSourceControl id="SqlDataSourceControl1" runat="server" UpdateCommand="UPDATE [Artic] SET [Codigodearticulo]=@param1,[Detalle]=@Detalle,[Stock]=@Stock,[StockMinimo]=@param4 WHERE [Codigodearticulo]=@param5" SelectCommand="SELECT * FROM [Artic]" AutoGenerateUpdateCommand="False" ConnectionString="server='localhost'; trusted_connection=true; Database='art'" DeleteCommand=""></wmx:SqlDataSourceControl>
<wmx:MxDataGrid id="MxDataGrid1" runat="server" DataSourceControlID="SqlDataSourceControl1" BorderColor="#CCCCCC" AllowSorting="True" AutoGenerateFields="False" DataMember="Artic" AllowPaging="True" BackColor="White" CellPadding="3" DataKeyField="Codigo de articulo" BorderWidth="1px" BorderStyle="None">
<PagerStyle horizontalalign="Center" forecolor="#000066" backcolor="White" mode="NumericPages"></PagerStyle>
<FooterStyle forecolor="#000066" backcolor="White"></FooterStyle>
<SelectedItemStyle font-bold="True" forecolor="White" backcolor="#669999"></SelectedItemStyle>
<ItemStyle forecolor="#000066"></ItemStyle>
<Fields>
<wmx:BoundField DataField="Numero" SortExpression="Numero" HeaderText="Numero"></wmx:BoundField>
<wmx:BoundField DataField="Codigo de articulo" SortExpression="Codigo de articulo" HeaderText="Codigo de articulo"></wmx:BoundField>
<wmx:BoundField DataField="Detalle" SortExpression="Detalle" HeaderText="Detalle"></wmx:BoundField>
<wmx:BoundField DataField="Stock" SortExpression="Stock" HeaderText="Stock"></wmx:BoundField>
<wmx:BoundField DataField="Stock Minimo" SortExpression="Stock Minimo" HeaderText="Stock Minimo"></wmx:BoundField>
</Fields>
<HeaderStyle font-bold="True" forecolor="White" backcolor="#006699"></HeaderStyle>
</wmx:MxDataGrid>
</p>
<!-- Insert content here -->
</form>
</body>
</html>
