Code to automatically caculate a field value, is not displaying the calculated value in the footer row
Hello, I am using the code below to automatically caculate TotalHoursPerUnit after I click the edit button and enter a number in the HeoursPerUnit & PeoplePerUnit fields.  I added a footer row to the Gridview and updated GridView1_RowDataBound to automatically caculate the TotalHoursPerUnit footer row textbox NewTotalHoursPerUnit in the footer row, but no luck.  I do not get an errors.  Any suggestions? aspx page <%@ Page Language="VB" MasterPageFile="~/MembersDefault.master" AutoEventWireup="false" CodeFile="frmHR.as...

Reduce rows displayed but putting 3 rows in one row
Hi all, I'm using PB6.5. I have an SQL DW that fetch some information from the DB but should display only two columns: a code and a value. Also they are displayed in the trailer of a group if that's actually important. In order to reduce displayed rows count, i would like to display each 3 rows in one row(Code,Value,Code,Value,Code,Value). The question is how can i do that?. I've tried to use computed fields and in the second and third pair values to use code[1],value[1],code[2],value[2] but only the code[1],value[1] are OK(Showing next row's data), the third ...

First Row, Next Row, Prior Row, Last Row
I have a SQL Anywhere 7.0 Database, have a table Product_detail which contains Column Name Datatype width Null Default batch_id char(10) No None prod_id Integer No None employee_id Integer No None quantity Integer No None price Numeric (14, 2) No None Its primary key is batch_id I have a Freeform Datawindow with this table I want to provide the first row, next row, prior row and last row Ho...

select the row of the datagrid whose value is same as one of the value of row of datagrid
hellow all,  I have a datagrid which is bound to the ordertable,so all the orderdetails are shown on the page load. but my requirement is that,i have a textbox and a search button,when the user enter the order number in the text box and click on the search button the datagrid should show that record whose order number is entered by the user n most imp that the record may be in the 65th or 34th row of the datagrid,i wants to put it in the first row. how to do it. If there's a reason you can't filter down to just the one row, you'll have to come up with some paging algorithm that wil...

How do i get one row if the resultset returned has no rows.
Hi I have couple of CTE's which i want to ultimately insert into a temp table... and based on my condition some of the CTE's return some rows and some dont... but i want to have the CTE return atleast one row if there is no data in it.. I have tried doing the following but i am not getting the desired output    ;with cte_rpt4 as (select '4' a,recd_dt as approve_dt, prov_no, prov_name, client_id, claim_mst_id, claim_adj_id, claim_dt, claim_amt, rpt4, (Select count(distinct(Claim_mst_Id)) as crpt4 from #temp1 where datediff(day,isnull(recd_dt,create_dt),isnull(c...

Get next row values
Hello, I would like to get the values present in the next row depending on which row is currently being edited.  How would I begin doing that? When you are in the process of editing, you'll have the current EditIndex. With this, you can retrieve the row for that index plus one. Once you have a reference to the row, you can extract the values from it.Thanks, EdMicrosoft MVP - ASP/ASP.NET...

DetailView (Header in one Row and Item or Value in other Row)
My second question is, how can I put header in one row and ItemValue in other row. Currently the detail view is showing data as following structure: FieldName:         FieldValueFieldName:         FieldValueFieldName:         Listitem1                           Listitem2            &nbs...

Display data in one row with many child rows
Hi all, Could i display data like this :                             DetailPerson        Column 1       Column 2                   name 1         address 1person 1      age 1         &nbs...

Displaying 2 rows as one row in GridView--very urgent
Hi I need to display 2 rows as a one row in Gridview like this in text boxes and also I need horizontal paging on the gridview... any help would be much appreciated !!! ---------------------------------------------------------<<  Jan| Feb| Mar| Apr| May| Jun| Jul|   >>---------------------------------------------------------  A  10 |  20 |  30 |  40 |  50 |  60 |  70 |  B  10 |  20 |  30 |  40 |  50 |  60 |  70 |&...

How to get the row index of a selected row in listview control
Can someone please tell me how to get the index of a selected row in a listview.  <ItemTemplate> <asp:LinkButton runat="server" class="linkButton" id="xxxxx" Text='<%#Eval("documenttype") %>' CommandName="OpenFile" CommandArgument='<%#Eval("DocumentKey") %>'></asp:LinkButton></ItemTemplate>what you have to do is, in itemcommand event of ListView, you have to get the value of row indexif(e.CommandName == "corrospondingcommaandname"){     &nb...

Compare the last in one row with the first in the next row
--____QVLZYPRMMGJPQCYPSFRH____ Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable In our timecard datawindow, I want to highlight where there are 'gaps'. 1/1/08 08:00 1/1/08 11:00 1/1/08 12:00 1/1/08 05:00 I want the 12:00 to be highlighted because it isn't the same as the second = datetime in the previous row. Can someone help me with some script for this? --____QVLZYPRMMGJPQCYPSFRH____ Content-Type: multipart/related; boundary="____RNQEGPGXMIMQCYOCQRWY____" --____RNQEGPGXMIMQCYOCQRWY____ Content-Type: tex...

ADO.net problem: i can not view image data for the rest of my table rows except the image for the first row but i can read all the other non image fields for all rows.
Hi i have a table with the following fields imgid............int imgdata........image imgtitle.........varchar(max) imgType........varchar(max) imgLength.....bigint incident_id.....int i have no problem with uploading the image but viewing the uploaded image(s) in a gridview has caused me great pain. The probelm is i have two pages. page1 grabs the image to display and page2 has a gridview that displays the grabed image. I wanted to have an sql statement like SELECT * FROM mytable WHERE incident_id=someValue. IF i have 5 records in this table and i view page2 ...

Add new controls to a gridview row; when editing that row using the edit row feature in the gridview control.
Hi all  I have a questions that looks hard / complex to me, and i know you can help me in this. Q {  I have row in a Gridview and i have an edit option to it. I press the edit button, to edit the values in that row and update data all the way back to the database. Now when i press the edit button, i want a drop down list to be displayed that contain values for a particular field in my grid view. (for now only plain text boxes appear.) } I hope you understand my question, all i need to do is replace the text box controls with a dropdown list when i am editing a row in ...

Get the value of any rows into a DetailsView control:
Hi all, I would like to catch the value of a row for a specific row of a detailsview control. I am using a command field which is raised with the OnItemCommand="ChangeRole_Click" property of my DetailsView. I am trying to reach the content of this detailsview by doing somthing like this: void ChangeRole_Click(object sender, DetailsViewCommandEventArgs e) { string recupRole = ((DetailsView)sender).Rows[0].ToString(); Response.Write(recupRole); } But it doesn't work :( Someone could help ? Thanks in advance Benjamin I ha...