asp.net problème de datagrid et command Delete

Marsh Posté le 21-03-2006 à 00:18:47

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.

Marsh Posté le 21-03-2006 à 00:18:47

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed

Name *

Email *

URL

Message *