473,549 Members | 2,829 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Infragistics Ultra Grid DataRelation

2 New Member
Hi all,
I have two tables that I'm trying to display in a Master Detail fashion in an Infragistics UltraGrid. I added both tables to a dataset and added a datarelation between the two tables using the field that related both. When I run my application Ultra Grid just displays the master table, the child table is not displayed. Does anybody know what is wrong with my code? Grid expandable property is set to true, but is there any other property that I need to set to be able to see the chid table? Thanks for the help.


Expand|Select|Wrap|Line Numbers
  1.             string sqlCommand = "";
  2.             sqlCommand = "SELECT * FROM ENUM_VALUES";
  3.             DataTable dt2 =                     
  4.             DBBroker.getInstance().ExecuteSQL(sqlCommand);
  5.  
  6.             sqlCommand = "SELECT * FROM CONSTANTS";
  7.             DataTable dt1 = 
  8.             DBBroker.getInstance().ExecuteSQL(sqlCommand);
  9.  
  10.             DataSet ds = new DataSet();
  11.  
  12.             ds.Tables.Add(dt1); //Add master table
  13.             ds.Tables.Add(dt2);  // Add child table
  14.  
  15.             DataRelation relConstEnum = new DataRelation("ConstEnum",    
  16.                 ds.Tables[0].Columns["ID"],                     
  17.                 ds.Tables[1].Columns["CONST_ID"], false);
  18.             ds.Relations.Add(relConstEnum);
  19.  
  20.             mGrid.Rows.ExpandAll(true);
  21.             mGrid.DataSource = ds;
Feb 19 '07 #1
3 9142
kenobewan
4,871 Recognized Expert Specialist
I believe that the problem is the you need two separate sql strings and execute them separately. Otherwise the first string is written over by the second...
Feb 20 '07 #2
Sarahb1337
2 New Member
I found out what was the problem. UltraGrid ViewStyle property has to be set to MultiBand instead of SingleBand.
Feb 21 '07 #3
kenobewan
4,871 Recognized Expert Specialist
My bad, using the same sqlcommand name was very confusing for me :).
Feb 21 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

9
6651
by: Michael Howes | last post by:
I'm looking for a power grid control to use for some C#/Windows forms development. There are a LOT of grids out there and trying to analyzes them could turn into a long task. Some things I'm looking for; Grouping (TreeGrid capabilities) Outlook style group by Built in filtering a plus but not required Works in most recent version of...
5
5457
by: Paul W | last post by:
I was recently assigned to build a database administration tool with an infragistics web grid UI. I am able to pull the data into a dataSet and bind it fine. However, when I attempted to use the UpdateCell or UpdateCellBatch events to transfer updated data to the data set, the event arguements (Infragistics.WebUI.UltraWebGrid.CellEventArgs e)...
1
3173
by: steve | last post by:
Greetings, My team and I would like to use Infragistics for both WinForm and WebForm development. From a technical perspective we see the benefits. The boss wants me to quantify ROI. The primary question I get is 'what does the Infragistic grid give me that the ASP.NET grid does not?' I get similar questions for the other Infragistic...
5
1885
by: Jéjé | last post by:
Hi, I'm looking for a webcontrol which provide the same capabilities of the outlook grid. I have found 2 products, 1 provided by infragistics, the second by componentone. There is any other company/product on the market? anyone as tested these components and can share its experience?
2
2711
by: NuB | last post by:
i have to do a web app using the infragistics web grid and i never used them. I changed the autobuildcolumns to false and bind my dataset to the grid, but it comes up empty (no data). how can i use the grid and bind my columns from my dataset in the order i want to show them?
1
1694
by: Yavuz Bogazci | last post by:
Hi, i need a Component Suite. I looked at ComponentOne Enterprise Studio and for Infragistics NetAdvantage. I need Components WinForms and for WebForms. Especially Charting and Grid Controls, but i can't make a choice between these two suits. Whats your opinion? Whats your recommendation? thanks Yavuz Bogazci
3
11466
by: Ronald S. Cook | last post by:
Hi everyone, We're needing to pick a suite of components for our C#/VS 2005 development. Top on our list is a treeview that integrates with a datagrid. I think all the big goes provide that. Does anyone know which suite is the "best" or are they (Infragistics, ComponentOne, DevExpress, other) all about the same? Thanks for any insight...
0
1292
by: faizalahmd | last post by:
I would like to have paging as well as sorting in a infragistics ultra web grid control .. regards, Faizal Ahmed
1
3142
by: faizalahmd | last post by:
I would like to know the features of ultrawebgrid(infragistics control) compared to normal grid view ... Thanks in advance, FAIZAL AHMED.H
0
7554
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7751
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7992
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7511
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7840
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5119
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3525
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
1973
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
793
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.