|
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.
<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>
|
|
|
|
|
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.
|
|
|
|
|
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!
"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!
|
|
|
|
|
Just as a thought, see here: The Naming of Parts[^]
"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!
|
|
|
|
|
|
I think the preference depends on who is doing the reading (reading it out loud) and how much wine is involved.
|
|
|
|
|
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;
});
}
|
|
|
|
|
.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
|
|
|
|
|
Thanks for the guide line.
|
|
|
|
|
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.
|
|
|
|
|
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.
"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!
|
|
|
|
|
put two System.Windows.Forms.TrackBar Controls on a form: tBarHour, tBarMinute. Configure:
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);
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.
|
|
|
|
|
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.
|
|
|
|
|
Can't you just do that with a GROUP BY?
"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!
|
|
|
|
|
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.
|
|
|
|
|
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:
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.
"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!
|
|
|
|
|
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
|
|
|
|
|
What problem?
We have no idea what you have done, what you have tried, or even what you are trying to do!
"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!
|
|
|
|
|
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?
|
|
|
|
|
This connection string can be changed by what? show me please i'm limited by that
|
|
|
|
|
Where did you put it?
It's either hard coded in your code somewhere or it's in your apps app.config file. It's just text in either case.
|
|
|
|
|
Exposing an SQL Server directly to the web is a bad idea.
You should be putting your SQL Server behind a web service that handles all transactions with the SQL database. Your application on client machines should be interacting with this web service with an authenticated and secured connection (think SSL and HTTPS).
It sounds like you have a lot more work to do and your application is indeed NOT finished.
|
|
|
|
|
Listen to what Dave said - you need to understand the structure of a distributed (internet) solution. Do NOT expose SQL Server directly to the internet.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
|
Just thinking that a POS that actually needs a distributed system is also going to need to accept some card payment system anyways. And if the creator doesn't know what connectivity is that means they have not even attempted to put that in play.
So this is homework - not real.
|
|
|
|
|
Your POS talks to the database via a "Protocol" (look it up you need to learn what it means.)
There are a couple of ways to do that but the primary one for a distributed system these days for everything is via TCP/IP. That is what you are generically referring to as the "network". You should try to read something, just a little bit, on how TCP/IP works since that is also something you need to know.
Your POS is a "client". The SQL Server is a "Server". Those terms are relevant in TCP/IP.
There is a "connection string" which is defined in a configuration source, which will almost always be a file. So you need to learn about that "connection string" and how to configure it.
To create the correct connection string you will need to know either the "host name" or the "IP Address" (which is something you learn about in TCP/IP) to specify how your "Client" will find the "Server".
You can google for examples of SQL Server connection strings and also examples about how you set it up.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
