I have made a program that opens,views ,edits and saves to a xml
But I have a problem
I notice that I have some fields in my XML document that have child nodes as the same Parent nodes.
Heres a sample of what Iam talking about [code]...
I had a program that was working, then the underlying access database was changed and a few of the field types were changed from double to Decime. I went to the table adapter and tried to reconfigure the the table and adapters, but the underlying code that is generated by VB did not changed and cept the fields ad doubles and I was getting a null error.
I then deleated the table and added the table again using the same sql statements
I now can not view the desing view of the form and get the following error.
"DataMember property 'Specification_SPCUrethane' cannot be found on the DataSource."
How do I remove the binding sourse and detaset from the form so that it will display so I can fix the problem?
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 RepliesDim 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 am writing a mdi app (vb 2008 express) where i want the child forms to start in the same position i.e. on top of each other. Currently the forms are casacading. I know you can set the default mdi layout in the mdiParent using [code]....
View 2 RepliesI 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].....
In my project I have a view model City that is exposed by wcf. One of the properties is named differently then the already exposed contract dictates. Therefore I added the DataMember attribute and set the Name value like so:
<DataContract(Namespace:=ServiceNamespace)> _
Public Class City
private mySelectedTranslation as String
[Code]....
I'm using the following to bind to a TextBox:
Me.txtDescription.DataBindings.Add(New Binding("Text", myBind, "description"))
However, at run time, I need to be able to determine what the dataMember is for txtDescription elsewhere in the code. How do I get at it?
I am using VB.NET and below code on button click event.
Protected Sub ibtnSendInvites_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles ibtnSendInvites.Click
Try
Dim emailList As New List(Of String)
[Code] .....
I want to throw exception if user tries to insert same record having same CourseID and CPUserID.
m using backgroundworker to fill my data grid.Here is code:
Public Sub New()
InitializeComponent()
AddHandler DsData.Proba.DataRowChanged, AddressOf table_RowChanged
[code].....
So i have a Panel which on Mouse Enter and Mouse Leave i change the visibility of some controls which are docked inside it. Problem is whenever I hover over a control within the panel the Mouse Enter then moves to that indivual control and thus they are made invisible. Is there any way i can make this work without having to code these two events for each control within the panel?
View 1 Repliesform1 has datagridview, when I click "add new", form2 appears(details view, allowing me to add new records into datagridview on form1). when I click "add new" again, form2 appears again, if I click x times, form2 will appear x times. How do I stop the add new button and all the functions on form1 from working until form2 is closed?
View 6 RepliesI'm currently using a combo box to select one of many alternatives. From 5 alternatives only 1 works, when i click on any other it gives me the following error:"Cannot bind to the property or column 'xyz' on the DataSource.Parameter name: dataMember" Why is this error caused? What are the possible solutions to this error?
View 5 RepliesI've created a combobox for navigating orders in a grid view.
[Code]...
I have master/detail tables like Requistion and RequisitionDetail. when I use update command object in order to update both master/detail tables, the master table will be updated but the data in the detail table still remain unchanged. [code]...
View 3 RepliesDataRelation 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 RepliesIs there a way to clear all the textbox and combobox in a form without looping through panels and tabpages, because those textboxes and comboboxes were place in a tabpages and panels.
View 7 RepliesI'm having some problems trying to input records into a relational database. The design is really simple but I'm running into a wall when it comes to having the foreign key from my child table autopopulate the primary key from the parent table. I've made the connections in Access and from what I understood, so long as I committed a transaction, the child table would populate the primary key from the parent table. This is not happening.
my question is: is there a method that would do what I'm looking for? or am I cornered into using @@IDENTITY and manually inserting the primary key into the child table?
I've tried using datasets and data adapters and created a datarelation within the dataset, but it is still not doing what I need. everything I've tried thus far has allowed me to insert records into multiple tables, but won't relate them because of the missing primary key in the child table.
My Problem is that I want to give user a message if the delegate limit has reached for that course.See I have a course where I have MinDelegate and MaxDelegate limit. I want to stop inserting and give user message that "Max Delegate limit has reached can't have more delegates for this course"And below is the insert commmand which is inserting records in my delegate table.
ALTER PROCEDURE [dbo].[uspInsertDelegate]
(
@CourseID int,
[code].....
When I try to use the following line of code:
cboSite.DataBindings.Add("Text", _dtSite.Select("Site <> 'ALL'"), "Site")
I get the following exception:
EXCEPTION : Cannot bind to the property or column Site on the DataSource.{10}Parameter name: dataMember
details I am connecting to an Access database and using .net 3.5 and writing the code in VB. In this database I have a table named Sites with a column named Site and when I try to use the line of code above I get the exception noted. I was under the impression that I could explicitly name the column that I need to use in my control (combo box).
I'm currently using a combo box in vb.net to select one of many alternatives. From 5 alternatives only 1 works, when i click on any other it gives me the following error:"Cannot bind to the property or column 'xyz' on the DataSource.Parameter name: dataMember" Why is this error caused?
View 14 RepliesIm 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 RepliesI have 2 tables in my DB: "Competitions" and "CompetitionAnswers". Each competition will always have 3 answers. I want to be able to edit the Competition and CompetitionAnswers for the same view. I have managed to get the view to work by using editor templates So this is my editor template:
[Code]...
I have a dataset that is being generated from an XML file.
This dataset has two tables (User and UserSecurity) - that is related because they both have the same primary key. [i know, the tables should probably be combined, but this is the data that I have to work with][code]...
I am getting a System.Data.InvalidConstraintException" ForeignKeyConstraint CompanyPasswords requires the child key values(-1) to exist in the parent Table. When saving updates to the parent and child tables.My parent table consists of 3 columnsCompanyID (auto increment, pk)Company NameURLMy Child table consists of 4 columns PasswordID (auto increment, pk)CompanyID (fk)User NamePasswordHere is all the code on the form
[Code].....
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]...