Hi All,
See the code for UpdateCommand. This is almost similar to Delete command.
If you have more fields in the table to update then the UpdateCommand in the code will look like
UpdateCommand="UPDATE HUPTable SET HUPPass = @HUPPass,HUPAddress=@HUPAddress WHERE HUPName = @HUPName"
Code starts here
---------------------------------------------------------------------------------
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Main.aspx.vb" Inherits="Main" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
Welcome to Admin Home
</div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" DataKeyNames="HUPName">
<Columns>
<asp:BoundField DataField="HUPName" HeaderText="HUPName"
SortExpression="HUPName" />
<asp:BoundField DataField="HUPPass" HeaderText="HUPPass"
SortExpression="HUPPass" />
<asp:CommandField ShowDeleteButton="True" />
<asp:CommandField ShowEditButton="True" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
UpdateCommand="UPDATE HUPTable SET HUPPass = @HUPPass WHERE HUPName = @HUPName"
SelectCommand="SELECT [HUPName],[HUPPass] FROM [HUPTable]"
DeleteCommand="Delete from HUPTable where HUPName=@HUPName" >
<DeleteParameters>
<asp:Parameter Name="HUPName" Type="String" />
<asp:Parameter Name="HUPPass" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="HUPName" Type="String" />
<asp:Parameter Name="HUPPass" Type="String" />
</UpdateParameters>
</asp:SqlDataSource>
</form>
</body>
</html>
See the code for UpdateCommand. This is almost similar to Delete command.
If you have more fields in the table to update then the UpdateCommand in the code will look like
UpdateCommand="UPDATE HUPTable SET HUPPass = @HUPPass,HUPAddress=@HUPAddress WHERE HUPName = @HUPName"
Code starts here
---------------------------------------------------------------------------------
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Main.aspx.vb" Inherits="Main" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
Welcome to Admin Home
</div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" DataKeyNames="HUPName">
<Columns>
<asp:BoundField DataField="HUPName" HeaderText="HUPName"
SortExpression="HUPName" />
<asp:BoundField DataField="HUPPass" HeaderText="HUPPass"
SortExpression="HUPPass" />
<asp:CommandField ShowDeleteButton="True" />
<asp:CommandField ShowEditButton="True" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
UpdateCommand="UPDATE HUPTable SET HUPPass = @HUPPass WHERE HUPName = @HUPName"
SelectCommand="SELECT [HUPName],[HUPPass] FROM [HUPTable]"
DeleteCommand="Delete from HUPTable where HUPName=@HUPName" >
<DeleteParameters>
<asp:Parameter Name="HUPName" Type="String" />
<asp:Parameter Name="HUPPass" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="HUPName" Type="String" />
<asp:Parameter Name="HUPPass" Type="String" />
</UpdateParameters>
</asp:SqlDataSource>
</form>
</body>
</html>
No comments:
Post a Comment