C# Discussion Boards - CodeProject

C# Unable to update data table values

10-Apr-21 22:48

1) GC.WaitForPendingFinalizers Method (System) | Microsoft Docs[^]
2 and 3) See here: c# - Is correct to use GC.Collect(); GC.WaitForPendingFinalizers();? - Stack Overflow[^]

"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!

Mou_kol10-Apr-21 1:34

10-Apr-21 1:34

I am trying to find data in xml file using LINQ but my ANY() or WHERE clause found no data. what is the problem in my approach not clear.

I have a xml file which which has been created by Dataset WriteXml() function. that file i am querying by LINQ and data not found occur.

See my XML structure

<?xml version="1.0" standalone="yes"?>
<TER_ViewAll>
<dgvViewAll_Vertical>
    <Section_x0020_>ML</Section_x0020_>
    <LineItem>BofA Merrill Lynch</LineItem>
    <Revise_x0020_Date>01-16-2018</Revise_x0020_Date>
    <_x0032_010_x0020_FYA>1608.6500</_x0032_010_x0020_FYA>
    <_x0032_011_x0020_FYA>1429.0610</_x0032_011_x0020_FYA>
    <_x0032_012_x0020_FYA>1656.7500</_x0032_012_x0020_FYA>
    <_x0032_013_x0020_FYA>1427.9330</_x0032_013_x0020_FYA>
    <_x0031_Q_x0020_2014A>321.0100</_x0031_Q_x0020_2014A>
    <_x0032_Q_x0020_2014A>525.5670</_x0032_Q_x0020_2014A>
    <_x0033_Q_x0020_2014A>478.0100</_x0033_Q_x0020_2014A>
    <_x0034_Q_x0020_2014A>323.2360</_x0034_Q_x0020_2014A>
    <_x0032_014_x0020_FYA>1647.8230</_x0032_014_x0020_FYA>
    <_x0031_Q_x0020_2015A>342.4010</_x0031_Q_x0020_2015A>
    <_x0032_Q_x0020_2015A>512.7390</_x0032_Q_x0020_2015A>
    <_x0033_Q_x0020_2015A>465.9940</_x0033_Q_x0020_2015A>
    <_x0034_Q_x0020_2015A>318.4440</_x0034_Q_x0020_2015A>
    <_x0032_015_x0020_FYA>1639.5780</_x0032_015_x0020_FYA>
    <_x0031_Q_x0020_2016A>430.9940</_x0031_Q_x0020_2016A>
    <_x0032_Q_x0020_2016A>531.7920</_x0032_Q_x0020_2016A>
    <_x0033_Q_x0020_2016A>410.4750</_x0033_Q_x0020_2016A>
    <_x0034_Q_x0020_2016A>379.9890</_x0034_Q_x0020_2016A>
    <_x0032_016_x0020_FYA>1753.2500</_x0032_016_x0020_FYA>
    <_x0031_Q_x0020_2017A>456.9130</_x0031_Q_x0020_2017A>
    <_x0032_Q_x0020_2017A>696.9010</_x0032_Q_x0020_2017A>
    <_x0033_Q_x0020_2017A>503.3780</_x0033_Q_x0020_2017A>
    <_x0034_Q_x0020_2017A />
    <_x0032_017_x0020_FYA />
    <_x0031_Q_x0020_2018A />
    <_x0032_Q_x0020_2018A />
    <_x0033_Q_x0020_2018A />
    <_x0034_Q_x0020_2018A />
    <_x0032_018_x0020_FYA />
    <_x0031_Q_x0020_2019A />
    <_x0032_Q_x0020_2019A />
    <_x0033_Q_x0020_2019A />
    <_x0034_Q_x0020_2019A />
    <_x0032_019_x0020_FYA />
    <_x0031_Q_x0020_2020A />
    <_x0032_Q_x0020_2020A />
    <_x0033_Q_x0020_2020A />
    <_x0034_Q_x0020_2020A />
    <_x0032_020_x0020_FYA />
    <_x0031_Q_x0020_2021E />
    <_x0032_Q_x0020_2021E />
    <_x0033_Q_x0020_2021E />
    <_x0034_Q_x0020_2021E />
    <_x0032_021_x0020_FYE />
    <_x0031_Q_x0020_2022E />
    <_x0032_Q_x0020_2022E />
    <_x0033_Q_x0020_2022E />
    <_x0034_Q_x0020_2022E />
    <_x0032_022_x0020_FYE />
    <GroupKey>Consensus Model~Net Revenue~TRIN~NBM~~1~ML</GroupKey>
  </dgvViewAll_Vertical>
  </TER_ViewAll>

the above xml is one records and xml file has many records like above one. i load that xml file by data ser and querying by LINQ. this way i am querying.

private void button1_Click(object sender, EventArgs e)
        {
            string QCViewPath_savepath = @"C:\RDSS WorkBench_Stage\Data\TER\TER_QC-ViewwAll.xml";
            DataSet ds = new DataSet();
            ds.ReadXml(QCViewPath_savepath);

            if (ds.Tables[0].AsEnumerable().Any(a => a.Field<string>("Section ") == "ML"
                            && a.Field<string>("GroupKey").Contains("Consensus Model")
                            && a.Field<string>("GroupKey").Contains("Net Revenue")
                            && a.Field<string>("GroupKey").Contains("NBM")
                            && a.Field<string>("GroupKey").Contains("1")
                            && a.Field<string>("GroupKey").Contains("ML")
                            ))
            {
                ds.Tables[0].AsEnumerable().Where(a => a.Field<string>("Section ") == "ML"
                     && a.Field<string>("GroupKey").Split('~')[0].Trim() == "Consensus Model"
                     && a.Field<string>("GroupKey").Split('~')[1].Trim() == "Net Revenue"
                     && a.Field<string>("GroupKey").Split('~')[3].Trim() == "NBM"
                     && a.Field<string>("GroupKey").Split('~')[4].Trim() == "1"
                     && a.Field<string>("GroupKey").Split('~')[5].Trim() == "ML"
                     ).ToList<DataRow>()
                     .ForEach(r =>
                     {
                         r["2010 FYA"] = 1200;
                     });

            }
        }

My object is to update data table periodical value and save that data at last after all update. after querying data table i am getting Enumeration yielded no results

please help with rectified code. Thanks

modified 10-Apr-21 8:01am.

OriginalGriff10-Apr-21 2:13

10-Apr-21 2:13

You have no field in your XML called "Section ":

if (ds.Tables[0].AsEnumerable().Any(a => a.Field<string>("Section ") == "ML"
                            && ...
                            ))

So the first test will always fail.
You have "Section_x0020_" but no "Section " ...

Mou_kol10-Apr-21 3:04

10-Apr-21 3:04

Sir xml was created by data table writexml function data looks like & see how Section element looks in xml <section_x0020_>ZB that is why we need to add space end of Section other wise program will throw run time error.

XML

<dgvViewAll_Vertical>
    <Section_x0020_>ZB</Section_x0020_>
    <LineItem>B. Riley Securities</LineItem>
    <Revise_x0020_Date>02-09-2021</Revise_x0020_Date>
    <_x0032_010_x0020_FYA />
    <_x0032_011_x0020_FYA />
    <_x0032_012_x0020_FYA />
    <_x0032_013_x0020_FYA />
    <_x0031_Q_x0020_2014A />
    <_x0032_Q_x0020_2014A />
    <_x0033_Q_x0020_2014A />
    <_x0034_Q_x0020_2014A />
    <_x0032_014_x0020_FYA />
    <_x0031_Q_x0020_2015A />
    <_x0032_Q_x0020_2015A />
    <_x0033_Q_x0020_2015A />
    <_x0034_Q_x0020_2015A />
    <_x0032_015_x0020_FYA />
    <_x0031_Q_x0020_2016A />
    <_x0032_Q_x0020_2016A>3333.3865</_x0032_Q_x0020_2016A>
    <_x0033_Q_x0020_2016A>3878.1150</_x0033_Q_x0020_2016A>
    <_x0034_Q_x0020_2016A>4376.5020</_x0034_Q_x0020_2016A>
    <_x0032_016_x0020_FYA />
    <_x0031_Q_x0020_2017A>3340.3645</_x0031_Q_x0020_2017A>
    <_x0032_Q_x0020_2017A>3711.3744</_x0032_Q_x0020_2017A>
    <_x0033_Q_x0020_2017A>4310.8500</_x0033_Q_x0020_2017A>
    <_x0034_Q_x0020_2017A>5041.2855</_x0034_Q_x0020_2017A>
    <_x0032_017_x0020_FYA>16403.8744</_x0032_017_x0020_FYA>
    <_x0031_Q_x0020_2018A>4867.8009</_x0031_Q_x0020_2018A>
    <_x0032_Q_x0020_2018A>5167.5060</_x0032_Q_x0020_2018A>
    <_x0033_Q_x0020_2018A />
    <_x0034_Q_x0020_2018A />
    <_x0032_018_x0020_FYA />
    <_x0031_Q_x0020_2019A />
    <_x0032_Q_x0020_2019A>3545.9127</_x0032_Q_x0020_2019A>
    <_x0033_Q_x0020_2019A>3308.1080</_x0033_Q_x0020_2019A>
    <_x0034_Q_x0020_2019A>3911.1380</_x0034_Q_x0020_2019A>
    <_x0032_019_x0020_FYA />
    <_x0031_Q_x0020_2020A>2798.3300</_x0031_Q_x0020_2020A>
    <_x0032_Q_x0020_2020A>3054.0900</_x0032_Q_x0020_2020A>
    <_x0033_Q_x0020_2020A>$3,851.0000</_x0033_Q_x0020_2020A>
    <_x0034_Q_x0020_2020A>4495.1620</_x0034_Q_x0020_2020A>
    <_x0032_020_x0020_FYA>14198.5820</_x0032_020_x0020_FYA>
    <_x0031_Q_x0020_2021E>4187.6225</_x0031_Q_x0020_2021E>
    <_x0032_Q_x0020_2021E>4701.8271</_x0032_Q_x0020_2021E>
    <_x0033_Q_x0020_2021E>4902.8013</_x0033_Q_x0020_2021E>
    <_x0034_Q_x0020_2021E>4929.6456</_x0034_Q_x0020_2021E>
    <_x0032_021_x0020_FYE>18721.8968</_x0032_021_x0020_FYE>
    <_x0031_Q_x0020_2022E>4980.5665</_x0031_Q_x0020_2022E>
    <_x0032_Q_x0020_2022E>5074.0862</_x0032_Q_x0020_2022E>
    <_x0033_Q_x0020_2022E>5281.4401</_x0033_Q_x0020_2022E>
    <_x0034_Q_x0020_2022E>5307.0933</_x0034_Q_x0020_2022E>
    <_x0032_022_x0020_FYE>20643.1862</_x0032_022_x0020_FYE>
    <_x0031_Q_x0020_2023E>4201.8093</_x0031_Q_x0020_2023E>
    <_x0032_Q_x0020_2023E>4211.1577</_x0032_Q_x0020_2023E>
    <_x0033_Q_x0020_2023E>4220.5062</_x0033_Q_x0020_2023E>
    <_x0034_Q_x0020_2023E>4220.5062</_x0034_Q_x0020_2023E>
    <_x0032_023_x0020_FYE>16853.9796</_x0032_023_x0020_FYE>
   <GroupKey>Consensus Model~Total Revenue~TRIN~NBM~~1~ZB</GroupKey>
  </dgvViewAll_Vertical>

Dave Kreskowiak10-Apr-21 4:23

Dave Kreskowiak

10-Apr-21 4:23

So what? You STILL don't have anything in that XML called "Section".

If this XML is being written incorrectly, I think the problem would come down to the code that generated the original datatable and/or the code that wrote it to the file.

Asking questions is a skill
CodeProject Forum Guidelines
Google: C# How to debug code
Seriously, go read these articles.

Dave Kreskowiak

OriginalGriff10-Apr-21 7:57

10-Apr-21 7:57

The underscore character '_' is not a "special character" in XML data - it does not indicate to anything standard that the hex value between a pair of underscores should be treated as a single Unicode character. It's just a valid character in an element name, is all. So an XML element called "Section_x0020_" is not equivalent to a table column called "Section " or even "Section" - it becomes a column named "Section_x0020_" is all.

Even if it was - which it isn't - ending a field or element name with an "invisible character" would be a very poor practice!

OriginalGriff10-Apr-21 8:00

10-Apr-21 8:00

Just as a thought, see here: The Naming of Parts[^]

Richard MacCutchan10-Apr-21 21:07

Richard MacCutchan

10-Apr-21 21:07

I much prefer Naming of Parts[^]

jschell17-Apr-21 7:09

jschell

17-Apr-21 7:09

I think the preference depends on who is doing the reading (reading it out loud) and how much wine is involved.

Mou_kol10-Apr-21 3:00

10-Apr-21 3:00

Yes issue fixed. sharing working code.

string QCViewPath_savepath = @"C:\Test.xml";
    DataSet ds = new DataSet();
    ds.ReadXml(QCViewPath_savepath);

    if (ds.Tables[0].AsEnumerable().Any(a => a.Field<string>("Section ") == "ML"
             && a.Field<string>("GroupKey").Split('~')[0].Trim() == "Consensus Model"
             && a.Field<string>("GroupKey").Split('~')[1].Trim() == "Net Revenue"
             && a.Field<string>("GroupKey").Split('~')[3].Trim() == "NBM"
             && a.Field<string>("GroupKey").Split('~')[5].Trim() == "1"
             && a.Field<string>("GroupKey").Split('~')[6].Trim() == "ML"
                    ))
    {

        ds.Tables[0].AsEnumerable().Where(a => a.Field<string>("Section ") == "ML"
             && a.Field<string>("GroupKey").Split('~')[0].Trim() == "Consensus Model"
             && a.Field<string>("GroupKey").Split('~')[1].Trim() == "Net Revenue"
             && a.Field<string>("GroupKey").Split('~')[3].Trim() == "NBM"
             && a.Field<string>("GroupKey").Split('~')[5].Trim() == "1"
             && a.Field<string>("GroupKey").Split('~')[6].Trim() == "ML"
             ).ToList<DataRow>()
             .ForEach(r =>
             {
                 r["2010 FYA"] = 1200;
             });

        //foreach (var row in rowsToUpdat)
        //{
        //    row.SetField("2010 FYA", "1200");
        //}
    }

Richard Deeming11-Apr-21 21:23

Richard Deeming

11-Apr-21 21:23

.Any(...) followed by .Where(...).ToList() will be rather inefficient. Just call .Where(...).ToList(); if there are no matching elements, the list will be empty.

You'd also be better skipping the .ToList(), and using a foreach loop instead. You're not changing anything that would cause the "collection was modified" error, or cause rows to be skipped, so you don't need the extra overhead of a List<T>.

IEnumerable<DataRow> recordsToUpdate = ds.Tables[0].AsEnumerable().Where(a => ...);
foreach (DataRow row in recordsToUpdate)
{
    row["2010 FYA"] = 1200;
}

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Mou_kol12-Apr-21 7:06

Re: Hour and minute slider

12-Apr-21 7:06

Thanks for the guide line.

Hour and minute slider

Valakik8-Apr-21 9:49

Valakik

8-Apr-21 9:49

Hello
I find on the internet many slider on the internet from 0-10 and so on but I don't find any for hour and minute.
I am trying to make something like this (jquery): https://codepen.io/caseymhunt/pen/kertA

I don't know how I can make in C# winform. I just need to able select beginning and ending of the hour and minute. When moving the slider then increasing and decreasing with 15 minutes.
Is there an open source for this or how I can make this? The design can be basic too, I just need the function to work.
I don't have any idea how to make this possible.

Thank you in advance all of the answers.

OriginalGriff8-Apr-21 22:20

Re: Hour and minute slider

8-Apr-21 22:20

Create a UserControl, and start there.
Give it a fixed height, and add four "points": minimum, maximum, low, high.
These are probably integer values which do not relate in any way directly to hours and minutes, so the control can be flexible.
Handle the Paint event to draw the control and two "handles" that you can move.
Handle the MouseDown, MouseUp, and MouseMove events to let you move the handles.
As they move, update the low and high values.

Provide properties to read the values, and in there translate the integers to hours and minutes - perhaps return a timespan? One digit move could be your fifteen minutes.

Provide an event to indicate "slider changed" so the outside world can react to it.

BillWoodruff9-Apr-21 4:19

BillWoodruff

9-Apr-21 4:19

put two System.Windows.Forms.TrackBar Controls on a form: tBarHour, tBarMinute. Configure:

// tBarHour
// 
this.tBarHour.LargeChange = 4;
this.tBarHour.Location = new System.Drawing.Point(280, 148);
this.tBarHour.Maximum = 23;
this.tBarHour.Name = "tBarHour";
this.tBarHour.Size = new System.Drawing.Size(375, 45);
this.tBarHour.TabIndex = 11;
this.tBarHour.Value = 12;
this.tBarHour.ValueChanged += new System.EventHandler(this.tBarHourMinute_ValueChanged);
// 
// tBarMinute
// 
this.tBarMinute.LargeChange = 10;
this.tBarMinute.Location = new System.Drawing.Point(280, 200);
this.tBarMinute.Maximum = 59;
this.tBarMinute.Name = "tBarMinute";
this.tBarMinute.Size = new System.Drawing.Size(375, 45);
this.tBarMinute.TabIndex = 12;
this.tBarMinute.ValueChanged += new System.EventHandler(this.tBarHourMinute_ValueChanged);

The Minimum TrackBar value is #0 by default.

Set the ValueChanged event handler for both TrackBars to:

private TimeSpan tSpan;

private string tSpanStr;

private void tBarHourMinute_ValueChanged(object sender, EventArgs e)
{
    tSpan = new TimeSpan(0, tBarHour.Value, tBarMinute.Value, 0);

    tSpanStr = tSpan.ToString());
}

«One day it will have to be officially admitted that what we have christened reality is an even greater illusion than the world of dreams.» Salvador Dali

modified 9-Apr-21 11:39am.

C# Linq Get Count of Joined Records

Kevin Marois8-Apr-21 9:34

Kevin Marois

8-Apr-21 9:34

I have the following query.

There is a one-to-many relationship between Jobs->JobSequenceSheets.

I'm joining to JobSequenceSheets. But what I really want is just the COUNT of the JobSequenceSheets records for each Job record.

I'm not sure how to do this. Can someone help?

var datas = (from j in dc.Jobs
            join p in dc.Projects on j.ProjectId equals p.Id
            join cty in dc.Cities on p.CityId equals cty.Id
            join cl in dc.CompanyLocations on p.LocationId equals cl.Id
            let jsdr = dc.JobStartDateRevisions.Where(q => q.JobId == j.Id)
                                               .OrderByDescending(q => q.Revision)
                                               .Take(1)
                                               .FirstOrDefault()

            join jss in dc.JobSequenceSheets on j.Id equals jss.JobId
            let lots = dc.JobSequenceSheets.Where(q => q.JobId == j.Id).Count()

            where (jsdr != null && jsdr.StartDate >= startDate && jsdr.StartDate <= endDate)

            select new
            {
                JobId = j.Id,
                JobNumber = j.JobNumber,
                Lots = j.Lots,

                StartDate = jsdr.StartDate,

                ProjectId = p.Id,
                ProjectNumber = p.ProjectNumber,
                ProjectName = p.ProjectName,

                CityId = cty.Id,
                City = cty.City1,

                LocationId = cl.Id,
                Location = cl.Location,

            }).OrderBy(x => x.Location)
              .ThenBy(x => x.ProjectName)
              .ThenBy(x => x.StartDate).ToList();

If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.

Re: C# Linq Get Count of Joined Records

OriginalGriff8-Apr-21 9:40

Re: C# Linq Get Count of Joined Records

8-Apr-21 9:40

Can't you just do that with a GROUP BY?

Kevin Marois8-Apr-21 9:50

Kevin Marois

8-Apr-21 9:50

Probably, but I'm not sure of the syntax

If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.

Re: C# Linq Get Count of Joined Records

OriginalGriff8-Apr-21 10:05

8-Apr-21 10:05

I've no idea what your DB looks like, but if you have a table containing a foreign key to another, then it's pretty simple.
Assume a Invoices system for simplicity. It contains two tables:
Invoices

ID
InvoiceDate
CustomerID
...

InvoiceLines

ID
InvoiceID
ProductID
Quantity
UnitPrice
...

So to get the number of Lines per Invoice it's simple to use a group:

SQL

SELECT InvoiceID, COUNT(ID)
FROM InvoiceLines
GROUP BY InvoiceID

So if I issue two invoices:

ID = 1, InvoiceDate = #2021-04-07#, ...
ID = 2, InvoiceDate = #2021-04-08#, ...

ID = 1, InvoiceID = 1, ...
ID = 2, InvoiceID = 1, ...
ID = 3, InvoiceID = 1, ...
ID = 4, InvoiceID = 1, ...
ID = 5, InvoiceID = 2, ...
ID = 6, InvoiceID = 2, ...
ID = 7, InvoiceID = 2, ...

Then the query returns:

1, 4
2, 3

Which sounds like what you are looking for.

Client Server

Member 141922168-Apr-21 8:18

Member 14192216

8-Apr-21 8:18

Good evening everyone, in fact I finished my Point of Sale application on C # .net and SQL server. On the development pc everything is working fine, my concern is to make the application usable in multi-workstation with an Internet connection I have tried everything but to no avail ...
Please if anyone has a solution or an idea to solve this problem.
Thanks for your help

OriginalGriff8-Apr-21 8:45

8-Apr-21 8:45

What problem?
We have no idea what you have done, what you have tried, or even what you are trying to do!

SeanChupas8-Apr-21 9:26

SeanChupas

8-Apr-21 9:26

Member 14192216 wrote:
Please if anyone has a solution or an idea to solve this problem.

It's very easy. The client app needs to be able to access the server app. Usually you install sql server on a machine and then change the connection string to point to that server.

Not to be too critical, but how did you build a POS system without knowing how to change a connection string?

Member 141922168-Apr-21 10:53

Member 14192216

8-Apr-21 10:53

This connection string can be changed by what? show me please i'm limited by that