Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Sep 18, 2005 04:31 PM by Wernand
Member
65 Points
15 Posts
Sep 18, 2005 04:31 PM|LINK
<%
<!
<
</
,
Wernand
Member
65 Points
15 Posts
ASP.NET 2.0 - Updating a database without using CSharp? It can... look at the sample below
Sep 18, 2005 04:31 PM|LINK
Now it's really simple to make...
<%
@ Page Language="C#" Theme="SmokeAndGlass" AutoEventWireup="true" %><%
@ Import Namespace="System.Data" %><!
DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"><
html xmlns="http://www.w3.org/1999/xhtml"><
head runat="server"> <title>Studie</title> <script runat="server"> </script></
head><
body> <form id="form1" runat="server"> <div> <asp:AccessDataSource SelectCommand="SELECT * FROM Employees WHERE EmployeeID=@EmployeeID" DataFile="~/App_Data/Nwind.mdb" ID="FormConn" runat="server" UpdateCommand="UPDATE Employees SET Country=@Country WHERE EmployeeID=@EmployeeID"> <UpdateParameters> <asp:Parameter Name="Country" Type=String /> <asp:ControlParameter Name="EmployeeID" ControlID="MasterGrid" PropertyName="SelectedValue" /> </UpdateParameters> <SelectParameters> <asp:ControlParameter Name="EmployeeID" ControlID="MasterGrid" PropertyName="SelectedValue" /> </SelectParameters> </asp:AccessDataSource> <asp:AccessDataSource ID="MasterConn" DataFile="~/App_Data/Nwind.mdb" SelectCommand="SELECT EmployeeID, Firstname, Lastname FROM employees" runat="server"></asp:AccessDataSource> <asp:GridView Width="400px" DataKeyNames="EmployeeID" AllowPaging="true" AutoGenerateSelectButton="true" ID="MasterGrid" runat="server" DataSourceID="MasterConn"> </asp:GridView> <br /> <asp:FormView BorderColor="lightGray" BorderStyle="Solid" BorderWidth="3px" ID="EmpDetails" AllowPaging="true" DataSourceID="FormConn" runat="server"> <ItemTemplate> <table width="400px" style="border: solid 1px black;"> <tr> <td bgcolor="yellow" width="50px" align="center"> <b><%
# Eval("EmployeeID") %> </b> </td> <td bgcolor="yellow"> <b><%
# Eval("Lastname") %>,
<%# Eval("Firstname") %></b> </td> </tr> </table> <table width="400px" style="font-family: Verdana; font-size: 8pt"> <tr> <td valign="top"> <b>Country</b></td> <td><%
# Eval("Country") %> </td> </tr> <tr> <td valign="top"> <b>Hired</b></td> <td><%
# Eval("hiredate", "{0:d}") %> </td> </tr> <tr> <td valign="top"> <b>Notes</b></td> <td style="text-align: justify"><%
# Eval("notes") %> </td> </tr> </table> <asp:Button CommandName="Edit" ID="Button1" runat="server" Text="Edit" /> </ItemTemplate> <PagerStyle BackColor="lightblue" /> <PagerSettings Mode="NextPreviousFirstLast" FirstPageImageUrl="~/Images/first.GIF" PreviousPageImageUrl="~/Images/prev.GIF" NextPageImageUrl="~/Images/next.gif" LastPageImageUrl="~/Images/last.GIF" /> <EditItemTemplate> <table width="400px" style="border: solid 1px black;"> <tr> <td bgcolor="yellow" width="50px" align="center"> <b> <asp:TextBox ID="Textbox1" runat="server" Text='<%# Eval("employeeid") %>' /></b></td> <td bgcolor="lightyellow"> <b><%
# Eval("lastname") %>,
<%
# Eval("firstname") %> </b> </td> </tr> </table> <table width="400px" style="font-size: 8pt; font-family: Verdana;"> <tr> <td> <b>Country</b></td> <td> <asp:DropDownList runat="Server" ID="countries" SelectedValue='<%# Bind("country") %>'> <asp:ListItem>UK</asp:ListItem> <asp:ListItem>USA</asp:ListItem> <asp:ListItem>Italy</asp:ListItem> <asp:ListItem>Australia</asp:ListItem> <asp:ListItem>Netherlands</asp:ListItem> </asp:DropDownList> </td> </tr> <tr> <td valign="top"> <b>Hired</b></td> <td> <asp:Calendar runat="Server" ID="Hired" VisibleDate='<%# Eval("hiredate") %>' SelectedDate='<%# Bind("hiredate") %>' /> </td> </tr> <tr> <td valign="top"> <b>Notes</b></td> <td> <asp:TextBox runat="Server" ID="notes" TextMode="MultiLine" Width="100%" Rows="5" Text='<%# Bind("notes") %>'> </asp:TextBox> </td> </tr> </table> <br /> <asp:Button ID="Button2" runat="server" Text="Cancel" CommandName="Cancel" /> <asp:Button ID="Button3" runat="server" Text="Update" CommandName="Update" /> </EditItemTemplate> </asp:FormView> </div> </form></
body></
html>