hi,
i maintain the information in two data tables. i like to do intersect (ie common between two tables) between two tables. any direct method is present.

currently i planned to travel two the table and find the common thing (ie combination AB,AC,BC like wise so its create more complex). i need to execute for N no of tables.

Please share your ideas.

Recommended Answers

Your post makes no sense...

Jump to Post

I will assume by intersect you really mean relate or join, if that is the case then here is an example:

_ds = new DataSet("dsAlarms");
      _ds.EnforceConstraints = false;
      _ds.Tables.Add(_dtAlarm);
      _ds.Tables.Add(_dtReadings);
      _ds.Tables.Add(_dtActions);

      _ds.Relations.Add("Readings",
        _ds.Tables["Alarms"].Columns["AlarmId"],
        _ds.Tables["Readings"].Columns["AlarmId"]);

      _ds.Relations.Add("Actions",
        _ds.Tables["Alarms"].Columns["AlarmId"],
        _ds.Tables["Actions"].Columns["AlarmId"]);
Jump to Post

All 5 Replies

Your post makes no sense...

Your post makes no sense...

I LIKE TO INTERSECT THE TWO DATA TABLE VALUES.

I MAINTAIN THE INFORMATION IN TWO DATA TABLES. I NEED TO FIND THE COMMON VALUE PRESENTS IN BOTH TABLES

SO THATS WHY I ASK ANY DIRECT METHOD FOR INTERSECT TWO TABLE VALUES

(
Advice for u: if u not understand my problem again u can send the message " i m not understanding".
so please avoid non sense... type of messages.
)

I will assume by intersect you really mean relate or join, if that is the case then here is an example:

_ds = new DataSet("dsAlarms");
      _ds.EnforceConstraints = false;
      _ds.Tables.Add(_dtAlarm);
      _ds.Tables.Add(_dtReadings);
      _ds.Tables.Add(_dtActions);

      _ds.Relations.Add("Readings",
        _ds.Tables["Alarms"].Columns["AlarmId"],
        _ds.Tables["Readings"].Columns["AlarmId"]);

      _ds.Relations.Add("Actions",
        _ds.Tables["Alarms"].Columns["AlarmId"],
        _ds.Tables["Actions"].Columns["AlarmId"]);

Thank you man.....

Please mark this thread solved if I answered your question

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.