Stack Overflow
Stack Overflow

Questions tagged [datarelation]

60 questions
0
votes
1 answer

Master / Detail datagridview with relation from type string in C#

I want to show a master / detail relationship using two datagridviews and DataRelation in C#. The relation between the master and the detail table is an ID from type string (and there is no chance to change the ID to type integer). It seems like the…
user66928
  • 75
  • 3
  • 10
0
votes
1 answer

System.ArgumentNullException: The argument column cannot be null

So for a school project I need to follow the instruction of a book called Programming with C# Databases. And in this chapter I need to make a datagridview with Bindingsources etc. So where I get the error in the title of this thread is when I'm…
Batuhan Beyogullari
  • 3
  • 4
0
votes
0 answers

how to reflect parent id from parent table to child table in c#

Trying to get parent id directly in child table , Is it possible to get parent id in child table by just using dsTest.Relations.Add() also tried by adding cascade.for cascade How to update Dataset Parent & Child tables with Autogenerated Identity…
yash fale
  • 235
  • 1
  • 4
  • 19
0
votes
0 answers

datarelation with createconstraints false AND foreign key constraints for delete and update

Let's say I have a customer parent table and an orders child table. I set createconstraints to true for the datarelation, and I also add foreignkeyconstraints for delete and update to cascade. All works as expected. Now let's say the number of…
Ron V
  • 11
  • 4
0
votes
2 answers

Bind combobox to Parent DataRelation and update when 2nd Parent changes

I've looked around, and can't quite find what I need. I have a DB with (amoung others) 3 tables. SchemeType Scheme Type SchemeType contains foreign keys to the primary keys of both Scheme and Type I have a .NET 3.5 WinForm containing 2…
Janine Henstock
  • 3
  • 4
0
votes
2 answers

Fill all data from database in dataTable and build a list

I have 2 objects like this: public class Place : ICloneable, IEquatable { public string Name{ get; set; } public float longitude{ get; set; } public float latitude{ get; set; } public Horizon thehorizon { get; set; } …
chmouel kalifa
  • 129
  • 2
  • 11
0
votes
1 answer

How do I update a list data_relation in Python Eve

I have a model 'users' and a schema for it, which includes a one-to-many relation back to users: 'followers': { 'type': 'list', 'schema': { 'type': 'objectid', 'data_relation': { 'resource':…
Stefan D
  • 1,229
  • 2
  • 15
  • 29
0
votes
2 answers

Multiple data-rel values

I have multiple objects with data-rel values and for only some of them I would like to be able to, let's say, change to color of the content to red like so: HTML

1

2

3

Alin
  • 1,218
  • 5
  • 21
  • 47
0
votes
1 answer

C# Full Outer Join Two DataTables Without LINQ

Thanks for reading this. Here's my goal: I have two Datatables I've read in from Excel Worksheets. The Datatables have the same schema (Columns A, B, C, ... in Datatable1 has same kind of data as Column A, B, C, ... in Datatable2). I need to…
JessStuart
  • 1
  • 1
  • 2
0
votes
1 answer

Why combobox refresh doesn't work?

I have a complex problem, could you please help me. The problem: I have a form with a TabControl. There are two TabPages in the first is a dataGridView and in the second are multiple comboboxes. DataGridView is filled with data from Table1, on…
Jooj
  • 687
  • 4
  • 15
  • 32
0
votes
1 answer

Vb.Net DataRelation 'column' argument cannot be null. Parameter name column

I have a query that display results as follows: Now I want to display these results in a tree view in vb.net using datarelation. I will add the groupId as the parent and the other details as children in the tree view. I could have done this by…
Hilal Al-Rajhi
  • 437
  • 6
  • 25
  • 49
0
votes
0 answers

Create DataRelation with different columns name in both tables

when creating DataRelation between two tables in the same dataset should the names of columns in both tables be identical ??
sedalnas
  • 19
  • 6
0
votes
2 answers

DataTables DataRelation Opposite Right Outer Join

I have three datagridviews (Department, Employee, EmployeeNotInDepartment). I have populated the Department and Employee datagridviews based on DataRelations (see below). I'm thinking there has to be an obviously easy way to populate the…
Jim Kiely
  • 365
  • 2
  • 6
  • 24
0
votes
1 answer

How do I get all rows from ITEM table, which are children of a parent ITEM table row, where relationship is stored separately?

How do I get all rows from ITEM table, which are children of a parent ITEM table row, where relationship is stored separately? How can I do a join to do this? "get all rows from ITEM table, which are children of this specific ITEM table row, all…
Greg
  • 34,042
  • 79
  • 253
  • 454
0
votes
1 answer

How to display a DataRelation on DataGridView

5 and I try to solve the "more than one entity situation" using a single query for each one and then joined them with DataRelation, so after I realized that I've tryed to show data on this way : DataColumn parentColumn =…
Jonathan Escobedo
  • 3,977
  • 12
  • 69
  • 90
1 2 3
4