|
If you create a GraphicsPath object for the points, you can use that to check:
System.Drawing.Drawing2D.GraphicsPath poly = new System.Drawing.Drawing2D.GraphicsPath();
poly.AddLine(10, 10, 90, 10);
poly.AddLine(90, 10, 90, 90);
poly.AddLine(90, 90, 10, 90);
poly.AddLine(10, 90, 10, 10);
Point inPoly = new Point(50, 50);
Point outPoly = new Point(0, 0);
Console.WriteLine(poly.IsVisible(inPoly) ? "IN" : "OUT");
Console.WriteLine(poly.IsVisible(outPoly) ? "IN" : "OUT");
The beauty of that is that the poly can be extremely complex and the framework will sort it out. For example, an hourglass:
System.Drawing.Drawing2D.GraphicsPath poly = new System.Drawing.Drawing2D.GraphicsPath();
poly.AddLine(10, 10, 90, 90);
poly.AddLine(90, 90, 10, 90);
poly.AddLine(10, 90, 90, 10);
poly.AddLine(90, 10, 10, 10);
Point inPoly = new Point(50, 40);
Point outPoly = new Point(40, 50);
Console.WriteLine(poly.IsVisible(inPoly) ? "IN" : "OUT");
Console.WriteLine(poly.IsVisible(outPoly) ? "IN" : "OUT");
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
How to get the WIFI and LAN usage in C#.
Also my requirement is to get the usage between specified date range.
|
|
|
|
|
This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind - we only get exactly what you type to work with.
So stop trying to type as little as possible and explain what it is you are trying to do, what you have tired, where you are stuck, and what help you need!
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Thanks Griff,
Actually I am new to this implementation. Just want to know any API, till now I haven't got any API.
|
|
|
|
|
API for what? You haven't told us what you want!
We can't see your screen, we can't access your HDD, we can't read your mind.
We really do only get exactly what you type ... no other context.
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
namespace ConsoleApplication2
{
using System;
using System.Diagnostics;
using System.Net.NetworkInformation;
using System.Threading;
class MainClass
{
static void Main()
{
NetworkInterface nic = NetworkInterface.GetAllNetworkInterfaces()[0];
IPv4InterfaceStatistics ip4 = nic.GetIPv4Statistics();
IPInterfaceStatistics ip = nic.GetIPStatistics();
long ip4data = ip4.BytesReceived + ip4.BytesSent;
long ipData = ip.BytesReceived + ip.BytesSent;
Console.WriteLine(ip4data + ipData);
NetworkInterface[] interfaces
= NetworkInterface.GetAllNetworkInterfaces();
foreach (NetworkInterface ni in interfaces)
{
if (ni.Name == "Ethernet")
{
Console.WriteLine("LAN Usage:");
Console.WriteLine(" Bytes Sent: {0}",
ni.GetIPv4Statistics().BytesSent);
Console.WriteLine(" Bytes Received: {0}",
ni.GetIPv4Statistics().BytesReceived);
}
else if (ni.Name.ToLower() == "wi-fi")
{
Console.WriteLine("WIFI Usage:");
Console.WriteLine(" Bytes Sent: {0}",
ni.GetIPStatistics().BytesSent);
Console.WriteLine(" Bytes Received: {0}",
ni.GetIPStatistics().BytesReceived);
}
}
}
}
}
Now can you answer?
This code is working for current system session, how do I modify to read after all the reboot session usage?
Something like below:
Windows 10 : Go to Settings -> Network & Internet -> Data Usage
You can see the 1 month data usage.
|
|
|
|
|
Hi,
I am working on some migration project where data is exported from Oracle DB to Excel sheets. Extraction tool is different which is able to extract data to Excel around 1 Million also. In extraction tool Oledb Data reader is using which is extracting successfully. Even its extracting more than 1 M data as well in to multiple sheets in the same excel like Sheet1,Sheet2 etc. I need to read the entire excel data and store it in Data table. its working fine for below 6 lac data. But when i am trying to read the data from Excel using OleDb Data Adapter or Data Reader its failing when records exceed 8 Lac and giving error like "System Resources exceeded." My server is free and nothing is running ther and its 64 GB ram as well.
Find the code snap below.
tried with both Data Adapter and Data reader.
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "SELECT * FROM [" + sheet + "]";
OleDbDataReader reader = cmd.ExecuteReader();
if (sheet.Contains(DocSheet))
{
dtDocExcelData.Load(reader);
LogWriter.LogWrite("No of Files/docs to process for the File : " + inputFilePath + " Sheet Rows Count : " + dtDocExcelData.Rows.Count);
}
else if (sheet.Contains(FileSheet))
{
dtFileExcelData.Load(reader);
LogWriter.LogWrite("No of Files/docs to process for the File : " + inputFilePath + " Sheet Rows Count : " + dtFileExcelData.Rows.Count);
}
cmd.ResetCommandTimeout();
cmd.Dispose();
reader.Dispose();
}
visual studio is 2013 version and code is in C#. Excel version is also latest as 2016 (.XLSX).
please check the above code part and let me know where it is failing to load the bulk data from excel. Is there any other way to resolve this.?
When i googled it, one option is patch update, but client may not be ready for patch update. Provide me any other alternative solutions to over come this. Project is going to live by month end. UAT is phase is failing. please give me alternate solution at earliest.
Awaiting for your valuable suggestions. Thanks in advance.
Regards,
Venkat
|
|
|
|
|
It looks like you're trying to load your entire sheet into memory all at once. It doesn't matter if you use a DataReader or a DataAdapter. The problem is being caused by trying to load all that data and keep it all in a DataTable.
First, you have to ask yourself if that is really necessary. What are you doing with all that data where you think you need to keep it all in memory at the same time?
In your Project Properties, is your app platform target set to x64 or AnyCPU? Is the "prefer 32-bit" checkbox cleared if the target is AnyCPU?
|
|
|
|
|
Hi Dave,
Thanks for your quick reply. Actually its require for my application where i need to read all excel data and reframe it and maintain the same parent child relationship of Source data like Folder and associated documents and then prepare the XML file as per Data table data. Extraction utility is working while we use Oracle Reader which is able to fetch and load the Data table for more than 1 Million records.
As you mentioned i verified the settings, its ANY CPU and Prefer 32 bit is unchecked already. Can we set the limit for Data reader or adapter through code or COnfig file.?
|
|
|
|
|
Try this. If your project doesn't already have one, add an app.config file to it, then open it up.
Add the following "runtime" tag to the configuration element:
<configuration>
<runtime>
<gcAllowVeryLargeObjects enabled="true" />
</runtime>
</configuration>
Recompile and try it again.
|
|
|
|
|
Hi Dave,
Thank you for your reply. Added in config file as you mentioned but even though its failing while reading data more than 8 Lac in excel file.
Regards,
Venkat
|
|
|
|
|
OK, then don't fill a DataSet with the data. Use a DataReader and read each record from the file and process it. Then go to the next record.
|
|
|
|
|
Hi,
i have to read the complete data and manipulate it as per business logic before making XML file. with multiple iterations i came to know Data Reader/Adapter is failing when records are more than 8 lac and up to 6 lac data coming correctly and data truncating after 6 lac.
Seems its issue with Data Reader for bulk records. now i am going to use Interop instead of Data reader which is giving the correct results in Data table even its crossing 8 lac.
|
|
|
|
|
I decided to port one of my vb apps over to c#, so far so good. I decided to give MongoDB a try and load the MongoDB.Bson, MongoDB.Driver, MongoDB.Driver.Core and MongoDB.Respository.Crud packages from Nuget. I went the repository route like I did in my Angular6 wrapped in .Net Core 2.2 App, but didn't think it through all the way, or it's sort of a test run with it.
It just occurred to me that on my repository DBContext configuration, that it uses the appSettings.json file and Microsoft.Extensions.Options to read the MongoDB values. I did some research and found that extension is tied to .Net Core 2. Well I guess I just answered my own question of how to find a workaround for it. This should work, just need to figure out where to initialize it, like in main form loading.
I was going to try that C# Mongo Driver but it hasn't been updated since 2010.
Is anybody else using MongoDB 4.0 in VS2017 c# Win Form, And have any experience with it?
I would to take .Net Core 3 for a test run on this project. It just makes sense to me since I have written lots of .Net Core 2 code already that I can reuse.
In my Angular .Net Core 2 App
public class CRMRepository : ICRMRepository
{
private readonly MongoDBContext _context = null;
public CRMRepository(IOptions<Settings> settings)
{
_context = new MongoDBContext(settings);
}
Proposed Thought
public class MongoDB {
public string Connection { get;set; }
public string Database { get; set; }
}
public class CRMRepository : ICRMRepository
{
private readonly MongoDBContext _context = null;
public CRMRepository(MongoDB _mongoDB)
{
_context = new MongoDBContext(_mongoDB);
}
If it ain't broke don't fix it
Discover my world at jkirkerx.com
|
|
|
|
|
I need to have 15 digits of precision (after the decimal point) on a double precision value when it's written to a file for comparison to some legacy code. I can't seen to get it work consistently.
For instance if I perform the following;
double d = 0.123456789012345
Debug.WriteLine(d.ToString("G15"));
I get the expected output of -> 0.123456789012345 15 trailing digits of precision as expected
Then if I have the following;
double d = 10.123456789012345;
Debug.WriteLine(d.ToString("G15"));
The output is -> 10.1234567890123 13 digits of trailing precision
Finally;
double d = 12345.123456789012345;
Debug.WriteLine(d.ToString("G15"));
The output is -> 12345.123456789 9 digits of precision after decimal point
Using good old C++ you can just specify "%.15lf" as a format specifier and always get 15 digits of precision. This just seems to give a specific number of digits based shifting the decimal point.
|
|
|
|
|
It seem to me that "G15" produces 15 digits, not 15 decimal places!
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
|
Try:
d.ToString("F15")But...Double values only have a precision of "15 ~ 17" digits (depending on the value, it's down to how they are stored as binary): double keyword (C# Reference) | Microsoft Docs[^] so specifying 15 digits after the decimal poitn is probably not going to work in many cases.
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Using "F15" produces the same result, this is maddening.
|
|
|
|
|
OriginalGriff wrote: But...Double values only have a precision of "15 ~ 17" digits (depending on the value, it's down to how they are stored as binary)... so specifying 15 digits after the decimal point is probably not going to work in many cases.
I suggest you read that part again. 
If the total precision of the number is 15-17 digits, and you have four digits before the decimal point, you're not going to be able to get 15 digits after the decimal point.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I get exactly what I expect:
double d = 0.123456789012345;
Debug.WriteLine(d.ToString("G15"));
d = 12345.123456789012345;
Debug.WriteLine(d.ToString("F15"));
0.123456789012345
12345.123456789000000
Remember what I said?
Quote: But...Double values only have a precision of "15 ~ 17" digits (depending on the value, it's down to how they are stored as binary): double keyword (C# Reference) | Microsoft Docs[^] so specifying 15 digits after the decimal poitn is probably not going to work in many cases.
If the double variable can only hold a total of 15~17 significant decimal digits, then you can't get 20 output of it!
Remember how double values are stored: as binary with a mantissa and an exponent. So the code (rightly) prints the same number of significant digits and pads the rest to the size you asked for.
To be honest, if you think any number you can come up with is going to be accurate to fifteen digits, you are very probably wrong! 
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Oh i totally agree with you on the accuracy thing.
Oddly enough in C when you do the same thing;
double d = 0.123456789012345;
char buf[20];
sprintf(buf, "%.15lf\n", d);
OutputDebugStringA(buf);
output is 0.123456789012345
d = 12345.123456789012345;
sprintf(buf, "%.15lf\n", d);
OutputDebugStringA(buf);
output is 12345.12345678901
I still get 2 more digits of precision and that's exactly what I'm fighting against.
|
|
|
|
|
Not really - The C version depends on the compiler. If I try with an online C compiler[^] I get:
0.123456789012345
12345.123456789011470 If I try with Virtual-C[^] I get this:
0.123456789012345
12345.123456789011135
IT's not "extra accurate digits" it's "different interpretation of the output". Because floating point numbers don't translate well into binary (for example, 0.2 in decimal is a fixed value, in binary is a repeating sequence so it isn't accurate) you can "generate" more digits if you take the first one, then multiple by 10.0 and repeat. That doesn't mean that the values to get are "more accurate" - in fact they are prone to reduced accuracy but a higher digit count. Try it again with some different numbers and you should see what I mean.
Generally speaking, all systems use the same floating point storage design: IEEE 754, (because if they don't they can't use floating point coprocessors to do the hard stuff!)
IEEE 754 - Wikipedia[^]
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
I've punted on this issue it will be interesting to see the results of the data analysis when I load this data back into the system and process against the original data. I'm dealing with nanometer measurement data.
Thanks for the help.
|
|
|
|
|
Hi Guys,
Below code don't allow to create entry at database with null areas and pop-up comes to warn user.
I fill all fields/create entry and all fields are cleared up for new entry but once I try to add new entry, program allows me to create with empty fields.
Do I need to add some code in order form to reload or something like that?
What would be the way of getting rid of this issue?
Thanks.
note: something other than Application.Restart(). that would be great if no close&open app.
private void btnStokEkle_Click_1(object sender, EventArgs e)
{
if (txtAdi.Text == "" || txtModel.Text == "" || txtSeriNo.Text == "" || gon.Text == "" || tah.Text == "")
{
MessageBox.Show("Lütfen Tüm Alanları Doldurunuz.", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
vt.sqlCalistir("insert into kolon (siparis,malzeme,takip,gonder,tahmini,gercek) values ('" + txtAdi.Text + "','" + txtModel.Text + "','" + txtSeriNo.Text + "','" + gon.Text + "','" + tah.Text + "', '" + tt.Text + "')");
MessageBox.Show("İşlem Kaydı Yapıldı.", "İşlem Tamam", MessageBoxButtons.OK, MessageBoxIcon.Information);
getir();
txtId.Clear();
txtAdi.Clear();
txtModel.Clear();
txtSeriNo.Clear();
gon.EditValue = " ";
tah.EditValue = " ";
tt.EditValue = " ";
txtSeriNo.Text = Environment.UserName;
}
modified 13-Feb-19 21:02pm.
|
|
|
|
|
Not like that! Never concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Always use Parameterized queries instead.
When you concatenate strings, you cause problems because SQL receives commands like:
SELECT * FROM MyTable WHERE StreetAddress = 'Baker's Wood' The quote the user added terminates the string as far as SQL is concerned and you get problems. But it could be worse. If I come along and type this instead: "x';DROP TABLE MyTable;--" Then SQL receives a very different command:
SELECT * FROM MyTable WHERE StreetAddress = 'x';DROP TABLE MyTable; Which SQL sees as three separate commands:
SELECT * FROM MyTable WHERE StreetAddress = 'x'; A perfectly valid SELECT
DROP TABLE MyTable; A perfectly valid "delete the table" command
And everything else is a comment.
So it does: selects any matching rows, deletes the table from the DB, and ignores anything else.
So ALWAYS use parameterized queries! Or be prepared to restore your DB from backup frequently. You do take backups regularly, don't you?
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
