I'm back...
This is what I'm trying to achieve:
|
Month
|
|
|
Current Month
|
Month
|
Total
|
|
4/3/2009
|
|
|
$00.00
|
Jan
|
$0.00
|
|
4/17/2009
|
|
|
$00.00
|
Feb
|
$0.00
|
|
5/1/2009
|
|
|
$00.00
|
Mar
|
$0.00
|
|
5/15/2009
|
|
|
$00.00
|
Apr
|
$0.00
|
|
5/29/2009
|
|
|
$00.00
|
May
|
$0.00
|
|
6/12/2009
|
|
|
$0.00
|
Jun
|
$0.00
|
|
6/26/2009
|
|
|
$0.00
|
July
|
$0.00
|
|
7/10/2009
|
|
|
$0.00
|
Aug
|
$0.00
|
|
|
|
|
Sept
|
$0.00
|
|
|
|
|
Oct
|
$0.00
|
|
|
|
|
Nov
|
$0.00
|
|
|
|
|
Dec
|
$0.00
|
I want to be able to add
50.00 next to 4/2/2009 Under the current month column
and
20.00 next to 4/17/2009
I would like the total of 70.00 to go under the total column next to the April section.
I have the above set up but I had to use two gridviews to get the month's listed. Here are the gridview's:
<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" AutoGenerateColumns="False" Width="103px" Font-Names="Calibri">
<Columns>
<asp:BoundField DataField="Dates" HeaderText="PPE Date" SortExpression="Dates" />
<asp:TemplateField HeaderText="Amount">
<
ItemTemplate>
<
asp:TextBox ID="TextBox1" runat="server" Width="99px"></asp:TextBox>
</ ItemTemplate>
</
asp:TemplateField>
</
Columns>
</asp:GridView>
</td>
<td style="width: 100px">
<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource2">
<Columns>
<
asp:BoundField DataField="MonthVal" HeaderText="MonthVal" ReadOnly="True" SortExpression="MonthVal" Visible="False" />
<asp:BoundField DataField="MonthName" ReadOnly="True" SortExpression="MonthName" />
<asp:TemplateField HeaderText="Total">
<
ItemTemplate>
<
asp:TextBox ID="TextBox6" runat="server" Width="69px"></asp:TextBox>
</
ItemTemplate>
</
asp:TemplateField>
</Columns>
</asp:GridView>
Is this possible to be able to calculate in one gridview and display the answer in the other gridview or should I use a label?