Retrieve info from Dataset with Relations (Dataset,SQL or XML)

Joe

Hi

I am going to receive a dataset downstream and I will not know the
the fields
number of field
relations
number of relations

So I have to be flexible to take unknown data and be able to summarize all
the info being passed
I have included an example

I don't know what is the best way to attack this

XML and Xpath using the XSD as a guide?? I am not too familiar with what the
xsd is giving me
If I know how many tables and what field to xpath to the different levels
???

Dataset and walk the relations?? But they are at different levels
Every row get another row collection with the GetChild depending on the
number of relations
They cascade or are nested

What I want to see is
GM Pontiac GTO 82 4
GM Pontiac Gand Prix 134 38
GM Pontiac 1130 630
....
....

GM Buick 294 84
GM 43310 9880

<?xml version="1.0" standalone="yes "?>
<NewDataSet>
<l1>
<ID>Total</ID>
<Company>GM</Company>
<Sum_x0020_of_x 0020_HoursDev>4 3310</Sum_x0020_of_x0 020_HoursDev>
<Sum_x0020_of_x 0020_MarketLife >9880</Sum_x0020_of_x0 020_MarketLife>
</l1>
<l2>
<ID>Total</ID>
<Company>GM</Company>
<Division>Ponti ac</Division>
<Sum_x0020_of_x 0020_HoursDev>1 130</Sum_x0020_of_x0 020_HoursDev>
<Sum_x0020_of_x 0020_MarketLife >630</Sum_x0020_of_x0 020_MarketLife>
</l2>
<l2>
<ID>Total</ID>
<Company>GM</Company>
<Division>Buick </Division>
<Sum_x0020_of_x 0020_HoursDev>2 94</Sum_x0020_of_x0 020_HoursDev>
<Sum_x0020_of_x 0020_MarketLife >84</Sum_x0020_of_x0 020_MarketLife>
</l2>
<l2>
<ID>Total</ID>
<Company>GM</Company>
<Division>Cadil lac</Division>
<Sum_x0020_of_x 0020_HoursDev>5 658</Sum_x0020_of_x0 020_HoursDev>
<Sum_x0020_of_x 0020_MarketLife >2038</Sum_x0020_of_x0 020_MarketLife>
</l2>
<l3>
<ID>Total</ID>
<Company>GM</Company>
<Division>Ponti ac</Division>
<Car>GTO</Car>
<Sum_x0020_of_x 0020_HoursDev>8 2</Sum_x0020_of_x0 020_HoursDev>
<Sum_x0020_of_x 0020_MarketLife >4</Sum_x0020_of_x0 020_MarketLife>
</l3>
<l3>
<ID>Total</ID>
<Company>GM</Company>
<Division>Ponti ac</Division>
<Car>Grand Prix</Car>
<Sum_x0020_of_x 0020_HoursDev>1 34</Sum_x0020_of_x0 020_HoursDev>
<Sum_x0020_of_x 0020_MarketLife >38</Sum_x0020_of_x0 020_MarketLife>
</l3>
<NewDataSet>

<?xml version="1.0" standalone="yes "?>
<xs:schema id="NewDataSet " xmlns=""
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="u rn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSe t" msdata:IsDataSe t="true"
msdata:UseCurre ntLocale="true" >
<xs:complexType >
<xs:choice minOccurs="0" maxOccurs="unbo unded">
<xs:element name="vDWHPat">
<xs:complexType >
<xs:sequence>
<xs:element name="ID" type="xs:string " minOccurs="0" />
<xs:element name="Sum_x0020 _of_x0020_Hours Dev"
type="xs:double " minOccurs="0" />
<xs:element name="Sum_x0020 _of_x0020_Marke tLife"
type="xs:double " minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="l1">
<xs:complexType >
<xs:sequence>
<xs:element name="ID" type="xs:string " minOccurs="0" />
<xs:element name="Company" type="xs:string " minOccurs="0" />
<xs:element name="Sum_x0020 _of_x0020_Hours Dev"
type="xs:double " minOccurs="0" />
<xs:element name="Sum_x0020 _of_x0020_Marke tLife"
type="xs:double " minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="l2">
<xs:complexType >
<xs:sequence>
<xs:element name="ID" type="xs:string " minOccurs="0" />
<xs:element name="Company" type="xs:string " minOccurs="0" />
<xs:element name="Division" type="xs:string " minOccurs="0" />
<xs:element name="Sum_x0020 _of_x0020_Hours Dev"
type="xs:double " minOccurs="0" />
<xs:element name="Sum_x0020 _of_x0020_Marke tLife"
type="xs:double " minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="l3">
<xs:complexType >
<xs:sequence>
<xs:element name="ID" type="xs:string " minOccurs="0" />
<xs:element name="Company" type="xs:string " minOccurs="0" />
<xs:element name="Division" type="xs:string " minOccurs="0" />
<xs:element name="MainDepar tment" type="xs:string "
minOccurs="0" />
<xs:element name="Sum_x0020 _of_x0020_Hours Dev"
type="xs:double " minOccurs="0" />
<xs:element name="Sum_x0020 _of_x0020_Marke tLife"
type="xs:double " minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="Constrain t1">
<xs:selector xpath=".//Table" />
<xs:field xpath="ID" />
</xs:unique>
<xs:unique name="l1_Constr aint1" msdata:Constrai ntName="Constra int1">
<xs:selector xpath=".//l1" />
<xs:field xpath="ID" />
<xs:field xpath="Company" />
</xs:unique>
<xs:unique name="l2_Constr aint1" msdata:Constrai ntName="Constra int1">
<xs:selector xpath=".//l2" />
<xs:field xpath="ID" />
<xs:field xpath="Company" />
<xs:field xpath="Division " />
</xs:unique>
<xs:keyref name="l2" refer="l2_Const raint1">
<xs:selector xpath=".//l3" />
<xs:field xpath="ID" />
<xs:field xpath="Company" />
<xs:field xpath="Division " />
</xs:keyref>
<xs:keyref name="l1" refer="l1_Const raint1">
<xs:selector xpath=".//l2" />
<xs:field xpath="ID" />
<xs:field xpath="Company" />
</xs:keyref>
<xs:keyref name="l0" refer="Constrai nt1">
<xs:selector xpath=".//l1" />
<xs:field xpath="ID" />
</xs:keyref>
</xs:element>
</xs:schema>

Apr 4 '06 #1

Subscribe Reply

2493

Nicholas Paldino [.NET/C# MVP]

Joe,

I definitely would not use XML/XPath for this. I would just cycle
through all of the relations for each row as you cycle through the tables.
It's just a few calls in a loop as you iterate through the rows.

Hope this helps.
"Joe" <hc******@yahoo .com> wrote in message
news:Oi******** **********@TK2M SFTNGP15.phx.gb l...

Hi

I am going to receive a dataset downstream and I will not know the
the fields
number of field
relations
number of relations

So I have to be flexible to take unknown data and be able to summarize all
the info being passed
I have included an example

I don't know what is the best way to attack this

XML and Xpath using the XSD as a guide?? I am not too familiar with what
the xsd is giving me
If I know how many tables and what field to xpath to the different levels
???

Dataset and walk the relations?? But they are at different levels
Every row get another row collection with the GetChild depending on the
number of relations
They cascade or are nested

What I want to see is
GM Pontiac GTO 82 4
GM Pontiac Gand Prix 134 38
GM Pontiac 1130 630
...
...

GM Buick 294 84
GM 43310 9880

<?xml version="1.0" standalone="yes "?>
<NewDataSet>
<l1>
<ID>Total</ID>
<Company>GM</Company>
<Sum_x0020_of_x 0020_HoursDev>4 3310</Sum_x0020_of_x0 020_HoursDev>
<Sum_x0020_of_x 0020_MarketLife >9880</Sum_x0020_of_x0 020_MarketLife>
</l1>
<l2>
<ID>Total</ID>
<Company>GM</Company>
<Division>Ponti ac</Division>
<Sum_x0020_of_x 0020_HoursDev>1 130</Sum_x0020_of_x0 020_HoursDev>
<Sum_x0020_of_x 0020_MarketLife >630</Sum_x0020_of_x0 020_MarketLife>
</l2>
<l2>
<ID>Total</ID>
<Company>GM</Company>
<Division>Buick </Division>
<Sum_x0020_of_x 0020_HoursDev>2 94</Sum_x0020_of_x0 020_HoursDev>
<Sum_x0020_of_x 0020_MarketLife >84</Sum_x0020_of_x0 020_MarketLife>
</l2>
<l2>
<ID>Total</ID>
<Company>GM</Company>
<Division>Cadil lac</Division>
<Sum_x0020_of_x 0020_HoursDev>5 658</Sum_x0020_of_x0 020_HoursDev>
<Sum_x0020_of_x 0020_MarketLife >2038</Sum_x0020_of_x0 020_MarketLife>
</l2>
<l3>
<ID>Total</ID>
<Company>GM</Company>
<Division>Ponti ac</Division>
<Car>GTO</Car>
<Sum_x0020_of_x 0020_HoursDev>8 2</Sum_x0020_of_x0 020_HoursDev>
<Sum_x0020_of_x 0020_MarketLife >4</Sum_x0020_of_x0 020_MarketLife>
</l3>
<l3>
<ID>Total</ID>
<Company>GM</Company>
<Division>Ponti ac</Division>
<Car>Grand Prix</Car>
<Sum_x0020_of_x 0020_HoursDev>1 34</Sum_x0020_of_x0 020_HoursDev>
<Sum_x0020_of_x 0020_MarketLife >38</Sum_x0020_of_x0 020_MarketLife>
</l3>
<NewDataSet>

<?xml version="1.0" standalone="yes "?>
<xs:schema id="NewDataSet " xmlns=""
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="u rn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSe t" msdata:IsDataSe t="true"
msdata:UseCurre ntLocale="true" >
<xs:complexType >
<xs:choice minOccurs="0" maxOccurs="unbo unded">
<xs:element name="vDWHPat">
<xs:complexType >
<xs:sequence>
<xs:element name="ID" type="xs:string " minOccurs="0" />
<xs:element name="Sum_x0020 _of_x0020_Hours Dev"
type="xs:double " minOccurs="0" />
<xs:element name="Sum_x0020 _of_x0020_Marke tLife"
type="xs:double " minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="l1">
<xs:complexType >
<xs:sequence>
<xs:element name="ID" type="xs:string " minOccurs="0" />
<xs:element name="Company" type="xs:string " minOccurs="0" />
<xs:element name="Sum_x0020 _of_x0020_Hours Dev"
type="xs:double " minOccurs="0" />
<xs:element name="Sum_x0020 _of_x0020_Marke tLife"
type="xs:double " minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="l2">
<xs:complexType >
<xs:sequence>
<xs:element name="ID" type="xs:string " minOccurs="0" />
<xs:element name="Company" type="xs:string " minOccurs="0" />
<xs:element name="Division" type="xs:string " minOccurs="0" />
<xs:element name="Sum_x0020 _of_x0020_Hours Dev"
type="xs:double " minOccurs="0" />
<xs:element name="Sum_x0020 _of_x0020_Marke tLife"
type="xs:double " minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="l3">
<xs:complexType >
<xs:sequence>
<xs:element name="ID" type="xs:string " minOccurs="0" />
<xs:element name="Company" type="xs:string " minOccurs="0" />
<xs:element name="Division" type="xs:string " minOccurs="0" />
<xs:element name="MainDepar tment" type="xs:string "
minOccurs="0" />
<xs:element name="Sum_x0020 _of_x0020_Hours Dev"
type="xs:double " minOccurs="0" />
<xs:element name="Sum_x0020 _of_x0020_Marke tLife"
type="xs:double " minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="Constrain t1">
<xs:selector xpath=".//Table" />
<xs:field xpath="ID" />
</xs:unique>
<xs:unique name="l1_Constr aint1" msdata:Constrai ntName="Constra int1">
<xs:selector xpath=".//l1" />
<xs:field xpath="ID" />
<xs:field xpath="Company" />
</xs:unique>
<xs:unique name="l2_Constr aint1" msdata:Constrai ntName="Constra int1">
<xs:selector xpath=".//l2" />
<xs:field xpath="ID" />
<xs:field xpath="Company" />
<xs:field xpath="Division " />
</xs:unique>
<xs:keyref name="l2" refer="l2_Const raint1">
<xs:selector xpath=".//l3" />
<xs:field xpath="ID" />
<xs:field xpath="Company" />
<xs:field xpath="Division " />
</xs:keyref>
<xs:keyref name="l1" refer="l1_Const raint1">
<xs:selector xpath=".//l2" />
<xs:field xpath="ID" />
<xs:field xpath="Company" />
</xs:keyref>
<xs:keyref name="l0" refer="Constrai nt1">
<xs:selector xpath=".//l1" />
<xs:field xpath="ID" />
</xs:keyref>
</xs:element>
</xs:schema>

Apr 4 '06 #2

Nicholas Paldino [.NET/C# MVP]

Joe,

I definitely would not use XML/XPath for this. I would just cycle
through all of the relations on each row as you cycle through the tables.
It's just a few calls in a loop as you iterate through the rows.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Joe" <hc******@yahoo .com> wrote in message
news:Oi******** **********@TK2M SFTNGP15.phx.gb l...

Hi

I am going to receive a dataset downstream and I will not know the
the fields
number of field
relations
number of relations

So I have to be flexible to take unknown data and be able to summarize all
the info being passed
I have included an example

I don't know what is the best way to attack this

XML and Xpath using the XSD as a guide?? I am not too familiar with what
the xsd is giving me
If I know how many tables and what field to xpath to the different levels
???

Dataset and walk the relations?? But they are at different levels
Every row get another row collection with the GetChild depending on the
number of relations
They cascade or are nested

What I want to see is
GM Pontiac GTO 82 4
GM Pontiac Gand Prix 134 38
GM Pontiac 1130 630
...
...

GM Buick 294 84
GM 43310 9880

<?xml version="1.0" standalone="yes "?>
<NewDataSet>
<l1>
<ID>Total</ID>
<Company>GM</Company>
<Sum_x0020_of_x 0020_HoursDev>4 3310</Sum_x0020_of_x0 020_HoursDev>
<Sum_x0020_of_x 0020_MarketLife >9880</Sum_x0020_of_x0 020_MarketLife>
</l1>
<l2>
<ID>Total</ID>
<Company>GM</Company>
<Division>Ponti ac</Division>
<Sum_x0020_of_x 0020_HoursDev>1 130</Sum_x0020_of_x0 020_HoursDev>
<Sum_x0020_of_x 0020_MarketLife >630</Sum_x0020_of_x0 020_MarketLife>
</l2>
<l2>
<ID>Total</ID>
<Company>GM</Company>
<Division>Buick </Division>
<Sum_x0020_of_x 0020_HoursDev>2 94</Sum_x0020_of_x0 020_HoursDev>
<Sum_x0020_of_x 0020_MarketLife >84</Sum_x0020_of_x0 020_MarketLife>
</l2>
<l2>
<ID>Total</ID>
<Company>GM</Company>
<Division>Cadil lac</Division>
<Sum_x0020_of_x 0020_HoursDev>5 658</Sum_x0020_of_x0 020_HoursDev>
<Sum_x0020_of_x 0020_MarketLife >2038</Sum_x0020_of_x0 020_MarketLife>
</l2>
<l3>
<ID>Total</ID>
<Company>GM</Company>
<Division>Ponti ac</Division>
<Car>GTO</Car>
<Sum_x0020_of_x 0020_HoursDev>8 2</Sum_x0020_of_x0 020_HoursDev>
<Sum_x0020_of_x 0020_MarketLife >4</Sum_x0020_of_x0 020_MarketLife>
</l3>
<l3>
<ID>Total</ID>
<Company>GM</Company>
<Division>Ponti ac</Division>
<Car>Grand Prix</Car>
<Sum_x0020_of_x 0020_HoursDev>1 34</Sum_x0020_of_x0 020_HoursDev>
<Sum_x0020_of_x 0020_MarketLife >38</Sum_x0020_of_x0 020_MarketLife>
</l3>
<NewDataSet>

<?xml version="1.0" standalone="yes "?>
<xs:schema id="NewDataSet " xmlns=""
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="u rn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSe t" msdata:IsDataSe t="true"
msdata:UseCurre ntLocale="true" >
<xs:complexType >
<xs:choice minOccurs="0" maxOccurs="unbo unded">
<xs:element name="vDWHPat">
<xs:complexType >
<xs:sequence>
<xs:element name="ID" type="xs:string " minOccurs="0" />
<xs:element name="Sum_x0020 _of_x0020_Hours Dev"
type="xs:double " minOccurs="0" />
<xs:element name="Sum_x0020 _of_x0020_Marke tLife"
type="xs:double " minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="l1">
<xs:complexType >
<xs:sequence>
<xs:element name="ID" type="xs:string " minOccurs="0" />
<xs:element name="Company" type="xs:string " minOccurs="0" />
<xs:element name="Sum_x0020 _of_x0020_Hours Dev"
type="xs:double " minOccurs="0" />
<xs:element name="Sum_x0020 _of_x0020_Marke tLife"
type="xs:double " minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="l2">
<xs:complexType >
<xs:sequence>
<xs:element name="ID" type="xs:string " minOccurs="0" />
<xs:element name="Company" type="xs:string " minOccurs="0" />
<xs:element name="Division" type="xs:string " minOccurs="0" />
<xs:element name="Sum_x0020 _of_x0020_Hours Dev"
type="xs:double " minOccurs="0" />
<xs:element name="Sum_x0020 _of_x0020_Marke tLife"
type="xs:double " minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="l3">
<xs:complexType >
<xs:sequence>
<xs:element name="ID" type="xs:string " minOccurs="0" />
<xs:element name="Company" type="xs:string " minOccurs="0" />
<xs:element name="Division" type="xs:string " minOccurs="0" />
<xs:element name="MainDepar tment" type="xs:string "
minOccurs="0" />
<xs:element name="Sum_x0020 _of_x0020_Hours Dev"
type="xs:double " minOccurs="0" />
<xs:element name="Sum_x0020 _of_x0020_Marke tLife"
type="xs:double " minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="Constrain t1">
<xs:selector xpath=".//Table" />
<xs:field xpath="ID" />
</xs:unique>
<xs:unique name="l1_Constr aint1" msdata:Constrai ntName="Constra int1">
<xs:selector xpath=".//l1" />
<xs:field xpath="ID" />
<xs:field xpath="Company" />
</xs:unique>
<xs:unique name="l2_Constr aint1" msdata:Constrai ntName="Constra int1">
<xs:selector xpath=".//l2" />
<xs:field xpath="ID" />
<xs:field xpath="Company" />
<xs:field xpath="Division " />
</xs:unique>
<xs:keyref name="l2" refer="l2_Const raint1">
<xs:selector xpath=".//l3" />
<xs:field xpath="ID" />
<xs:field xpath="Company" />
<xs:field xpath="Division " />
</xs:keyref>
<xs:keyref name="l1" refer="l1_Const raint1">
<xs:selector xpath=".//l2" />
<xs:field xpath="ID" />
<xs:field xpath="Company" />
</xs:keyref>
<xs:keyref name="l0" refer="Constrai nt1">
<xs:selector xpath=".//l1" />
<xs:field xpath="ID" />
</xs:keyref>
</xs:element>
</xs:schema>

Apr 4 '06 #3

Similar topics

4608

Strange behaviour reading XML into DataSet

by: Bill C. | last post by:

Hi, I've got a simple console app that just reads an XML file into a DataSet then prints out a description of each table in the DataSet, including column names and row values for each column. I'm getting some strange results depending the input XML file I use. I was wondering if somebody could help me understand what is going on or point me to a good reference. The code for my program looks like this:

.NET Framework

1978

xsd versus dataset/datagrid problem?

by: Frosty | last post by:

Hi I am using the VS xsd designer to create a strongly typed dataset. The dataset is apparently successfully created, with no warnings or errors given. Is it not then to be expected that this dataset then should reflect all the details put into the xsd? Somewhere down the line there is not a 1:1 relationship. Be it that .NET is so tightly coupled to xsd, xml and dataset I would have expected any discrepancies to have been well documented and...

.NET Framework

3903

New XMLDataDocument(DataSet) - exception when relations.nested = true

by: James Ankrom | last post by:

Why does this fail? Dim relResources As New Data.DataRelation("Application_Resources", ..Tables("User_Applications").Columns("Application_id"), ..Tables("Resource_Rights").Columns("Application_id"), False) mUserData.Relations.Add(relResources) relResources.Nested = True Dim UserDataXML As System.Xml.XmlDataDocument = New System.Xml.XmlDataDocument(mUserData)

.NET Framework

5341

Saving Dataview to a Dataset

by: Dennis | last post by:

Hi, I am hoping I can get some help with a small problem I have run into using C#. U have an XML file that I load into a Dataset and then display this in a Datagrid. No problems doing this at all. I then use a Dataview to filter this view using a keyword and I have no problems with this either. What I would like to do is to save this Dataview to a new Dataset so I can save the reslts to a new file but here is where I am having the...

C# / C Sharp

2272

Compilier will not recognize DataSet object.

by: Dave | last post by:

Compilier will not recognize DataSet object. As you can see below is from a test simple form with no other code. I'm just trying to get any Aspx form to recognize the DataSet object. You can see from the code I am importing System.Data.SqlClient. I can get to DataReader, DataView and DataTable but Visual Studio won't even bring up DataSet on Intellisense, much less compile it. The message I get is: "Reference required to assembly...

ASP.NET

1430

XmlDataDocument error with DataSet relationships set

by: Steve | last post by:

I have a dataset. I fill it with two recordsets from SQL queries. Tables are called tblPlanFYSpendingStage, tblSpendingStage.

ASP.NET

1522

retrieve a record from a dataset?????

by: DaveF | last post by:

How can I retrieve display_names Dim custDS As DataSet = New DataSet Dim mySQL, mySQL2, mySQL3 As String

ASP.NET

2870

Convert Dataset with Tables with Relations to Flat view

by: Joe | last post by:

Hi I have a dataset with 2 tables and Relations What is the best way to flatten the 2 files to a new table or xml or file I can loop thru table1 and get the childrows or I can do an Xpath on the xml but not sure how to get relation from xsd or Is there another alternative???

C# / C Sharp

2871

Walk thru all relations in dataset

by: Joe | last post by:

Hi I have a dataset with 3 tables and 2 relations Is there a way to when I am at 1 row to tell if there is a relation on that row ??? I have the code hardcoded but try to make it work if the # of tables and #relations increase or decrease So I can just pass any dataset and walk thru the rows?? Thanks

C# / C Sharp

9589

What is ONU?

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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10216

Problem With Comparison Operator <=> in G++

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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8873

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7413

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6675

Couldn’t get equations in html when convert word .docx file to html file in C#.

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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5310

Trying to create a lan-to-lan vpn between two differents networks

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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5448

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3965

transfer the data from one system to another through ip address

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

C# / C Sharp

3565

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP