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
I have two tables - dt(Mods) and dt(Mods2) - I am trying to create a relationship between them. So dt(mods) has department, category and item columns dt(mods2) has parentDept, Parentcategory and parentItems Now I need add them to a dataset with a relationship key - Something like this but with three cloumns
Dim ParentCol As New DataColumn, ChildCol As New DataColumn
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]....
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
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 RepliesI 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]....
I have 3 tables User, role and UserInRole THe entity frame work made entities for User and Role and I have successfully made a join with the user and role entities using user.add(role); but I can't seem to get it to remove the link (I want to retain the user and role just remove their association).
using (ProviderEntities context = new ProviderEntities())
{
User u = context.User
.Where(n => n.ApplicationName == application)
.Where(n => n.Username == username).First();
Roles r = context.Roles
.Where(n => n.ApplicationName == application)
.Where(n => n.RoleName == roleName)
.First();
r.User.Remove(u);
context.SaveChanges();
}
The oposite worked when I did r.User.Add(u); but it wont let me now remove it after it been created. Driving me mad as I can't see where I have gone wrong.
I have data coming from two tables with a foreign key relationship - one User table containing users of the web application, and one Page table containing details about pages visited by each user.I would like to be able to view these data in a gridview or the like on a page. It's easy enough to just show the User table data like so (I'm using the Entity Framework and LINQ):
[Code]....
But how can I show the Page details? I'm not bent on any particular way of showing it, but the only idea I've been able to come up with is to have a dropdown list for each user in a column. But I can't figure out how to get the page data into such a dropdown list. The tables are associated with the primary/foreign key UserID.The closest I've come to finding something similar to this is this for Linq2SQL: http://weblogs.asp.net/scottgu/archive/2007/07/16/linq-to-sql-part-5-binding-ui-using-the-asp-linqdatasource-control.aspx , and this using more traditional data access: ttp://www.highoncoding.com/Articles/169_DropDownList_Inside_GridView__Method_1_.aspx . Either way, regardless of data access technology, I can't relate these solutions to my example and get it to work
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 RepliesI am looking for some feedback on how to display data from a database where there is a 1 to many relationship. For example table A holds customer data such as name, address and table B will contain information on products that they have ordered. A customer can have multiple products ordered. How would you display the records as one record in a datalist or another control as oppose to the number of records based upon what they have ordered. Would this be accomplish by nesting the datalist or the control used or by the SQL statement?
View 5 RepliesI am using a Datalist and a Listview in a Master/Detail relationship. Each time a DataList item is bound, a Listview is loaded dynamically. I have provided the relevant Layout and Item templates. It is worked fine for one item. But for more than one item, it will raise the following error: "An item placeholder must be specified on ListView 'ItemListView'. Specify an item placeholder by setting a control's ID property to "MyLayout$itemPlaceholder". The item placeholder control must also specify runat="server".
Despite having set up the item placeholder.
Here is the code-behind:
protected void NodeDataList_ItemDataBound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)[code].....
The Layout template:<asp:PlaceHolder ID="itemPlaceholder" runat="server"></asp:PlaceHolder>
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 .
I've been wracking my brains for a while. I have a master record that I want to add children to. In a database it's a one to many relationship with a foreign key in the child table.
I have a formview that I want to use to fill in all the master record info, and choose the child info from a dropdownlist, and click an add button, and have the add button add the child info to some control on a page. Then when the user clicks insert, the formview has an ItemInserting EventHandler that will handle all the logic for inserting the master, grabbing its primary Key.
So, I know what to do, I'm just not sure of what control to use, or what memory object etc., that I want to store the child info in until the master record gets created.
I'm sure this has been done a million times, but for all my searching, I couldn't find anything to help me. Does anybody have some advice or can anybody point me to an internet resource where this has been hashed out?
I want to display details STRONGLY TYPE In a view this would be done as normal through the list, hiting the details link. however a table of notes is connected to the main table of info. i want to us the id of the main table item to list all the notes that have been entered about the record in the main table. how do i do this
View 1 Repliesi have 2 tables which are connected with FK.
StdPErsonal_info.Pk = Sid and student.FK = Sid
i want to use delete query which is delete the data from both tables in single query
I'm quite confused about how to implement a many-to-many relationship and my domain model. Let's say I'm creating a recipe box web application and I have three tables called Category (categoryID, categoryName), RecipeCategory (categoryID, recipeID), and Recipes (recipeID, recipeName, recipeDescription). If I were to present this information as an ASP.NET application and wanted to insert a new recipe and category, am I responsible for writing the logic to insert the information in the RecipeCategory table OR is it possible to set RecipeCategory.categoryID and RecipeCategory.recipeID automatically with default values based on newly inserted records in the related tables? If I'm responsible for writing the logic to insert values in RecipeCategory.categoryID and RecipeCategory.recipeID is that a trigger? What's the best way of implementing this?
View 2 RepliesI'm using Asp.Net's Dynamic Data Website project type.I've created a db that has one to onerelationship between two tables specified using a foreign key, (this could be one to many but I've used the linq designer to change it to a one to one relationship).i.e. I have a table Invoice and table CreditNote that takes an Invoice_Id as a foreign keyI was hoping that when I navigated to CreditNotes/Insert.aspx that it would display the a list of InvoiceIds in a dropdown list. It almost does this - it creates dropdownlist but only populates option value and not the text so I get something like this in the html source (notice only the value is populated - which looks empty to the user):
<select>
<option value="someInvoiceId"></option>
<option value="someInvoiceId"></option>
</select>
i have two sqldatasource controls. one i use to display data in textbox's ,filter'd by a select parameter in page behind code. Once checked, i want to copy this data to the other datasource ,by selecting checkbox.Then display this data in detailsview control.
At present the two datasource controls declared , render data to the page simultaneously during pageload. I want to first check data in textbox's from first source, before second datasource is rendered to screen. note, both are filtered by a page variable. i wish to leave the textbox datasource control in situ, as other controls and code depend on it.The other detailsview datasource is my problem?
need Users to be able to be friends with other Users (Users are kept in the User table) im trying to create a "Friends" table so they can relate to one another.I need the UserID stored along with FriendID, UserID is of the current user and FriendID is related to the UserID of the friend. ARGh so confusing. Im getting lost even talking about it again, basically the way ive written my code i need the FriendID to relate to the UserID of the user table so i can find the person im after so I can display there credentials on the current "UserID" page but I also need some way to find out all the current UserIDs friends
View 1 RepliesASP.net SQL datasource C# code behind
I want the webpage to show a message that there is no data selected,
Instead of showing blank details view
here is a picture of blank details view:
[URL=http://img28.imageshack.us/i/errorks.jpg/][IMG]http://img28.imageshack.us/img28/4328/errorks.jpg[/IMG][/URL]
What C# code do i need to use so that, whenever I enter that page, only an error message will show up
instead of the details view ..etc.
Scenario:
I am creating a custom gridview control which has a custom CheckBoxTemplateField column (deriving from TemplateField class). This template field column has custom Checkboxheadertemplate (implementing ITemplate) and CheckboxItemTemplate (also implementing ITemplate). In InstantiateIn method of both templates (header as well as Item template), I am adding a checkbox control which has Autopostback = true.
My requirement is:
I want to mark all the values in the binding column of datasource if checkbox in headertemplate is checked. I dont want to mark only rows visible on grid. I WANT TO MARK ALL ROWS IN DATASOURCE. I want to do this in _CheckedChanged event of checkbox in header template.
Problem I am facing: When I check/uncheck the checkbox in header, it postbacks. so in OnCheckedChanged event, gridview's datasource is null. Secondly, in any event of gridview, I could access only those rows of datasource for which corresponding rows are visible in gridview through Gridviewrow.DataItem property. But I want to set it for all rows in datasource.
This is the first time I have been working on databases and I am trying to insert data using an object datasource but no data is being inserted and no exception is thrown. I'm not sure where I am going to wrong. I am putting user data into session variables and inserting the session variables into the dataacess class layer and have a try and exception but nothing being thrown. Any help would be really appreciated because I don't know even where to start looking with this or how I can get the error to be thrown. Please see some of my code below to give an idea of what I am doing
Object Access Class
public void InsertCarPolicyHolder(PolicyHolderClass ph, CarInsuranceOptions options)
{
[code]...
i m developing an inventory module in which i have a GRN(Goods Received Note) form, the user opens the form and enter the items which are coming from itemMaster table. I want to add the grn entry in a table named GRN and all its respective item details in other table and also want to update the instock quantity in item Master table. how can i achive this there are multiple items in a grid in grn form which are to be stored in a table and only 1entry of grn in grn table and also update the instock Qty in the itemMaster Table,,...i ned write my logic using Stored procedures and ADO.NET i m totally confused
View 1 RepliesI have a table Structure
filename AKA
12-3-09.pdf 443567
12-3-09.pdf 345678
12-3-09.pdf 456789
3-3-10.pdf 78901
filename AKA
I want to output as 12-3-09.pdf 443567,345678,456789 3-3-10.pdf 78901.
I make ASP.NET MVC3 application for spa and I've encoutered problem with M:N relationship. I've got this model Each Insurance Company has different pricing for each patient medical indication, so sample data looks like this:
IC
Indication
Patient
IC1
Indication1
Patient1
Patient2
Indication2
Patient3
[Code]....
And I don't know how to make Edit with possibility of changing not only Indication but IC to.