DataSource Controls :: Representing A Simple "1 To Many" Or "parent/child" Relationship In The Database?
Sep 1, 2010
a FormView that is linked to SqlDataSource1a Repeater control (inside the formview) that is linked to SqlDataSource2 Thus representing a simple "1 to many" or "parent/child" relationship in the database!
SqlDataSource1 is simple in that it just retrieves a straight set of records from a table and they are displayed back in the FormView (nothing special happening there).
SqlDataSource2 has parameters that filter the contents of the repeater based on the record that is shown in the Formview. This would normally be simple enough to set up by setting the parameter to the formview.selectedvalue property.
HOWEVER - THE PROBLEM ARISES...
The formview has multiple DataKeyNames because the table that the SqlDataSource1 links to has a compound key. So to filter the Repeater correctly SqlDataSource2 needs to map 3 parameters to 3 data key values in the formview.
I've tried setting the SqlDataSource2 parameters to:
<SelectParameters>
<asp:ControlParameter ControlID="FormView1" Name="Parameter1" PropertyName="DataKey(0)" />
<asp:ControlParameter ControlID="FormView1" Name="Parameter2" PropertyName="DataKey(1)" />
<asp:ControlParameter ControlID="FormView1" Name="Parameter3" PropertyName="DataKey(2)" />
</SelectParameters>
but it doesn't seem to like that approach. I'm expecting the answer is something similar .
View 1 Replies
Similar Messages:
Mar 26, 2016
I have an excel sheet which has several parent records/rows and every parent row/record has several child sub-records under it. I have a field called ID which is of the type String as it contains a mixture of characters and numbers and is common for both parent and child records. How do I store the parent and child records in separate database tables, retrieve them and display them in a nested gridview?
View 1 Replies
Jul 30, 2010
how controls (txtbox, radio, etc) are mapped to properties in my Model. Now to the next part : My scenario (example):
Model: three tables: tblPerson, tblPersonOptions, tblOptionsConfig
UI:
Person Name: ______ (required)
Person Age: ________ (required)
radio button: Does Person want to select options? Yes / No ? (required) If yes, then show a checkbox list of options from tblOptionsConfig: (required if yes above). Scenario I tested:
Person Name: Tester User Person Age: Left blank (check if validation error is thrown)
Radion button: Yes. in options check ..let's say 3 out of 5 options. The UpdateModel throws the validation error and the page is returned back to the view(add.aspx).....................
View 9 Replies
Feb 26, 2010
I have a table that needs sorting by its hierarchial structure of parent-child.
An example of my table is below
ID
Name
Parent ID
Sort Order
1
iPhone Dev
0
1
2
iPhone Lounge
0
2
3
Web Development
0
3
17
Javascript
3
1
24
CSS
3
2
25
prototypes
17
1
As you can see above, my table structure follows this pattern
[Code]....
My overall aim is to have the sql order the table for me, and by using this new "depth" column, I will be able to indent by categories in the menu on the front end, you have probably seen this before, but all the tutorials I have read dont really explain it very well, or assume you are sql savvy.
View 2 Replies
Jun 4, 2010
I have a table that have LibraryID and LibraryParentID.
LibraryID int Unchecked
Name varchar(50) Checked
Description varchar(200) Checked
LibraryLevel int Checked
LibraryParentID int Checked
LibraryTypeID int Unchecked
I want to write a sql to delete the currrent select parent and well as all child record, how can I do that?
View 4 Replies
Feb 4, 2010
I am just getting started with entity framework with asp.net 3.5 using VS 2008
There are two tables, Categories & Subcategories:
Category table: CID, CategoryName Sub Category table: SID, CID, SubCategoryName I would like to get SID, CID, CategoryName, SubCategoryName in the gridview. Just as we write a select statement i.eSelect a.sid, b.cid, b.categoryname, b.subcategoryname from subcategories a inner join categories b on a.cid=b.cid & put the same in a gridview.
I was trying for the whole day & couldnt get atleast one url that would teach how to do it.
View 3 Replies
Sep 3, 2010
Is there a way to create a contact form that takes the name. address and other info for the master record; Then, somehow, on the same page, allow the user to enter multiple contact info as chid records (i.e. phone, email, etc.)
All this using the Objec DataSource or SQL DataSource (which ever is easy) and doesn't require writing too much code.
View 1 Replies
Jan 16, 2010
I have two tables dept and employees those table have parent and child relation ship link column is deptno i want to delte department even this departmetn contains employees i want to write storedprocedure for first delte employees and after department if i wrtie these two querys in storedprocedure will i get any problems
Begin
Delete from tbl_employees where Department_Id=@Department_Id
Delete from tbl_Department where Department_Id=@Department_Id
RETURN
END
View 5 Replies
Sep 20, 2015
How to populate or bind TreeView from one table use SQLSERVER database in ASP.NET & C# table include
ID,Name,ParentID
View 1 Replies
Dec 8, 2010
how to insert parent/child data to the database. I have a form with two 'dropdown' lists and two text boxes and a 'Comment' text area. I need to save some fieldsto the Parent table and some fields into the child table.
View 2 Replies
Dec 2, 2010
i am trying to delete using Gridview from child first and check if there is no child to delete in parent table i am using sql datasource in the delete tab in sql datasource i put DELETE FROM table1 WHERE (IDtable = @IDtable) IF (SELECT count(*) FROM table1 WHERE parent_dtl_id = 66) =0
BEGIN delete from parent_dtl where order_dtl_id= 66 END
i deleted all items,deleting from 2 tables child and parent was successfully on the last row from gridview but i have this error on my page on the last delete Specified argument was out of the range of valid values. Parameter name: value
View 2 Replies
Feb 15, 2011
i am making an application which is like chain system..i mean one person can have multiple child.. then his child can have multiple child ..etc like chain system...i dont know to insert into database.. so that when i call any-node.. his child,, and their futher child will show...
View 14 Replies
Feb 17, 2010
On DBML I have two entities as Parent, Child. I am trying to assign Child class properites in a Parent.
[code]....
I am getting the following Error:
Cannot access a disposed object.
Object name: 'DataContext accessed after Dispose.'.
View 2 Replies
Aug 26, 2010
Simple and blunt: my cascading dropdownlists clear when a postback occurs. Does anyone know a quick way around that?For more information, read on...
I have 5 dropdown lists that define a training class location and line of business: Site, Parent Client, Client, Program, Project I'm trying to build cascading dropdownlists that can work from any direction (i.e. select a site and all other lists are filtered by site...select a project and all other dropdown lists are filtered by project). I've built the SQL Select statement behind the lists that filters (accurately).
View 3 Replies
Mar 3, 2014
I have nested gridviews, in the outer grid I am displaying the question and in the inner grid 4 options are displayed in radiobuttons. I have kept Lock Answer button inside Item Template in inner gridview , so this button is coming with each and every question and when i click on Lock Answer button in front of any question, its saving the corresponding answer in the database. For ex, if there are 10 questions this button is coming with all the questions, all the questions are on single page and all are multiple choice. Now everything is working mine, my requirement is that I need on 1 common Lock Answer button at the bottom of the page and not with all the questions. And when I click on that common button it should run for all the questions that are displayed on the screen at should fetch and update each unique answer corresponding to that question in the database. Below is my code:
<asp:GridView ID="gvouter" runat="server" GridLines="None" AutoGenerateColumns="False"
AllowPaging="false" OnRowDataBound="gvouter_RowDataBound" Width="100%" OnRowCommand="gvouter_RowCommand"
OnPageIndexChanging="gvouter_PageIndexChanging" >
<PagerSettings Position="Top" />
<Columns>
<asp:TemplateField>
<ItemTemplate>
[code]...
View 1 Replies
Jan 22, 2011
I m working on LINQ, using LINQ i m getting data in one to many environment, means
(1)table1 (master table)
(2)table1.table2 (here table2 is child table)
I m able to get data of table1 and table2 based on condition. and i storing in var variable.
but my problem is that i want to get data using SQL query and i want to assign fecthed data to class CLStable1(calss for table1) and class CLStable2(calss for table2).
View 2 Replies
Aug 19, 2010
I have the next aspx page.
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.Master" AutoEventWireup="true"
CodeBehind="newsEditor.aspx.cs" Inherits="ExpertSiteV2.newsEditor" %>[code]....
In some situation i want to delete all the contents of Panel1. I write in the code:
Panel1.Controls.Clear();
But it doesn't work and i get message: Page cannot be null. Please ensure that this operation is being performed in the context of an ASP.NET request.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: Page cannot be null. Please ensure that this operation is being performed in
the context of an ASP.NET request.
Source Error:An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace: [InvalidOperationException: Page cannot be null. Please ensure that this operation is being performed in the context of an ASP.NET request.]
System.Web.UI.ScriptManager.get_IPage()
+373832 System.Web.UI.ScriptManager.OnPagePreRenderComplete(Object
sender, EventArgs e) +54
System.Web.UI.Page.OnPreRenderComplete(EventArgs
e) +8698462
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean
includeStagesAfterAsyncPoint) +1029
Blockquote
What's wrong? Or how should i do this properly?
View 2 Replies
Feb 25, 2016
With reference to this article [URL].... I'm trying to access parent gridview datakey in child gridview edit row event. Code below.
protected void grvSubmittedExpensePerMachine_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView grvSubmittedExpensePerMachine = sender as GridView;
grvSubmittedExpensePerMachine.EditIndex = e.NewEditIndex;
string site=this.grvSubmittedExpenses.DataKeys[((row.NamingContainer as GridView).NamingContainer as GridViewRow).RowIndex].Value.ToString();
[code]....
View 1 Replies
Mar 23, 2010
I have a database which contain job ads/ I have one table "dbo.tbl_jobadvert" which contains the ad itself and another table "dbo.tbl_jobFiles" which contains the path of the documents uploaded in relations to the job advert ( application form, job description, etc )
[Code]....
View 1 Replies
Jun 16, 2010
i have master table and it has related record in the child record
there are about four records in the detail table containing master id
how can i get the data group by master id ?? i want a sing row record
suppose:
order 1: item1 : item :2 item 3: item 4 in this shape
View 11 Replies
May 7, 2015
I am working in Asp.net 4.5. I need to create a grid as like below, I am struggling to make the merging cells and make it as multi header row by combining all the cells...
Is there any sample to make gridview like this.... I need to do this on codebehind. I browse through the internet and found couple of sample but those are not having the header like i posted. I am little confused about making full header as merged cells....
View 1 Replies
Jan 24, 2010
In my website I have two forms: parent form and child form(dialog box). Their expected behaviour is like this: if clicked on 'show' button on parent form, a dialog form opens that displays a gridview. In dialog form, if clicked on 'select' button it closes
itself and returns value in selected row back to parent form.
To achieve this I write following code (.cs) : in parent form:
void ShowBtn_Click(object sender, EventArgs e)
{
StringBuilder jScript = new StringBuilder(); [code]....
Now problem is: the code in parent .cs works fine, it opens the dialog properly. But when clicked on 'select', instead of returning back to parent, it opens the same dialog again in new window. This newly open window says "Done but error on page" at left bottom.
View 6 Replies
Jun 23, 2010
I have 2 tables. Table_A has one to many relationship with Table_B.
For example. Table_A has an ApplicantKey and in Table_B I am storing (Resume_name and CoverLetter_name for the Applicant). Joined by ApplicantKey
Now when I join them and execute the query obviously it returns me two rows. But what I want is that it should return only one row with Columns like Resume_name, CoverLetter_Name
View 2 Replies
Apr 18, 2010
I working on website and i have ready database from the company database. I have a table Location has only two fields : city andtate.I tried to get select the * city where state = something , but i think it is wrong,Is it a Many-to-Many realtionship
View 4 Replies
Apr 25, 2010
I need to know if I've done something wrong, or if the message I'm getting is nothing about which to be alarmed.I'm getting "The relationship '....' has columns that are not part of the key of the table on the primary side of the relation ship which is not supported, the relationship was excluded.
I built four tables, each with one foreign key. I'm assuming I haven't done anything wrong or unusual with my four tables (SQL statements generating the tables are shown below).However, I don't get any lines connecting tables together and all the examples I've seen today seem to have no problem with drawing the connecting lines all over the place.
[Code]....
View 6 Replies
