Salut,
je voudrais suprimer une ligne sur un base de donnée access
la base contient ( Nom ; Genre ; ID ).Je cherche à gerer cette base sans utiliser ODBC.
Est ce que quelq'un peu m'aider à améliorer ce prog pour supprimer une ligne de ma table.
Merci.
Voivi le code
<%@ Page Language="VB" Debug="true" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
<script runat="server">
'Définir la connexion
dim objConn as new OleDbConnection _
("Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Inetpub\wwwroot\Test\abcd.mdb")
sub Page_Load(obj as Object, e as EventArgs)
'Ouvrir la connexion
dim objCmd as new OleDbDataAdapter _
("select * from TabMovie", objConn)
'Slectionner les donnes
dim ds as DataSet = new DataSet()
objCmd.Fill(ds, "TabMovie")
'Afficher les donnes et les lier un contrle serveur
MyDataList.DataSource = ds.Tables("TabMovie"). _
DefaultView
MyDataList.DataBind()
'Supprimer les donnes
end sub
sub Submit_Click(obj as object, e as EventArgs)
Label1.Text =""
if tbName.Value <> ""
Session("Name") = tbName.Value
dim strSQL as string = "DELETE * FROM TabMovie " & " WHERE Nom = " & Session("Name")
Label1.TEXT += "Vous avez supprimer le film " & Session("Name")
ExecuteStatement(strSQL)
else
Label1.Text += "Vous n'avez pas donn de film ...." & "<p>"
end if
end sub
function ExecuteStatement(strSQL)
dim objCmd as new OleDbCommand(strSQL, objConn)
try
objCmd.Connection.Open()
objCmd.ExecuteNonQuery()
catch ex as Exception
lblMessage.Text = "Erreur de mise jour"
objCmd.Connection.Close()
end try
objCmd.Connection.Close()
end function
Sub MyDataList_SelectedIndexChanged(sender As Object, e As EventArgs)
End Sub
</script>
<html>
<head>
</head>
<body>
<ASP:DataList id="MyDataList" runat="server" RepeatColumns="1" OnSelectedIndexChanged="MyDataList_SelectedIndexChanged" BorderWidth="1px" BorderColor="Tan" BackColor="LightGoldenrodYellow" CellPadding="2" ForeColor="Black">
<FooterStyle backcolor="Tan"></FooterStyle>
<HeaderStyle font-bold="True" backcolor="Tan"></HeaderStyle>
<SelectedItemStyle forecolor="GhostWhite" backcolor="DarkSlateBlue"></SelectedItemStyle>
<ItemTemplate>
<div style="padding:15,15,15,15;font-size:10pt;
font-family:Verdana">
<div style="font:12pt verdana;color:darkred">
<i><b><%# DataBinder.Eval(Container.DataItem, "Nom")%> </b></i></b>
</div>
<br />
<b>Genre : </b><%# DataBinder.Eval(Container.DataItem, "Genre") %>
<br />
<p></p>
</div>
</ItemTemplate>
<AlternatingItemStyle backcolor="PaleGoldenrod"></AlternatingItemStyle>
</ASP:DataList>
<form runat="server">
Merci de donner le nom du Film a supprimer :
<input id="tbName" type="text" runat="server" />
<p>
<asp:Button id="btSubmit" onclick="Submit_Click" runat="server" text="Envoyer"></asp:Button>
</p>
<p>
<asp:Label id="Label1" runat="server"></asp:Label>
</p>
<p>
<asp:Label id="lblMessage" runat="server"></asp:Label>
</p>
</form>
</body>
</html>