View Complete Post
I have a <asp:DetailsView> based on a table that has a details table, like so:
DB1 --> TABLE1 --> Customers: ID, name, street, mail
DB1 --> TABLE2 --> SitesToCustomers: CustomerID, SiteID
Problem One: I need my details view to show / edit both values from customer table and SitesToCustomers table, How do i do that?
Problem two: The site name (oppesed to its code that is saved at SitesToCustomers) is found on another DataBase in this table:
DB2 --> TABLE1 --> Sites: ID, SiteName
How can make the data source show site names according to their id's from SitesToCustomers table?
all of the code behind is c#.
Any help will be much appreciated,
and please use code examples, i'm pretty new to asp.net / c#.
My requirement is something like this:
In a Task Approval form, I want to have a view which shows all the rows in a particular SQL table (in a infopath repeating table?). Along with each row, there should also be a button, on clicking which the row should disappear
from the infopath view table. Do you think InfoPath can handle all this? :)
1. How do I add rows to a table dynamically?
2. Per row, how do I create a button dynamically?
3. How do I remove the row from the view when the button is clicked?
into ReportDetail( Partcipantid, Reportid)
, 9 from OpenCredit
except select ParticipantID, 9
from StoreCredit where Closed
Issue is that when above select statement returns no row, it seems like no record is
Can any one shade some light on achieving "Table header should remain visible when no rows found ?