.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Accessing master formview data from a nested detail formview?

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :ASP.Net
Hi all, I would like to ask if it is possible to access data on a master FormView from a nested detail FormView. I have a main form (master) with several tabs (detail) and would like to display a label with text from main form that is hidden by the tab at the moment of editting. My asp page looks like this.<asp:FormView ID="fvwCustomer" runat="server" DataSourceID="dsCustomer" DefaultMode="Edit" DataKeyNames="CustomerID"> <EditItemTemplate> <asp:TextBox ID="CompanyTextBox" runat="server" Text='<%# Bind("Company") %>' /> <asp:FormView ID="fvwContactPerson" runat="server" DataSourceID="dsContactPerson" DefaultMode="Edit" DataKeyNames="ContactPersonID"> <EditItemTemplate> <%-- I need to get the value Company from dsCustomer --%> <asp:Label ID="CompanyTextLabel" runat="server" Text='<%# Eval("Company") %>' /> </EditItemTemplate> </asp:FormView> </EditItemTemplate> </asp:FormView>   Is it possible to get the value of the label CompanyTextLabel from CompanyTextBox using just ASP.NET expressions or something similar without writing c# code in

View Complete Post

More Related Resource Links

Accessing master page controls from content page formview



I have a master page with a textbox that I want to use for a search, and display the results on the content page.

I've dragged in the datasource to the content page, and configured the formview to use that datasource... almost.

The issue I'm having is that on the last step of the configure datasource wizard where you select the parameters, I want to select the master page textbox control for the search parameter... but of course it's not available in the list. The list only allows me to choose controls from the content page.

How do I set this master page search box as the parameter for my datasource?

Any ideas would be much appreciated!



Insert Master/Detail data using ADO.net Transactions

I am working on Sales application. In database i have SalesOrderHeader & SalesOrderDetail tables. They are almost typical Adventureworks db tables.How to insert data in both tables using TransactionScope so if any of the record from the two tables generate error complete transaction roll-back.One thing more I am using TableAdapters, My initial concept was inserting record in SalesOrderHeader, get SalesOrderId using Scope_Identity & bulkInsert Records to SalesOrderDetail using TransactionScope.Please suggest.

Updating record in sql databse using data from Gridveiw or Formview

Hi Guys, I am making a message module in asp.net with database of sql. i have made a gridview and enabled selecting. and a form view is synchorised with grid view on selecting. i am writing update sql but could not get a way to take data on Gridview or Formview to compare the record in sql database.   this is my page viewImports System.Data Imports System.Data.SqlClient Partial Class homepage Inherits System.Web.UI.Page Protected Sub GridView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.SelectedIndexChanged FormView1.PageIndex = GridView1.SelectedIndex Label1.Text = FormView1.FooterText. End Sub Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Session("login") = False Then Response.Redirect("Login.aspx") End If End Sub Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim db As New SqlConnection db.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Message_Dat.mdf;Integrated Security=True;User Instance=True" db.Open() Dim sql As String = "update into tblMessage (msg_status) values('junk') where msg_Id='" & FormView1.text & &q

FormView Manual Data Updating

I've posted this some place else but have not heard from anyone and hoping I get better luck here.   Note: Sorry about the formating, not sure what happened.I have a FormView that I user for updating a record. There is a link button that when fires should perforom the updating viaBLL and DAL. I am not using built-in ODS and I will not condsider using it. I have all my grids and formviews populated manuualy by calling methods that fetch the data from the database. For instance my details view is populated like this:  protected void DlMembers_ItemCommand(object source, DataListCommandEventArgs e) { if (e.CommandName.ToString() == "Select") { DlMembers.Visible = false; lblError.Text = string.Empty; lblError.Visible = false; fvMemberDetail.Visible = true; fvMemberDetail.ChangeMode(FormViewMode.Edit); MemberBLL getMemberInfo = new MemberBLL(); int Ident = Convert.ToInt32(e.CommandArgument.ToString()); fvMemberDetail.DataSource = getMemberInfo.GetMemberByIdent(Ident); fvMemberDetail.DataBind(); } if (e.CommandName.ToString() == "DeleteSelected") { DlMembers.Visible = true; lblError.Text = string.Empty; lblError.Visible = false; fvMemberDetail.Visible = false; fvMemberDetail.ChangeMode

How to fill data from a login to a Formview?

I want to fill a Formview when accessing the webpage where it's on (Page_Load). The data I have when somebody want to go to this page is his logindata.  The only code I see I can use is "User.Identity.Name". But I want his Id, so I can get to fill his UserId. I don't know how to do this. I'm using MySql as a database. My code is (a part of it):I want to fill a Formview when accessing the webpage where it's on (Page_Load).The data I have when somebody want to go to this page is his logindata. The only code I see I can use is "User.Identity.Name".But I want his Id, so I can get to fill his UserId. I don't know how to do this.I'm using MySql as a database.My code is (a part of it):<asp:FormView ID="FormView1" runat="server" DataKeyNames="UserId" DataSourceID="MySQLProfielDataSource"> <ItemTemplate> <asp:Table id="ItemTabel" runat="server"> <asp:TableRow> <asp:TableCell> UserId: </asp:TableCell> <asp:TableCell> <asp:Label ID="UserIdLabel" runat="server" Visible="false" Text='<%# Eval("UserId") %>'

Accessing a public property of a nested user control in a master page from a pages' user control

Hi  I've got a web site that has a master page and that master page (mpMaster that has a user control (ucControl1) which has a sub user control (ucControl2), this user control has a property which accepts a value. Now, I have a page that uses the master page and on this page I have another user control (ucPageControl), I need to  find a way of setting the value in ucControl2 from ucPageControl. Is this possible at all? Many thanks Ed

Access Nested FormView Events

Hi I have a main formview which contains another formview. In the second formview I have a section that needs to insert/update.   I want to access this formviews events for example I can access the main formviews item inserted event in the code behind: FVInvoiceHCPAgreement_ItemInserted I can't choose the nested formview events in the code behind ie. FVInvoicePaymentInfo_ItemInserted   I have tried adding the ItemInserted event in the .aspx page i.e. onItemInserted = "FVInvoicePaymentInfo_ItemInserted" but for the handles clause it can't see FVInvoicePaymentInfo.   Thanks.  

FormView custom data binding problem

Hi there,   I'm using VWD 2010 ASP.NET 4.0 and SQL Server 2008 Also I have login page with the ASP.NET configuration   one of my page has FormView with Update feature   Evryting works fine user login go to my FormView page and update the record.   Now I created a simple function   Protected Function GetUserName() As String        Return User.Identity.Name    End Function   and one of my coloumn call EditedBy   I replaced the Bind("EditedBy") field binding with   Custom binding GetUserName()   When user update it show the current user login name on the screen But it won't show in the table itself (it show null value when i do select statement)   I used to do this with ASP.NET 2.0 with no problem?   How do I fix that?   Thanks, Oded Dror  

How to Insert Data Using EntityDataSource in FormView - C#


I am new to formview .My formview works fine, when I insert data into the database directly and then do an update on it. It throws an error when I try to insert a new record.  The error just says

"An error occurred while updating the entries. See the inner exception for details."


How to insert data into the table using an entity dastasource? Please help!!



Status of Accessing Nested Objects in Data Source of Local Report Does Not Function


We recently upgraded out platform to .NET 4.  We are also using Microsoft Reporting dlls.  Unfortunately, we found that the upgrade broke all of our reports.  Researching the cause, we found this article:


It seems that this issue has been open for some time now and I have not seen a good workaround (except for the shim class which is not really feasible for us).  Can I please get a status update for this?  Is there some other type of resolution?

Thank you,

Benjamin Strum 

Ben Strum

Would like to hide Formview's "Update/Cancel" and make data changes when new page is selected


I have a Formview that is only showing a question, and two checkboxes (True / False).  It's cumbersome for the client to have to click "Update" every time they click a checkbox.

Is there a way to have Formview update the data when the page is changed, or form is closed?  (I see those events, but know how to force data to update from in them).

The application is testing individuals, so 95% of the time the person navigating through the forms will be updating data.



Help with checkboxlist in formview edittemplate data display



I can insert a checkboxlist selected value as comma delimited string into the database. But I have hard time to reload it in formview edit mode.  I added a hidden label to retrieve the comma delimited string and try to use checkboxlist databound event, but it doesn't work. I don't know what problem is in my code. Please help me:

protected string sessiontypestr = string.Empty;

protected void chkType_DataBound(object sender, EventArgs e)
            CheckBoxList c = (CheckBoxList)FormView1.FindControl("chkType");
            if (c != null)

                Label test = (Label)(FormView1.FindControl("lblhiddensessiontype"));
                sessiontypestr = test.Text;

                string[] items = sessiontypestr.Split(',');

                for (int i = 0; i < c.Items.Count; i++)
                    if (items.Contains(c.Items[i].Value))
                        c.Items[i].Selected = true;


<asp:CheckBoxList ID="chkType" runat="server" Font-Size="Smaller" 
                SelectedValue='<%# Bind("session_type") %>' 

Compute Values in FormView From Row Data


Here's what I am trying to do:

Inside Form View Want to display the average of a field based from field1/field2


Field 1 = 10

Field 2 = 5

Field 3 would equal 2 (Field 1 / Field 2)

How would I go abaout doing this.  Code currently looks like:

<asp:Label ID="sales_per_qtr" runat="server" Text='<%# Bind("total_sales/total_qtrs") %>' />

Using custom bind expression in the formview but it won't let me do this...

All input appreciated.


How to output data from master detail tables into text file but on different lines.



I have a requirement to output data from two tables, a master table and a detail table, to a text file such that the output looks like the following:

master record 1

detail record  1 1

detail record   1 2

master record 2

detail record  2 1

master record 3

detail record 3 1

detail record 3 2

detail record 3 3



Is this possible in one query?  I am sufficiently familiar with the bcp utility to do the output from any of the tables separately but have some difficulty with doing it for the two tables and have the result structured as outlined above.

Insert Parent and Child row in ONE Formview Dynamic Data


Hi All,

I am at my wits end and need some help, I have a dynamic data site, and have built a formview for my parent table, Claims (parent), Claims has a child table called DamagedVehicles, I want all the fields on the Cliams table and the fields on the DamagedVehicle to be displayed for insert on the same formsview, when the user fills in all data it should insert the claim and the damagedvehicle at the same time and set the foriegn key on the Damagedvehciles row to the Primary key of the claim, I dont know were to start any examples in VB.net or C# will be greatly appricated. i have been search for 3 days now trying to come to a solution and nothing has worked.

thanks in advance.

Can I use Dynamic Data with a Formview?


I have seen a number of posts that indicate that a Formview will not work with Dynamic Data.  Is this true?  I need to give my customer an attractive, intuitive way to edit, update etc. single records in a complicated table.  Single column DetailViews aren't acceptable.  I'm not very sophisticated with Dynamic Data and I've been working on this for weeks before posting this question.  I've reviewed Steve Naughton's good articles on Custom Pages and haven't seen any use of FormView. I will really appreciate a definitive answer.


Master-Detail with the GridView, DetailsView and jQuery's ThickBox

One more article about grids from Matt Berseth. This time he shows how to create master-detail with the gridview, detailsview and jQuery's ThickBox. He writes:
So I thought I would check some of this out and along the way rebuild my Master-Detail with the GridView, DetailView and ModalPopup Controls and replace the ModalPopup with jQuery's ThickBox. I found it pretty interesting - read on to see how it went
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend