How to add saving feture to this asp.net form

autopost · Jan 11, 2008

Hi Experts.I am new to asp.net and i need help in how to add saving feture to this code. either in same page or next page with confirmation by clicking the update all button.I be happy if some one show me show me how i can update a single row .Thanks

<%@ Page enableViewState="False" Language="VB" debug="true"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OLEDB" %>

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

<script language="vb" runat="server">
Sub Page_Load(Sender As Object, E as EventArgs)
Dim objConnection As OleDbConnection
Dim objCommand As OleDbDataAdapter
Dim strConnect As String
Dim strCommand As String
Dim DataSet1 As New DataSet

strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;"
strConnect += "Data Source=C:\Inetpub\wwwroot\"
strConnect += "db\"
strConnect += "\db.mdb;"
strConnect += "Persist Security Info=False"

Response.Write("Viewing Player Record No:" +Request.QueryString("person_id")+"")

strCommand = "SELECT * FROM PENALTIES where playerno = " +Request.QueryString("person_id")+";"
objConnection = New OleDbConnection(strConnect)
objCommand = New OleDbDataAdapter(strCommand, objConnection)
objCommand.Fill(DataSet1, "players")
DataGrid1.DataSource=DataSet1.Tables("players").DefaultView
DataGrid1.DataBind()

'second select

end sub

</script>

<html>
<head>
<title>Data Grid Control example</title>
</head>
<body>

<form runat="server">
<asp:label id="lblUpdateResults" Font-Bold="True" runat="server" />
<p>

<asp:datagrid id="DataGrid1" runat="server"
AutoGenerateColumns="False"
HeaderStyle-HorizontalAlign="Center"
HeaderStyle-BackColor="Red"
HeaderStyle-ForeColor="White"
HeaderStyle-Font-Bold="True"
HeaderStyle-Font-Name="Verdana"
AlternatingItemStyle-BackColor="#dddddd"
ItemStyle-Font-Name="Verdana"

DataKeyField="PLAYERNO">

<Columns>

<asp:TemplateColumn HeaderText="PAYMENTNO">
<ItemTemplate>
<asp:TextBox runat="server" id="PAYMENTNO"
Text='<%# Container.DataItem("PAYMENTNO") %>' />
</ItemTemplate>
</asp:TemplateColumn>

<asp:BoundColumn DataField="PLAYERNO" ItemStyle-Width="10%"
ItemStyle-HorizontalAlign="Center" HeaderText="Playerno" />

<asp:TemplateColumn HeaderText="PEN_DATE">
<ItemTemplate>
<asp:TextBox runat="server" id="PEN_DATE"
Text='<%# Container.DataItem("PEN_DATE") %>' />
</ItemTemplate>
</asp:TemplateColumn>

<asp:TemplateColumn HeaderText="AMOUNT">
<ItemTemplate>
<asp:TextBox runat="server" id="AMOUNT"
Text='<%# Container.DataItem("AMOUNT") %>' />
</ItemTemplate>
</asp:TemplateColumn>

<asp:EditCommandColumn
HeaderText = "Update All"
EditText = "Update"
CancelText = "Cancel"
UpdateText = "Update"

/>

</Columns>
</asp:datagrid>

</form>

<br>

</body>
</html>

How to add saving feture to this asp.net form

autopost

Guest