ASP

asp.net problème de datagrid et command Delete

Recherche :

Mot : Pseudo : Filtrer
Bas de page
Auteur	Sujet : asp.net problème de datagrid et command Delete

lordankou

voilà je ne comprends pas pourquoi le code correspondant à la commande delete ne s'exécute pas.
j'ai beau regarder sur des codes sources et je ne vois pas mon erreur (la page s'éxécute et quand je clique sur le bouton delete rien ne se passe).

Code :

<%@ Page Language="VB" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
<script runat="server">
' Insert page code here
'
' function executed when the page is loaded
sub Page_Load(Sender as Object, E as eventArgs)
' check if the page is already load
if Not Page.isPostBack then
linkData()
end if
end Sub
' function to load the list of postgraduate
sub linkData()
' variable declaration
Dim aConnection As OleDbConnection = new OleDbConnection ' Object to allow a connection between Database and the programm
Dim aDataAdapter as OleDbDataAdapter = new OleDbDataAdapter ' Object to send the command and retrieve data
Dim aDataSet as DataSet = new DataSet ' store informations retrieved from a table
Dim configurationDatabase, querySQL as String ' store the configuration of database and query string
' init value
configurationDatabase = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _
& server.mappath("..\database\postgraduate_Student_Manager.mdb" ) ' define the type of database and path to the file
' insert group num
querySQL = "Select * from Postgraduate"
' set value
aConnection.ConnectionString = configurationDatabase ' apply configuration
aDataAdapter.selectCommand = new OleDbCommand(QuerySQL,aConnection)
aDataAdapter.SelectCommand.Connection.Open ' open the connection
aDataAdapter.Fill(aDataSet,"results" ) ' apply the results in dataset called "Results"
listPostgraduate.DataSource = aDataSet.Tables("Results" ) ' set the datasource of the datagrid with the results
Page.DataBind() ' bind the datagrid to the table "result"
end sub
Sub Delete(Sender As Object, e As DataGridCommandEventArgs)
Response.Redirect("departmentCreatePostgradeAccount.aspx" )
end sub
</script>
<html>
<head>
<link href="../commonSourceFiles/css/theme1.css" type="text/css" rel="stylesheet" />
</head>
<body>
<div class="background">
<form runat="server">
<div class="log">you are logged as
<br />
Doudoune ( <a class="logout" href="">logout</a> )
</div>
<div class="Menu">
<table style="WIDTH: 579px; HEIGHT: 29px">
<tbody>
<tr>
<td>
<a class="MenuLien" href="departmentCreatePostgradeAccount.aspx">Postgraduate</a>
</td>
<td>
<a class="MenuLien" href="departmentAssignTimetable.aspx">Timetable-coordinator</a>
</td>
<td>
<a class="MenuLien" href="departmentCreateFacultyAccount.aspx">Faculty Members - Supervisor</a>
</td>
<td>
<a class="MenuLien" href="departmentCreateRoom.aspx">Room</a>
</td>
<td>
<a class="MenuLien" href="departmentDiversReport.aspx">Divers</a>
</td>
</tr>
</tbody>
</table>
</div>
<div class="subMenu">
<br />
<div class="subSubMenu">Actions for postgradutes
</div>
<br />
<a href="departmentCreatePostgradeAccount.aspx">create
<br />
postgraduate<br />
account </a>
<br />
<br />
<a href="departmentModifyPostgradeAccount.aspx">modify
<br />
postgraduate
<br />
account </a>
<br />
<br />
<a href="departmentDeletePostgradeAccount.aspx">delete
<br />
postgraduate
<br />
account </a>
</div>
<div class="corps"><span class="corpsTitle">Delete a postgraduate account</span>
<br />
<br />
<br />
<asp:Label id="title" runat="server">List of postgraduate :</asp:Label>
<br />
<br />
<br />
<ASP:DataGrid id="listPostgraduate" runat="Server" AllowPaging="True" Font-size="11pt" Font-name="Times new roman" pagerStyle-PrevPageText=" <-- Previous" pagerStyle-NextPageText=" Next -->" backcolor="#DDDDDD" border="1" autoGenerateColumns="False" Font-Names="Times new roman" CellPadding="5" BorderWidth="2px" BorderStyle="Ridge" BorderColor="DarkSlateGray" AllowSorting="True" HorizontalAlign="Center" ForeColor="Black" PageSize="15">
<HeaderStyle font-bold="True" wrap="False" horizontalalign="Center" height="16px" forecolor="White" borderstyle="Inset" verticalalign="Middle" backcolor="Gray"></HeaderStyle>
<PagerStyle verticalalign="Middle" nextpagetext=" Next >>" font-bold="True" prevpagetext=" << Previous" horizontalalign="Center" forecolor="White" backcolor="Gray"></PagerStyle>
<SelectedItemStyle backcolor="#FFC0C0"></SelectedItemStyle>
<AlternatingItemStyle horizontalalign="Center" verticalalign="Bottom" backcolor="White"></AlternatingItemStyle>
<ItemStyle horizontalalign="Center" verticalalign="Middle" backcolor="#E0E0E0"></ItemStyle>
<Columns>
<asp:BoundColumn DataField="ID" HeaderText="IdColumn"></asp:BoundColumn>
<asp:HyperLinkColumn Text="First Name Text" DataTextField="FirstName" HeaderText="First Name"></asp:HyperLinkColumn>
<asp:HyperLinkColumn Text="Last Name Text" DataTextField="LastName" HeaderText="Last Name"></asp:HyperLinkColumn>
<asp:ButtonColumn Text="Delete" ButtonType="PushButton" CommandName="Delete"></asp:ButtonColumn>
</Columns>
</ASP:DataGrid>
</div>
</form>
</div>
<div class="lastModif">Copyright © 2006 - last modification 7 March, 2006 - University
of Limerick
<br />
<a href="mailto:webmastere@ul.ie">webmaster</a>
<p>
<a href="http://jigsaw.w3.org/css-validator/validator?uri=http://localhost/theme1.css"><img style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; WIDTH: 88px; BORDER-BOTTOM: 0px; HEIGHT: 31px" alt="Valid CSS!" src="http://jigsaw.w3.org/css-validator/images/vcss" /> </a>
</p>
</div>
</body>
</html>

Si quelqu'un pouvait m'aider ça serait sympa car là je bloque totalement.

Publicité

FORUM HardWare.fr

Programmation

ASP

asp.net problème de datagrid et command Delete

Sujets relatifs
problème de lien de messagerie	problème case à cocher et bouton radio
Problème avec MAXLENGTH	Probleme incompréhensible ou j'ai du mal
Probleme de relation entre tables	problème conception table (problème clé primaire)
Problème de lien pop up qui change page de base :s	Problème sur mon ftp !
problème avec une ouverture de ficheir texte	Problème pour passer d'une page à une autre sur forum phpbb
Plus de sujets relatifs à : asp.net problème de datagrid et command Delete

Page générée en 0.098 secondes