Require Assistance Making A Menu From A Single Parent/Child Table?
Oct 25, 2010
I have a single table that holds my Categories
CatID, CatName, ParentID
I have often used this layout to show Root Categories where the ParentID IS NULL. I would like to be able to create a vertical Menu (using a repeater and an <UL><LI> that displays the Root Categories and ideally, a collapse panel that would expand with the subcategories. Given the above Table format, it is also easily possible to make the hierarchy unlimited.
how to make a single dataset that understands the Child relationship.
View 1 Replies
ADVERTISEMENT
Jul 9, 2010
I have a table (Projects) which is linked to projectVersions on projectID..projectVersions contains several columns on which I'd like to filter a returned project (and associated projectVersions) list. For example there is a "capacity" column and a "country" column. I am doing a filtered list of projects on one page and I'd like to include all projects where any one of the associated projectVersions has a capacity of 750ml and a country of "France" for example.It may be that a particular parameter is not set and so I pass a zero to indicate not to filter on that.I guess this needs some kind of subquery as when I try and do something like this: [code] it doesn't work as the "xxx" bit, being one-to-many, expects me to specify an item to get at the entities within and yet I want to query where ANY of the associated versions match one of the criteria.
View 1 Replies
May 21, 2012
Dim obj_DataTable As New System.Data.DataTable("Category")
Dim obj_DataSet As New DataSet()
'Declaring the array of DataColum to hold the Primary Key Columns
[code].....
View 1 Replies
Dec 21, 2011
I have a data table whose one column is related to a column of another table. I have a listbox in a form which shows a column (which is sorted by another column value by ORDER clause) of the parent table and other columns are in textboxes. The child table is represented by a datagrid. When I add a new item in parent table and click save, the newly created item is listed at the bottom of the listbox violating my ORDER clause. When I wrote some codes to fill data again after updating, it shows an error message[code]...
View 3 Replies
Apr 30, 2009
I want to use the same menu shortcut keys in a MDI child as in the parent...the problem is that the parent seems to receive the Event first and is calling his menu entry. The child (though it does have the focus) does never receive any event whatsoever...I can bypass this behaviour by adding a Textbox to the Menu, and the moment that one has the focus the menu shortcuts are working as expected (child gets it first, after that it's passed through to the parent).
View 1 Replies
Jun 9, 2011
Ok So I am trying to save text from a textbox to a rtf file. The Saves Text would come from the active mdi Child. However I can not figure out how to Save using active child just calling the actual form name. Below is my code so far.
Private Sub SaveAsToolStripMenuItem_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles SaveAsToolStripMenuItem.Click
Try
[code].....
View 4 Replies
Nov 13, 2010
First, a little background (greatly simplified): I have two classes, one called Entity and one called Item which a subclass of Entity. They each store their individual properties in seperate SQL 2008 tables using TableAdapters generated by a strongly typed DataSet. The Entity class has a Save() method that looks like this:
Public Sub Save()
entityTableAdapter.Update(entityRow)
End Sub
[Code]....
Indeed, the SQL table does not contain a row in the Entity table with the necessary ID at this point because the transaction is not complete.
My goal is to prevent the Entity record from being inserted if inserting the Item record fails. I could write code to delete the Entity record again, but this does not seem very elegant to me...
View 1 Replies
Aug 23, 2010
I have two tables Employees and CafeLogs. Some employees can be cashiers and also customers at the Cafe shop.
Table structures:
Employees: EmployeeId(PK) , FirstName, LastName
CafeLogs: LogId (PK), CashierId, EmployeeId, Value, => CashierId and EmployeeId are the data from column EmployeeId of Empoyee table
Table relationship:
Employees 1:N CafeLogs (CashierId (FK))
[code]....
Right now I know how to select only LogId, Employee's name, and , Value, not with Cashier name yet.
Dim query = From log In db.CafeLogs _
Join emp In db.Employees On emp.EmployeeId Equals log.EmployeeId _
Select log.LogId, emp.FirsName, emp.LastName, log.Value
View 1 Replies
Jan 5, 2012
I'm writing an MDI app in vb.net vs2010. The MDI form has the default MDIMenustrip menu with several menu items. Each has some subitems. None of the child forms have a menustrip defined. I thought it would be easy to call a public subroutine in the MDI that would disable or enable the MDIMenustrip items. If I execute the routine from the MDI form, the menu items disable/enable just fine. THe problem I have is when I call the routine from a child form. How can I control the MDI menu from a child form?
View 3 Replies
Feb 13, 2009
I have created a parent form and 2 child forms. Each of the forms have menustrips. When i run the application the menu strip appears on the parent form but not on the child forms. I have the menu strip set to visable.
View 4 Replies
Jun 18, 2009
in DataSet ds I have "tbl1" as parent table and "tbl2" as childtablehow to show both table in datagridview if column id in "tbl1" related to column headerId in "tbl2" ?
View 1 Replies
Jun 17, 2009
I have a SQL Data Base. I have created a relation between these tables. Problem is when i drag and drop it on Data grid i get only Parent table columns but i want to sea them both like this.
- Parent Table Row
- Child Row 1
- Child Row 2
[code].....
View 6 Replies
Mar 5, 2012
[URL]
Basically here's what I want to do.
Input data
ID Item Name
1 Apple01,02,Banana01,02,03
2 Spoon1,2,Fork1,2,3,4
[Code]......
View 1 Replies
Jan 11, 2011
I have a situation where a database table is updated with records inside a loop. Every record in this table has a parent child relationship with another table. This child table is also updated subsequently inside the same loop.I am creating the datatable for Parent table and adding records inside the loop, but committing the records in the database (using SqlCommandBuilder) outside the loop only once.
Inside the loop I am also calling the function for updating records in the child table. Because the adaptor and datable objects are created inside the child table function, I need to commit records in child table inside the function only. So this happens before commit of parent table. Because there is a PK-FK constraint in the database, an error is generated.
Simplest solution would be to bring all code inside one function. But I don't want to do that. Besides this parent child relations can go upto any levels.
[Code]...
View 8 Replies
Mar 22, 2010
First I have 2 tables, for example Customer and Orders, and in the database there is a foreign key relation between both. For clarity Orders have a foreign key field to the primary key of Customers, thus Customer is the parent and Orders is the child table of the relation. My application is a Windows Form application, and I add a dataset to the project, in which I drop the 2 tables, and the relations between the 2 tables is automatic added. Now I will om a form loop through the Orders table (witch is the Child table) and show in a textbox some fields of the Orders table and also the Name field of the related record of the customers table. Regarding binding a textbox fo a Orders field I do it this way,
Dim myDs As New DataSet1
Dim myAdpCustomer As New DataSet1TableAdapters.CustomerTableAdapter
Dim myAdpOrders As New DataSet1TableAdapters.OrdersTableAdapter
myAdpCustomer.Fill(myDs.Customers)
myAdpOrders.Fill(myDs.Orders)
Dim myBindingSource As New BindingSource
myBindingSource.DataSource = myDs.Orders
myBindingNavigator.BindingSource = myBindingSource
TextBox1.DataBindings.Add("Text", myBindingSource, myDs.Orders.OrderIDColumn.ColumnName)
But now I can't find how to bind a textbox to a field of the Customers table witch is the Parent table of the relation.
View 1 Replies
Apr 4, 2009
Instead of connecting to database,I create datacolumns of two data tables.assign foregin key constraints and primary keys to the columns.Add these datatables to dataset and create relationship between them.Now by using RowFilter property,how to display the child table in a datagrid by clicking on parent record in another datagrid?Accept and Award Points Accept as Solution
View 2 Replies
Feb 26, 2009
How can I ensure that the currently selected row ID in Parent Table automatically appears in my child form when I create a new row in the Child Form.I am using VB 2008 Express I have a Stored Procedure for the chiled table called "Files" can I do it from there:-
ALTER PROCEDURE dbo.CreateFile
(
@FileName varchar(50),
@DateCreated varchar(50),
[code]....
View 1 Replies
May 1, 2011
The database strutcure is:
Id Name ParentId
1 File NULL
2 Open 1
3 Save 1
[Code]....
I am using the database PostgreSQL.
View 1 Replies
Feb 18, 2011
Im working with MDI parent/child objects. when closing the child objects i need the child to check to see if it is the last child object before closing. i couldn't find anything on google, maybe im searching for the wrong thing.
View 2 Replies
Jun 24, 2009
I have a main form, and some sub forms, and each sub form can have some sub forms. When I have multiple sub forms open, and I try to get data from the parent form, it returns the data from the wrong parent form.For example I have two instances of Mainform.subform running. If I do something like this in a child form of one instance of the subform. It returns data from the other subform.
dim l = Mainform.subform.listofdata
Edit:I am using visual Studio 2008. Winforms, form designed using designer. In my mainform I am doing this
Protected Friend frmMain as Mainform
frmmain = new mainform
In frmMain I am doing this
Protected Friend frmsub as new Subform'
frmsub = new subform
[code]....
View 1 Replies
Apr 10, 2010
I would like to know if there is some simple code to release a child control from it's parent control, without having to name the parent control. In pseudocode, I'm looking for something like this:
[Code]...
View 2 Replies
Apr 28, 2009
Applications_Type is a lookup table for Applications.What I am trying to do is provide a drop down list of applications and a label that displays the selected application type.[code]...
View 1 Replies
Apr 10, 2011
i have created two forms A and B when button in form A is clicked B is invoked when B is running its not possible to work on A until i close form B. How can i work on A without closing B
View 5 Replies
Apr 17, 2012
i have three forms
when i click button1 on form1=====> form2.showdialog()
then click button 1 on form2 =====> form3.showdialog
then click button 1 on form 3 =====>
[code].....
View 7 Replies
Jun 1, 2010
I have a MenuStrip with many submenus. I want to rearrange some of the menu items by making several of them submenus to another menu item.[code...]
View 2 Replies
Oct 12, 2011
I have a listview "CategoriesList" and i have a repeater "NewsRepeater" inside the listview "CategoriesList"
<asp:ListView ID="CategoriesList" runat="server" DataKeyNames="CatID" DataSourceID="CategoriesListODS"
EnableModelValidation="True">
[Code]....
how to pass the catID from the listview and make it as SelectParameters in ObjectDataSource "NewsRepeaterODS"?
View 1 Replies
Jun 29, 2011
I'm creating a tool that will query Excel and intialize the default settings for the site's Cad Software.I want 2-20 users to be able to simultaneously query excel. Currently I have the spreadsheet open on one computer and the other test machine gives me this error.
GetOleDbSchema Table Require an open and available connection. The connections state is closed.
I could use some help on the code design. Should I use Datareader instead....Does that have less permissions issues? Or do I need to open up the oledbconnection in a different manner?
Private Const cPageData = "PageData"
Private Const cPrinterData = "PrinterData"
Private Const cSupportData = "SupportData"
Private Const cUserData = "UserData"
View 4 Replies
Nov 12, 2010
Note: I am working with Visual Studio 2010 Professional. Note: There are a lot of MDI Child posts, but none (that I have found) that apply to my scenario... Scenario I have an MDI form with a UserControl docked at the top. The UserControl is for navigation and is ~50 pixels in height. When I show a child form with its WindowState property already set to 'Maximized', the child form shows maximized in the MDI parent, but behind the UserControl.
[Code]...
View 3 Replies
Dec 17, 2009
I have created a simple application. It contains one MDI parent and one child of its. At load of MDI parent i have also loaded its Child. but problem is with its display. the images of output is attached. Form2 is MDI Parent and Form1 is child.
The code at load of Form2 is:[code...]
View 1 Replies
Jun 27, 2012
I have 2 pages. parent.aspx and child.aspx. In parent.aspx, i use colorbox and send some value for the child.aspx to popup.
[code]...
child.aspx will popup and shows ASPxGridView base on the value passing from parent.aspx. User will select the data from ASPxGridView. the selected data need to send back to the parent page. I code it in child.aspx.vb page.My problem is how can i get the value from child.aspx.vb and pass it to parent.aspx ?
View 1 Replies