I'm reading in an XML file, to a DataSet. This contains two tables and the relationship is automatically created. I'm using two DataGridViews in an attempt to display the master and detail data.
If I set the datasource of the grids as follows, then the detail view updates correctly:
[Code]...
I have 4 Tables Master And Three Tables Details
how to programming this Technique
This Picture dispaly what i mean http://img300.imageshack.us/img300/3981/26072009110315.png
i have invoice form separated into 2 parts the upper part is master (header) and detail (body) in invoices where header contains date,name,invoice number,etc ..and the lower part is the body contains the datagridview with its details like the item name or code,qty,price,discount,etc the problem is i want to save the invoice headers in a table and the body in another different table but with a realtion between the 2 of them by the invoice id i think i put it in the invoices' form load. but i cant get it right.by the way iam using vb. net 2005 and my db is sql 2005.
View 1 RepliesIm having some trouble to construct a Master-Details form. When I navigate through each record on the master nothing happens on the details. This is so even if there exit a relation between the two tables in the database and in the dataset between the data table. Can anyone provide me with some samples or examples of coding how to proceed?
Furthermore I have tried to programmatically create the relation but the following error occurs: child list for field cannot be created etc
i have invoice form separated into 2 parts the upper part is master (header) and detail (body) in invoices where header contains date,name,invoice number,etc ..and the lower part is the body contains the datagridview with its details like the item name or code,qty,price,discount,etc the problem is i want to save the invoice headers in a table and the body in another different table but with a realtion between the 2 of them by the invoice id i think i put it in the invoices' form load. but i cant get it right so if any one have an example by code 2 solve this prob ,
View 1 RepliesCan anybody show me sample howto do on 1 form once 1 button save which is the master n details save at 1 time.
View 1 RepliesHow to use master/details datagridview for the same table in run time?
View 2 RepliesI am having a problem trying to save records in a parent / child data relation. I have to tables tblContacts & tblMember. There is a fk relation on the ContactID field. The tblContacts table is the master record. I am using a set up bound windows forms controls to do the data collection. The problem that I am having is in saving the child record. After the form is populated in both the fields and hitting the save button the items in the child record get deleted. It does add a row in the child record but only the ContactID (from the master table) and the key for the tblMember table. This program will not be using a datagrid. I did experiment with datagrids and it works well. The problem is when I try to use detail views in the form of textboxes that are bound to the bindingsource.
[Code]...
I am having a problem trying to save records in a parent / child data relation. I have to tables tblContacts & tblMember. There is a fk relation on the ContactID field. The tblContacts table is the master record. I am using a set up bound windows forms controls to do the data collection. The problem that I am having is in saving the child record.After the form is populated in both the fields and hitting the save button the items in the child record get deleted. It does add a row in the child record but only the ContactID (from the master table) and the key for the tblMember table.
I can see that since the new master record incites the addition of a new row, the data is abandoned. Once there is a save done to the master / child record I can go back and modify the fields and it saves it successfully. I know I must be missing something small. I am not sure how to work around this so that the controls are read into memory and then completed in the new row. I have an example of my code:
Private Sub TblContactsBindingNavigatorSaveItem_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TblContactsBindingNavigatorSaveItem.Click
Dim newMemberRow As DataRow 'To create a new row in the tblMember table
[code].....
Am new to VB, can anyone tell me very simple how to share the MAIN Bindingsource with an detail form where i want to edit 1 record from the main datasource?
andreg
I am using Visual Studio 2010 and SQL Server 2008. I made one preject using Employee table and Employee_Permission Options(Yes/No/Override/Never). I want to both table in form detail view most using combo box. if I used Employee detail view and Employee_Permission Datagridview than its work fine to add/edit/update but if table Employee_permission I used detailview (all Combobox) than I can not add/edit/update records. I can add only employee but can not add record in employee_pemission. I have relationship with two table EmpID in both table Primery key with auto increase in Employee table.
View 1 RepliesBinding Master Table to TextBox and DateTimePicker and Binding Details Tables to Datagridview then Add / Update / Delete in both
View 8 RepliesI have a problem regarding the autocomplete extender in ASP.NET - it works fine in all pages I have, but NOT in a master page and i don't know why.
Here is my code:
<asp:TextBox runat="server" ID="txtSearch" Width="200px" CssClass="TextBoxClass"></asp:TextBox>
<cc1:AutoCompleteExtender ID="txtSearch_AutoCompleteExtender" runat="server"
TargetControlID="txtSearch"
[code]....
The problem is that GetCompletionListOggetti is never called. I repeat - it works fine on content page!
i'm trying to work with master pages and referencing local and master contentplaceholders. I have a master file that has this:
[Code]...
I`m using below login solution and need to add one more column with Working Group details.
Once user logs-in (after OK command MDIparent form is displayed), working group details will be displayed in toolstrip status label.
[URL]
I am developing a Winform Program in visual basic and I am using Access Tables. I want to use a bindingsource filter to do a search on Stock descriptions. I am using this but it doesn't seem to be working
Me.StockBindingSource.Filter = "ITEMNAME LIKE '%" & SearchTextBox.Text & "%' AND [Supplier1 Price] <> 0 AND [Supplier2 Price] <> 0 AND [Supplier3 Price] <> 0"
What's happening is that I am only seeing products where all 3 suppliers have a price listed that isn't 0. (Products have a zero price when it becomes discontinued or supplier doesn't sell that product but we may have purchasing history against it so it can't be deleted). Therefore we do end up with products where all 3 suppliers have a zero cost. These are the products I don't want this search to return.
So I got this DB and I have these values
Hash | Value
abcd | "test"
efgh | "test2"
I want to search my db for the value abcd, so I wrote this Private Sub Button1_Click_2(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click MessageBox.Show(Me.Table_0BindingSource.Find("Hash", "abcd"))
End Sub
but I keep getting -1 even if there is no data that matches what I want to search.
How can I do a search using Data Sources?
I'm trying to get a details view in ASP.NET to display the details of the logged-in user only. I have been told to use:
select * from STAFF where USERNAME = user.identity.name
I thought this was too simple to be true and I was correct as it shows no data when I attempt to run.
I have a nested master page that has its own master page. The parent master page has a property defined in its code behind.
Public ReadOnly Property SelectedPage() As String
Get
Return _selectedPage
End Get
End Property
How can I reference the parent master page's property from within either the child master page's code behind Page_Load or aspx template page?
i'm using vb 2008 and i'm wondering if theres any way to get the gui grids back (like in vb 6) and to turn off/make snap less sensitive..
View 2 RepliesIm using a datagrid for user to enter input. However,im restricting the grids to some value.My grid is actually not bounded to any database. so,here is my requirement: whn the form is getting displayed,all grids are getting displayed.,which dont want.,only row2 shld get displayed to user after he'l finish entering values in row1.. im using vb.net as front end and access as backend..
View 8 RepliesI have a question, I have a combo box, which when changed fills the data grid. Now Wen I change the Tab and come back to same tab again(one containing the combo box)..the value of combo box remains there, however the grid gets empty. I need this data to be maintained till the user selects another value from drop down.
View 1 RepliesTry something along these lines:
TextBox1.Text=(dt1.rows(DataGrid1.CurrentRowIndex).item(0).tostring)
where dt1 is the datatable you're using as the data source and you want the data from the first column of the grid to be shown in the text box.
dp.SyntaxHighlighter.ClipboardSwf = '/dp.SyntaxHighlighter/Scripts/clipboard.swf'
dp.SyntaxHighlighter.HighlightAll('381571b4631840c6b8a8abfe5b54ed97')
I have two grids inside a TabItem and in the code-behind I want to be able to add controls to both grids and have all the controls visible at run-time. Currently at run-time the controls added to "Grid3" are not visible while he controls added to "Grid4" are visible.The overlapping grids have the same rows but a different set of columns.I'm trying to do this with two grids so that I can vary the number of controls I can add per row in the code-behind by adding the controls to one of the two grids.Here's the XML:
<Grid Name="TabControlGrid" Margin="20,171,0,70">
<TabControl >
<TabItem Header="Tab1" >[code].....
The controls in the XML are just place holders for the controls I am adding to the grids in the code-behind.
How are crossword puzzle grids made? I have written a program to generate a puzzle, my problem is the GUI part.I ended up using Visual Basic (VB) because I'm more familiar with that language.However, eventually I have to write this in Java. So far the only way I am displaying the results in a grid-like format is using two controls Groupbox with a Label inside it.This way I can put the number to the word's clue in the title line of the Groupbox, and the individual letter in the Label. To make the cell in the grid editable (my goal for a different version of the puzzle), I guess a Textbox would have to replace the Label.The GUI for real online (professional) crossword puzzle grids is much nicer than this.I know there is a way to combine controls to make a customized one. Even if this works in VB, I'm not certain if it can be done in Java, therefore, I really don't want to go that route (unless someone knows how make customized controls in Java). I have searched the net and looked in books on games, VB and Java with no luck.I need something that I can grow dynamically depending on the grid size needed to hold the content.
View 1 Repliesi have a data grid in my form.It has 3 colums.On clicking the second col I want to put a value of 1 in there.I tried using datagrid click event but nothing happens in fact the the program wont even go there.[code]
View 2 RepliesI am trying to use a grid to display datasets. The database that I am using is not on my local machine. I have to dial in and log in to the database. We are using an image database. I was shown by my boss that he uses MSFlexGrid, but it appears that is no longer available on the newer versions of Visual Studio (he is using VB6). I was wondering if there was a way to display these grids without going through the Data Sources?
View 4 RepliesI'm curious what we all are using to display grids of data.I keep falling back to LISTVIEW's in DETAIL mode - they visually look nice to me. But I'm always writing code to load them from datatables and such - lots of work.DATAGRIDVIEW's - not so nice looking. Of course we can edit them easily - and they bind really easily
View 2 RepliesStarting to design an application and wondering if its ok to have only one form as the application which could hold up to 15 gridviews separated in tabs etc. with a navbar as navigation on the left. Is this too much or ok? Is it better to have one gridview per form? What is the norm?
View 6 RepliesI am new to WPF but what i am trying to to do is i have a parentGrid with 3 rows, the first two are a menu strip and a toolbar, the third row is a child grid that is populated with the choices that are selected from the tool bar. the problem is that i want the forms that load in the child grid to not have their height surpass what i have set that row equal to in the parentGrid.[code]
View 6 Replies