How to add saving feture to this asp.net form
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>
Re: How to add saving feture to this asp.net form
Read this series of articles to learn almost everything there is to know on Datagrids - http://aspnet.4guysfromrolla.com/articles/040502-1.aspx
