Hi Imar,
Thanks for your reply, what I have is a GridView with ItemTemplate is the default view. In the ItemTemplate, I replaced the 2 default labels with 2 TextBoxes Quantity, and UnitPrice, and added one TextBox SubTotal in VisualStudio 2005. The reason for adding the TextBoxes is to allow user can change the Quantity, so the SubTotal will change to Quantiy * UnitPrice using JavaScript OnChange event. We know there are four columns, but we don't know how many rows the GridWiew will retrieve from the database. Followings are the ASPX and HTML source files:
===========default2.apsx source file =====
<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="ORDERID" HeaderText="ORDER ID" SortExpression="ORDERID" />
<asp:TemplateField HeaderText="QUANTITY" SortExpression="QUANTITY">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("QUANTITY") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("QUANTITY") %>'></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Unit Price" SortExpression="UnitPrice">
<EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("UnitPrice") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:TextBox ID="TextBox5" runat="server" Text='<%# Bind("UnitPrice") %>'></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Sub Total" SortExpression="SubTotal">
<EditItemTemplate>
<asp:TextBox ID="TextBox3" runat="server" ></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:TextBox ID="TextBox6" runat="server"></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString3 %>"
ProviderName="<%$ ConnectionStrings:ConnectionString3.ProviderName %>" SelectCommand='SELECT "ORDERID", "QUANTITY", "UnitPrice" FROM "ORDERDETAIL"'>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
======================== HTML View Source file with 4 columns and 2 rows ==========================
<!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><title>
Untitled Page
</title></head>
<body>
<form name="form1" method="post" action="Default2.aspx" id="form1">
<div>
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwULLTE0NTU4NjI2NDkPZBYCAgQPZBYCAgEPPCsADQEADxY GHgtfIURhdGFCb3VuZGceCVBhZ2VDb3VudAIBHgtfIUl0ZW1Db 3VudAICZBYCZg9kFgYCAQ9kFghmDw8WAh4EVGV4dAUFMTAwMDJ kZAIBDw8WAh8DBQExZGQCAg8PFgIfAwUDRFZEZGQCAw8PFgIfA wUBUmRkAgIPZBYIZg8PFgIfAwUFMTAwMjBkZAIBDw8WAh8DBQE xZGQCAg8PFgIfAwUDRFZEZGQCAw8PFgIfAwUBVWRkAgMPDxYCH gdWaXNpYmxlaGRkGAEFCUdyaWRWaWV3MQ9nZA55ctqtE4EUX0/4Z0c4ARkiZFUF" />
</div>
<div>
<div>
<table cellspacing="0" rules="all" border="1" id="GridView1" style="border-collapse:collapse;">
<tr>
<th scope="col">ORDER ID</th><th scope="col">QUANTITY</th><th scope="col">Unit Price</th><th scope="col">Sub Total</th>
</tr><tr>
<td>10002</td><td>0</td><td>5</td><td>0</td>
</tr><tr>
<td>10020</td><td>0</td><td>6</td><td>0</td>
</tr>
</table>
</div>
</div>
</form>
</body>
</html>
How to change the value of one cell in a GridView?
