DataRelation is used to create parent child relation ship between ParentTable and ChildTable Its working fine. ChildTable is displayed in a datagridview. But now how to get selected record from child table?
View 14 RepliesInstead 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 RepliesHow 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]....
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 RepliesI am leaning VB and have created a basic inventory app for work that consist of 4 tables, CurrentInventory, Surplus, Staff and Category. Each of these tables have a corresponding form. My question is with the CurrentInventory and Surplus form/tables. I want a button on the CurrentInventory Form that when clicked the current record would be transferred to the Surplus table and deleted from the CurrentInventory table.I am assuming that I could somehow use the INSERT command to copy the current record to the surplus table but I am not sure how to accomplish this.
View 5 RepliesWhile I've previously many years of relational databases and procedural languages, I'm stumbling with Visual Basic. In this problem, the simple situation is that I have two files, parent and child. The primary key of the parent file (Area file) is linked by a relation to one of the two fields that makes up the primary key in the child file (Project file) (unique key is formed from 'area' and 'project'). I have the default table adapters created on both files. I have created two maintenance forms showing one each of the two files in datagrid view format.I can create some records in the Parent (Area) file, but when I try to create a record in the child (Project) file, using one of the valid key values from the Area file, I get the 'ForeignKeyConstraint [relation name] requires the child key values [actual value] to exist in the parent table' which I'm absolutely definitely sure it does.
I haven't done any actual coding for those two maintenance forms, just dragged-and-dropped the files from the data sources screen onto separate forms so it creates the controls itself. But I can't work out, if it already knows the data does exist because I can load it back in to the Area maintence form, why it can't check itself to find out the record does exist. Why does it think the record from the parent record doesn't exist? It does exactly the same thing, whether or not the database is in access or SQL Server Express. I have all the latest updates.
Visual Studio Pro 2010 Win 7 64 bit running bootstrapped to a MacBook Pro i5 (blasphemer!!!) works really well though!!New to vb.net, have used vb6 for several years and finding the transition interesting to say the least.I have an access database with a vb.net front end all auto bound by the connection and binding wizards (I know, I know...) Not too complicated, but a simple 2 table related db. On the form the parent table shows customer details with the child table related and displayed by datagrid. I have a field in the child table for images and I have figured out how to store and retrieve images to the db. I am using the datagrid.rowheadermouseclick event to reload the picturebox on the main form as I click down the child table datagrid. Now I need to be able to click the bindingnavigator, go to the next record and have the program reload the image for the next child record. The problem is I'm trying to use an event from either the datagrid or bindingnavigator to reload the picturebox in the child table after moving to the next record, but all of the events I am trying are firing before the next record is moved to and therefor the logic I'm using to retrieve the image from the db is not working.
Anyone with an idea on how to move to the next record and then run my logic to populate the picturebox? What events might I use that fire after the next record has been populated? I know this is probably not that hard, but I have been racking my brain all day now.
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].....
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 RepliesI have two tables Products and Categories with a many to many relationship. I am trying to copy the categories linked to one product (OriginalProduct) to another product (newProduct). The problem is when I execute the SaveChanges() method, I not only get the records in my linking table, but it also creates another copy of the categories in the categories table. I've tried this in many ways but here are the last couple that I've attempted:
' Copy Product/Categories
For Each oneProdCategory In OriginalProduct.Categories
Dim relatedCategory = _productContext.GetObjectByKey(New EntityKey ("ProductInfoEntities.Categories", "RecordId", oneProdCategory.RecordId))
[code]....
My database : table1
ID FIRSTNAME AGE
1 Sumit 22
2 Sanjeev 23
i have gridview 1 and textbox1 and button1 i want when pages load the gridview displays the all records from table1 and also ...i i wanna search record for firstname by typing sumit in textbox1 and click on button1 then in gridview the record of sumit will be shown ..by default gridview display alll records from table1 How to do this My Selct Query is below : but it doesnot display all record ...but it can display record if you search for a particular record .
[Code]...
I use This Code To Save Data in Table First I delete record Then Insert record
View 4 RepliesI'm receiving the following error:"You cannot add or change a record because a related record is required in table 'FORN_NIB'."
I cannot understand this error fr the related record really existe on the FORN_NIB table. It is even picked up from there. Here's the code where the error occurs at the .Update instruction:
HTML With rst
.Open("DADOS_RECIBOS", conn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic)
.AddNew()
.Fields("NUM_FORN").Value = Me.TextBox1.Text
[Code]...
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
how to connect my table like america and child table like State i want to add sub node or childto th tree view?
View 11 Repliesin 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 RepliesI 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].....
I got an error when I tried to save a deleted record in a table which I use to store username and password.
I can delete with no problems but the error message popped up when I clicked on the update icon
My login code is like this
Imports System.Data.SqlClient
Public Class Form1
Private Sub btnOK_Click(ByVal sender As System.Object, ByVal e As
[Code]....
Working on an VB/ASP website in Visual Studio 2008. Getting the error "You cannot add or change a record because a related record is required in table 'abc'
It is true that table xyz (the target of the INSERT) is in a parent-child relationship with table abc. The PK in abc is a column RequestID_lng. The FK column in xyz is also named RequestID_lng
This is the only relationship these 2 tables are in.
I am trying to add a row in xyz with a value of 45 in the FK. There is already, previous to this action, a row in table abc with a value of 45 in the PK. So the parent already exists for this child.
I have used the watch window to copy my SQL code for the INSERT query that is being executed. I pasted that code into a new query in the Access DB and executed it without problem - it actually added the row that .Net should have.[code]...
I'm fine with both C# and VB.NET..I have two tables. Authors and Books. It's a one to many relationship, Authors to Books. I'm writing a query to show how many books that each author has.[code]But in the Authors table, there are some authors without any books yet. For example, there two authors, Author D and Author E that have no books yet. I want to write query that includes all authors and number of ther books, even though they don't have any book yet, no record in the Books table yet.
View 1 RepliesI have master detail form with two datagrids. customer and order detail.I have relationship between customer and order detail on customerid.How do i delete record from order detail when i click delete button to delete record from customer datagrid.Here is the code so far.
Private Sub btndelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btndelete.Click
'Me.CustomerTableAdapter.Fill(Me.CustomerDataSet.Customer)
[code]......
ok I have a weird issue. I created a master record in the master table and then a record in the detail table. when creating the detail record i get a Specified cast is not valid error. Now another weird thing is that once I create the master record I can't query and verify it was created. But when i got to sql management studio I can see the master record. Below is my two procedures and the table definitions. Master table primary key is INVNUM child table primary key it INVLIN_ID and the reference key is INVNUM
View 13 RepliesI have a form with a parent bindingsource showing details and a child bindingsource showing the multiple line items in a dgv. This relationship has the properties set to enforce the constraints and cascade the updates and deletes. When I add a new parent record there is a function for inserting default line items into the child. I have this code fr deleting a record,
[Code]...
edit: jmc posted a nice solution to this problem in the code bank just recently but I could not get it to work in 2005, this line, "AddHandler Me.LOTBindingSource.Adapter.RowUpdated, AddressOf parentAdapter_RowUpdated" throws an error. It say "Adapter is not a member of the System.windows.forms.bindingsource.
IS this Correct oro find error, i cant solve that how to see record on my form
Dim Slec As New SqlDataAdapter
Slec.SelectCommand = New SqlCommand("SELECT Name'=" & txtname.Text & "', CNIC#='" & txtcnic.Text & "', F_Name='" & txtfname.Text & "', College='" & txtdept.Text & "',
[code].....
i have some sample code on inserting a record from one table to another new table? Making the record on the first table to be deleted and been transfered to another table ..
View 7 Repliesi don't now where to but my question so if this is the wroung section i am sorry
i am designing a web site with a database using visual studio
and the code i use is visual basic
i use this code to insert in to tabel temp1
MySqlCommand.CommandType = CommandType.Text
MySqlCommand.CommandText =
"Insert into temp1 values(@id_card,@city,@name)"
[Code].....
am having a query regarding updating a table A records from table b on a button click...have created connection sting and commandtext to exexute d query am tryn ds query bt it seems to throw some syntax error
cmd.CommandText =
"UPDATE stockno_table SET(product_id,Sold,Rec_No)
=(SELECT product_id,Sold,Rec_No from stockno_temp_copy
where stockno_temp_copy.stock_no=stockno_table.stock_no) where(exists)(stockno_table.stock_no=stockno_temp_copy.stock_no)"
basically the fields are same bt the stockno_temp_copy is a temporary table which i want to empty always while it updates all the table records to stockno_table...all the records except the Sold which is YES/NO field changes...NB: Access DB is used?
I use this code.. it work to delete my sql data but it delete all the data. I just want to delete the selected record. I also have try the others code but the code not delete from my dataset. Just this code that I've try and delete from my database but the problem is it delete all the record..
Dim con As New SqlConnection
Dim CM As New SqlCommand
Try
con.ConnectionString = "Database=ITtry;" & "Data Source=SLSDB\SLSREP;" & "Uid=sa;Password=***"
con.Open()
[Code] .....
This is the form I'm having problems with. As you can see I've created a tab interface which is working. There are five text boxes on it which are binded to the Staff table in the database. When the tab is changed, the binding is changed to a new field. However, unfortunately, when a new record is selected, the data bindings do not update, and instead, the first record is always being used. We suspect the problem may be coming from the fact that there is code to unbind from the text box and rebind it again. This is the code I'm talking about...
Private Sub TabCheck()
If TabState = 1 Then
pnlTabs.BackgroundImage = My.Resources.tabs1
txtBox1.Visible = True
txtBox2.Visible = True
[Code] .....
i have this addform to add, edit and delete records in marriage tab, baptism tab and so on and before we can see this form theres another form the emform my question is how am i supposed to code the "view this event" button, that when i click on the selected row my addform will show up with the row i click on the view button is selected/highlighted on this addform (btw i bind all the textbox in my add form on the columns of my marrige table)
View 10 Replies