How to add saving feture to this asp.net form

**tony007** · May 6th, 2005, 07:30 AM

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>

**Musician** · May 11th, 2005, 06:58 AM

Read this series of articles to learn almost everything there is to know on Datagrids - http://aspnet.4guysfromrolla.com/articles/040502-1.aspx

Thread: How to add saving feture to this asp.net form

Thread Tools

Display

How to add saving feture to this asp.net form

Re: How to add saving feture to this asp.net form

Posting Permissions