have a gridview inside a formview is it possible to show running totals in the gridviews footer section? the gridview is populated with two parameters outside of the formview. Im using .vb
View 2 Replies
I have an ObjectDataSource giving me data similar to: OrderNumber OrderDate OrderValue OrderItems The first three are simple data types and the last has multiple occurrences of another class: OrderLineNumber OrderItem OrderQuantity The ObjectDataSource will only contain one row (which might make things simpler). So, there will be one OrderNumber, OrderDate and OrderValue; and then several occurrences of OrderItems (each containing OrderLineNumber, OrderItem and OrderQuantity).
I am displaying OrderNumber, OrderDate and OrderValue in the FormView - that work's fine, as expected. I have placed a GridView within the FormView and am failing miserably to get it to bind to OrderItems. I have tried the obvious things like specifying "odsWhatever.OrderItems" as the DataSourceID for the GridView, but to no avail.
Basically as the title of this thread states, I have a FormView that has a GridView inside it and my ObjectDataSource that populates this grid cannot access the Grid.
The Control Id needs to be the name of the Grid I want to access, however through the 'wizard' the Control parameter drop down cannot 'see' the grid I need, only the FormView that is in.
I have tried numerous ways to get round this and am struggling now..
I've tried the following...
ControlID="FormView.GridView1"
ControlID="FormView.FindControl("GridView1")
ControlID="<%= GetNameOfGrid %>"
and numerous other attempts that also failed that I now cant remember...
I have the following (abbreviated) code:
<asp:FormView ID="FormView1" runat="server" DataKeyNames="ItemID" DataSourceID="LinqDataSource1">
<EditItemTemplate>
<asp:DropDownList ID="ddlCategory" runat="server" SelectedValue='<%# Eval("Category") %>'
DataSource="<%# GetCategories() %>" DataTextField="Text" DataValueField="Value" />
</EditItemTemplate>
<ItemTemplate>
<asp:ListView ID="lvParticipants" runat="server" DataSource='<%# Eval("Participants") %>' >
<InsertItemTemplate>
<asp:DropDownList ID="ddlCountry" runat="server" SelectedValue='<%# Eval("Country") %>'
DataSource="<%# GetCountries() %>" DataTextField="Text" DataValueField="Value" />
</InsertItemTemplate>
</asp:ListView>
<ItemTemplate>
</asp:FormView>
When the FormView is in Edit mode, ddlCategory is populated as expected by calling GetCategories(), which returns a List of categories. However, when the ListView is in Insert mode, ddlCountry is empty. I put a break point in GetCountries(), but it never gets called. If I change the name of the method, I get an error. So it recognizes the method at compile time, but does not call it at run time. I'm guessing this is an embedded binding issue of some kind, but I'm hoping someone can save me a lot of time by pointing out the solution.
Is it possible when i select the gridview and it will reveal selected row and retrieve all the data from sql server on popup formview.
Gridview [URL] .....
Formview [URL] .....
In the website I'm building, I have a form that allows new users to register. Part of this page has mandatory address fields, and I use a postcode lookup field which returns a SuburbID and FullSuburbName (Suburb, State & PostCode) to a RadioButtonList inside an UpdatePanel.
[Code]....
I then handle the insert process in codebehind, and all this works perfectly on my New Account page.What I'm trying to do now, however, is replicate this functionality in the Edit Template of a FormView on my Manage Account page. The idea being that the user can view their current details in the ReadOnly view, then switch to Edit view to change their address (amongst other details of course). When the FormView changes to Edit mode, it should display the user's current PostCode in the textbox, and the RadioButtonList should display the available Suburbs for that PostCode, with the user's current SuburbID as the initial SelectedValue. If the user changes the PostCode and hits search, this refreshes the RadioButtonList with the new list of Suburbs, and once they have selected a new SuburbID this should get written back to the DB with the rest of the form (when they click Save I mean), using the SQL Data Source Update element. However, I simply cannot get this to work inside the FormView Edit Template and
So far, I have tried to handle the FormView's ItemCreated event and populate the RadioButtonList with the Suburbs that match the user's current PostCode, but if I do this with SelectedValue='<%# Bind("SuburbID") %>' in the RadioButtonList, I get the error "Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."If I then change it to have the SelectedValue populate from the codebehind, this works on the initial switch to Edit mode, but when the user changes the PostCode and hits search, I get a different error "'rblSuburb' has a SelectedValue which is invalid because it does not exist in the list of items."My thinking was that rather than binding the RadioButtonList I would just add the new SelectedValue in the SQLDataSource_Updating method, but it doesn't seem to like that either.
How do I access a specific control within a FormView's "<InsertItemTemplate>"?
View 2 RepliesI am trying to access accessing a control in a Formview. I have tried several methods, but nothing seems to work
[Code]....
[Code]....
I have added a table to my FormView Edit template for structure and a button that pops up a form for information.
When the button is clicked I want a check box in neighboring cell to become checked. But I am having problems in the VB code behind, establishing the name of the check box to change its state. Its something like this....
FormView1.ItemTemplate.(CheckBox1.Checked = True)
Ok i have a dropdownlist inside a formview.When i select to update the formview the dropdownlist will automatically go to the first item on the list.
Is it possible to keep the item that is currently selected before i go to the update formview page?
I can get the dropdownlist from the formview with Findcontrols but then?
P.S. My dropdownlist is declared inside the formview
[Code]....
So I have tried both the Ajax Control Toolkit (which didn't work -- page didn't even display, got an error message about assemblies not registered.
AND implement use of the JQuery datepicker. Which I do have working OUTSIDE of FormView. Once I put it in FormView it doesn't display. Spent all day on this crap and have absolutely nothing to show for it but a bunch of code that doesn't do what I want it to....grrr...my inadequacies are irritating me (can you tell?)
Any help to get it working inside the Formview and bound to the Date field for my insertemplate. The FormVendorVisit is only used to insert the following fields: vendor_visit_id (identity / pk / not even visible on the formview inserttemplate), vendor_id, time_spent, date(this is where I am running into problems getting a popup calendar to select the date. My "ButtonInsert" in the formview takes care of the rest and works perfectly if I enter a date manually.
Here's my code on my aspx page:
[Code]....
My code behind vb page doesn't have too much in it yet and nothing with the datepicker:
[Code]....
[Code]....
The above code works if there are controls directly inside a update panel. But what if I want to disable a button or a tex box that is inside an Edit template of a formview.. that is in a panel.
[Code]....
im learning webforms and asp.net in general and what i have so far is a formview that displays data being pulled from a sqldatasource, but i also want a checkboxlist that can be used to input information and display information. this checkboxlist is insode the formview. the problem im having is that my formview is calling a datasource with an specific stored procedure with one table and my checkboxlist needs to called another stored procedure that has a different table. formviews does not allow you to have tow different datasources so how can i make this possible? ill paste the front end code and the backend code so you guys can see what im trying to do.
[Code]....
backend:
[Code]....
and my util where the booleans are being set
[Code]....
protected void FormView1_ItemInserted(object sender, FormViewInsertedEventArgs e)
{
// Here I want to make a label "Saved" visible after user inserts the record into the formview.
// the label is in InsertItemTemplate of the formview next to Insert and Cancel Links. It is invisible by default.
// Is this the right event that i am in to do something like this.. if there is any other way to do this,
}
How to write code in vb.net to control the Dropdown which is inside FormView EditItemTemplate. FormView named "frmFaultsReg" DetailsView named "lstStatus" Actually what i want to do that there is a textbox inside FormView EditItemTemplate and ItemTemplate to insert Closing date. lstStatus has a value PENDING and CLOSED. If a user select CLOSED from lstStatus then the date textbox named "ClrDateTimeTextBox" should show current date time and to insert into database and if user again selects PENDING from lstStatus then the date textbox should show empty. I think the postback of lstStatus should work but lstStatus is inside the FormView thats why I am unable to hook it.
View 7 RepliesI am trying to change the textboxes in the FormView insert template to dropdownlists but they keep setting the parameters to null. Here's what I have:
[Code]....
In Page_Load
CType(frmSurvey.FindControl("ddlYearOfQualification"), DropDownList).Items.Add(New ListItem("2010", "2010"))
CType(frmSurvey.FindControl("ddlYearOfQualification"), DropDownList).Items.Add(New ListItem("2009", "2009"))
and in the SqlDataSource
InsertCommand="INSERT INTO [tblSurvey] (... [YearOfQualification] ...) VALUES ( ... @YearOfQualification ... )
And in insert parameters:
<asp:Parameter Name="YearOfQualification" Type="Int16" />
And the insert fails with YearOfQualification as null. If I sue the standard textbox:
<asp:TextBox ID="YearOfQualificationTextBox" runat="server"
Text='<%# Bind("YearOfQualification") %>' />
I keep getting a null reference when I try to access a listbox inside the EditItemTemplate of a formview. I check the mode before accessing the control (Formview1.CurrentMode) to make sure it is in edit mode and even set it manually to edit mode again! But formview1.findcontrol("blah") returns null. Formview1.EditItemTemplate does not have a FindControl method, not sure what else to try.
View 1 RepliesI have a UserControl inside the ItemTemplate of my FormView and I need to access it in order to get an event fired off. As the UserControl is inside the template, my event cannot see it!
View 4 RepliesI am facing a problem with panel inside a fromview...when i am trying to add some to the panel its not working....My code is as follows
[code]...
I tried with the place holder and its worked fine but not with panel...
Is there any way to add CSSClass to a place holder...
I'm using this:
[Code]....
Is there a better way to do it?
I have been searching the net for quite a while and can't find an example of how to put a radiobutton or radiolist inside a formview. I have an objectdatasource that goes back to a table. One field in the table is Hydro -- which is an int field. There are three valid choices:
value Text
0 None
1 15 Amp Service
2 30 Amp Service
When I set my Formview to the objectdatasource my Hyrdo binding looks like this:
[Code]....
How would I change the above so that it would replace the TextBox with either a radiolist or 3 radiobuttons (I am ok with whichever is easier) so that it would look like this
Hydro: o None o 15 Amp o 30 Amp
Also, in the case of the update mode that the correct item is selected based on the value of 0, 1, 2 being read from the datatable
I have a label inside a formview that is not bound to anything.
Lets say I have a table of customers (with a key field called CustomerID), and then another table that has all their orders (with amount spent per order (OrderID) - based on CustomerID)
On the FormView there is a key field (CustomerID) (this is to be used as an INPUT parameter to a SP - which is to return the SUM of all the customers (Order_Totals). I could nest a view within a view I suppose to get this result, however, I just want a label to simply show this ScalarValue.
Basically, I want the label to show the aggregate (SUM) total amount each customer has spent on all orders. I have a SP called SumCost with two Fields (one a grouped by field CustomerID and the other a Summed Total of each customer's orders SumCost)
SELECT [SumCost] FROM [SumCost] WHERE ([CustomerID] = @CustomerID)
I test my SP and it works great, returning the value based on CustomerID - no problem.
My problem is getting the CustomerID passed into the SP on runtime (do I put it in FormView2_Databound) and putting the value into the label (CustTotalLbl) which is inside this form.
I have a addform where I maually have placed a confirm label inside the formvieww.
But how can I connect this label with C# ??
If I place the label Outside the addform, I can connect the label, but I can't find the label if it is placed inside the formview.
This is my code down here for the outside label, which do well.
<asp:Label ID="lblreceipted" Text=" " runat="server"></asp:Label>
<asp:FormView ID="AddForm" OnItemInserted = "FormViewAddNew_Inserted" ...
protected void FormViewAddNew_Inserted(object sender, FormViewInsertedEventArgs e)
{
System.Threading.Thread.Sleep(1000);
if (e.Exception == null)
{
lblreceipted.Text = "your insert succes";
}
}
I have a formview with many textboxes, dropdownlist, labels etc. I want to populate these fields using code and not a datasource.
View 1 RepliesI need to insert code inside the SelectedIndexChanged event but it wont show up in my IDE :(
[Code]....
If I add another DropDownList outside my FormView it WILL display the events.
