C# Discussion Boards - CodeProject

Re: Triangles count in Graph

19-Nov-22 20:20

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 - we get no other context for your project.
Imagine this: you go for a drive in the country, but you have a problem with the car. You call the garage, say "it broke" and turn off your phone. How long will you be waiting before the garage arrives with the right bits and tools to fix the car given they don't know what make or model it is, who you are, what happened when it all went wrong, or even where you are?

That's what you've done here. So stop typing as little as possible and try explaining things to people who have no way to access your project!

Just saying "counts the numbers of triangles in a Graph" means nothing to us without context: and even if it did, there are other problems:
1) We aren't here to do your homework
2) Your teacher is almost certainly aware of sites like this, and handing in code you "found on the internet" as your own work is called plagiarism: and the punishment for that can include expulsion from your school. Even if it doesn't, unless you write your own code, you won't learn how to - which means you will fail your final exams. Think about it: you can watch as much Tour de France as you want - it still won't teach you how to ride a bicycle!

"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!

Gerry Schmitz20-Nov-22 5:13

Gerry Schmitz

20-Nov-22 5:13

You should be able to figure it out from the data if you understand what the "markers" represent; e.g. daily hi / lo.

If you don't understand what the markers represent, counting them is pointless.

"Before entering on an understanding, I have meditated for a long time, and have foreseen what might happen. It is not genius which reveals to me suddenly, secretly, what I have to say or to do in a circumstance unexpected by other people; it is reflection, it is meditation." - Napoleon I

Dynamic table insert issue with dates

Vijay Bhaskar Oct202217-Nov-22 6:32

Vijay Bhaskar Oct2022

17-Nov-22 6:32

Hi,

I am trying to insert into sql from Dynamic object ,
But insert failed with date type values,

Can some one suggest how can I handle this situation please.

command.CommandText = "INSERT INTO table VALUES (" + "'" + string.Join("',' ", ((IDictionary<string, object="">)rec).Values) + "')";

here are object variable dates I am passing

[4] {31/05/2022 23:00:00 +00:00} object {System.DateTimeOffset}
[11] "2022-10-25 16:12:27" object {string}

Re: Dynamic table insert issue with dates

Slacker00717-Nov-22 6:46

Slacker007

17-Nov-22 6:46

Does this help: https://stackoverflow.com/questions/5695056/inserting-values-to-a-table-using-generic-dictionary[^]

With that said, I use Dapper for these types of things. NuGet Gallery | Dapper 2.0.123[^]

Re: Dynamic table insert issue with dates

OriginalGriff17-Nov-22 8:40

Re: Dynamic table insert issue with dates

17-Nov-22 8:40

Don't do it 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:

SQL

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:

SQL

SELECT * FROM MyTable WHERE StreetAddress = 'x';DROP TABLE MyTable;--'

Which SQL sees as three separate commands:

SQL

SELECT * FROM MyTable WHERE StreetAddress = 'x';

A perfectly valid SELECT

SQL

DROP TABLE MyTable;

A perfectly valid "delete the table" command

SQL

--'

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?

Richard Deeming17-Nov-22 21:37

Microsoft.Practices.Composite.Presentation.Events

17-Nov-22 21:37

As Griff said, your code is vulnerable to SQL Injection[^].

Fixing it to use parameters isn't too hard:

StringBuilder sb = new StringBuilder("INSERT INTO table VALUES (");
foreach (object value in ((IDictionary<string, object>)rec).Values)
{
    if (command.Parameters.Count != 0) sb.Append(", ");
    string name = "@V" + command.Parameters.Count;
    command.Parameters.AddWithValue(name, value);
    sb.Append(name);
}
sb.Append(");");

command.CommandText = sb.ToString();

However, this may still not work. You haven't specified the list of columns you want to insert into. And there's no guarantee that the dictionary's Values collection will return the values in the same order as the columns of the table. So you could end up trying to insert the wrong value into the wrong column, which will either result in an error, or in data corruption.

Assuming the keys of your dictionary match the column names from your table, you'll want something more like this:

StringBuilder columnsList = new StringBuilder();
StringBuilder valuesList = new StringBuilder();
foreach (KeyValuePair<string, object> item in (IDictionary<string, object>)rec)
{
    if (columnsList.Length != 0) columnsList.Append(", ");
    if (valuesList.Length != 0) valuesList.Append(", ");
    
    string name = "@" + item.Key;
    command.Parameters.AddWithValue(name, item.Value);
    columnsList.Append(item.Key);
    valuesList.Append(name);
}

command.CommandText = "INSERT INTO table (" + columnsList + ") VALUES (" + valuesList + ");";

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

Kevin Marois16-Nov-22 12:14

Kevin Marois

16-Nov-22 12:14

I updated a project from .Net Framework 4.7 to .Net Core 6.

I'm getting compilation errors saying it can't find "Microsoft.Practices.Composite.Presentation.Events"

Is this depracated? Anyone know what the new namespace is? I've been Googling and can't find it.

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

Re: Microsoft.Practices.Composite.Presentation.Events

Dave Kreskowiak16-Nov-22 12:49

Dave Kreskowiak

16-Nov-22 12:49

It looks like that was part of the Microsoft Patterns & Practices Enterprise library, which has been deprecated and no longer supported.

I don't know of any replacement library for it.

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

Dave Kreskowiak

Re: Microsoft.Practices.Composite.Presentation.Events

Richard Deeming16-Nov-22 21:31

I'm getting error code CS1001. And I'm not sure how to diagnose the problem.

16-Nov-22 21:31

Looks like that library was a precursor of Prism:
https://stackoverflow.com/questions/19657492/is-microsoft-practices-composite-earlier-version-of-microsoft-practices-prism[^]
What's New in Prism Library 5.0 for WPF | Microsoft Learn[^]

The latest version of Prism should work in .NET 6:
GitHub - PrismLibrary/Prism: Prism is a framework for building loosely coupled, maintainable, and testable XAML applications in WPF, Xamarin Forms, and Uno / Win UI Applications..[^]
NuGet Gallery | Prism.Wpf 8.1.97[^]

However, I've never used either library, so I have no idea how easy it will be to update your application.

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

Rakos4613-Nov-22 10:46

Rakos46

13-Nov-22 10:46

I am making a VR game and I have this script and it's getting a lot of errors. I only have one more error to diagnose, but I just can't figure out the problem. It's error code CS1001, and here is the script.

using PhotonVRManager;
using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using UnityEngine.UI;
using Photon;
using TMPro;
public class NameScript : MonoBehaviour
{
public string NameVar;
public TextMeshPro NameText;
private void Update()
{
if (NameVar.Length > 12);
{
NameVar = NameVar.Substring(0, 12);
}
NameText.text = NameVar;
PhotonVRManager.SetUsername(NameVar);
}
}

Re: I'm getting error code CS1001. And I'm not sure how to diagnose the problem.

Mycroft Holmes13-Nov-22 11:06

Mycroft Holmes

13-Nov-22 11:06

If you search for the error number CS1001 at DuckDuckGo[^] you will find it is declaring an enum. Where that is occurring is up to you to debug and find out check out the properties of TextMeshPro (guess only)

Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

Re: I'm getting error code CS1001. And I'm not sure how to diagnose the problem.

OriginalGriff13-Nov-22 18:53

Re: I'm getting error code CS1001. And I'm not sure how to diagnose the problem.

13-Nov-22 18:53

Since we have no idea where in that code the problem is being reported, we pretty much have to guess.
In this case, it's probably this line:

if (NameVar.Length > 12);

The semicolon ends the statement, so the following code block will be executed regardless of the if condition.

If you had indented your code properly - and Visual Studio will do that for you - =that would have been pretty obvious!

You should expect to get syntax errors every day, probably many times a day while you are coding - we all do regardless of how much experience we have! Sometimes, we misspell a variable, or a keyword; sometimes we forget to close a string or a code block. Sometimes the cat walks over your keyboard and types something really weird. Sometimes we just forget how many parameters a method call needs.

We all make mistakes.

And because we all do it, we all have to fix syntax errors - and it's a lot quicker to learn how and fix them yourself than to wait for someone else to fix them for you! So invest a little time in learning how to read error messages, and how to interpret your code as written in the light of what the compiler is telling you is wrong - it really is trying to be helpful!

So read this: How to Write Code to Solve a Problem, A Beginner's Guide Part 2: Syntax Errors[^] - it should help you next time you get a compilation error!

Calin Negru14-Nov-22 3:28

Calin Negru

14-Nov-22 3:28

It might help if you would copy past the error description here. The error code alone doesn’t say much to some of us

modified 14-Nov-22 9:37am.

Re: I'm getting error code CS1001. And I'm not sure how to diagnose the problem.

Victor Nijegorodov14-Nov-22 3:40

Victor Nijegorodov

14-Nov-22 3:40

Compiler Error CS1001 | Microsoft Learn

My Code gets stuck at MessageBox.Show() after pressing OK it does not move further.

Radheya Patil9-Nov-22 17:45

Re: My Code gets stuck at MessageBox.Show() after pressing OK it does not move further.

9-Nov-22 17:45

I have developed Console Application in .NET Compact Framework 3.5 for an embedded device.

I have a foreach loop which check for file exists. If file not found I have displayed message using MessageBox.
My message box pops up to 5 times due to use of for each loop. But at the end of 5th MessageBox display when i press Ok it gets stuck on

MessageBox.Show(p + "File Not Found...!!!!");

and does not go forward when checked in debugging mode

foreach (string p in TypeofProcess)
                    {
                        string FileToFetch1 = getFileName(p);
                        if (File.Exists(FileToFetch1))
                        {
                            using (StreamReader r = File.OpenText(FileToFetch1))
                            {
                                ReadAndDumpToCNC(r, 36000+i, 31000+i, 41000+i);
                            }
                        }
                        else
                        {
                            MessageBox.Show(p + "File Not Found...!!!!");
                        }
                        i = i + 1000;
                    }

OriginalGriff9-Nov-22 18:48

Re: My Code gets stuck at MessageBox.Show() after pressing OK it does not move further.

9-Nov-22 18:48

What do you mean "does not go forward when checked in debugging mode"?

What exactly did you do, and what exactly did you find using the debugger?
And why use MessageBox in a Console app at all?

Radheya Patil10-Nov-22 1:05

Re: My Code gets stuck at MessageBox.Show() after pressing OK it does not move further.

10-Nov-22 1:05

Hi, i deployed the code on my embedded device for debugging, when file is not found message box will show to alert user. However after completion of foreach loop code should continue further, right?? But when i pause my code it is still stuck at line Message.ShowBox. Code after foreach loop does not get execute.

Richard Deeming10-Nov-22 1:24

Re: My Code gets stuck at MessageBox.Show() after pressing OK it does not move further.

10-Nov-22 1:24

You haven't shown any code after the foreach loop, so we have no idea whether it should continue.

Does the message actually show? Have you dismissed it? Does the MessageBox.Show method actually return control to your code?

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

Radheya Patil10-Nov-22 1:42

Re: My Code gets stuck at MessageBox.Show() after pressing OK it does not move further.

10-Nov-22 1:42

The below code runs in an infinite loop in console application. Message box is shown and user press OK everytime it is shown. At last iteration of foreach loop when user press ok it should continue to check next if condition in an infinite loop, mean while it does not. And when i pause my code to check where the control of the code is, it shows me control at Message.ShowBox line and even after pressing step over it still remains at that place.

Just for info.. it is developed in .net Compact 3.5 in visual studio 2008

for(;;)
{
if (CheckBitData(5, 965) == true)                                   //Checking Read Request from File to Mac
                {
                    string[] TypeofProcess = { "P", "V", "F", "C", "Q" };
                    int i = 0;
                    foreach (string p in TypeofProcess)
                    {
                        string FileToFetch1 = getFileName(p);
                        if (File.Exists(FileToFetch1))
                        {
                            using (StreamReader r = File.OpenText(FileToFetch1))
                            {
                                ReadAndDumpToCNC(r, 36000+i, 31000+i, 41000+i);
                            }
                        }
                        else
                        {
                            MessageBox.Show(p + "File Not Found...!!!!");
                        }
                        i = i + 1000;
                    }

                    MakeZeroPMC(5, 965);
                }

                if (CheckBitData(5, 967) == true)                                   // Data File Generation using History Data
                {
                    ManipulateArray(31000, 31999, 41000, 36000, 11075, 11076);      //(readStart,readEnd,wrStart1,wrStart2,MaxVar,MinVar)
                    MakeMasterData("Power", "Max", 41000, 41999);
                    MakeMasterData("Power", "Min", 36000, 36999);
                    ManipulateArray(32000, 32999, 42000, 37000, 11077, 11078);
                    MakeMasterData("Voltage", "Max", 42000, 42999);
                    MakeMasterData("Voltage", "Min", 37000, 37999);
                    ManipulateArray(33000, 33999, 43000, 38000, 11079, 11080);
                    MakeMasterData("Freq", "Max", 43000, 43999);
                    MakeMasterData("Freq", "Min", 38000, 38999);
                    ManipulateArray(34000, 34999, 44000, 39000, 11081, 11082);
                    MakeMasterData("Curr", "Max", 44000, 44999);
                    MakeMasterData("Curr", "Min", 39000, 39999);
                    ManipulateArray(35000, 35999, 45000, 40000, 11083, 11084);
                    MakeMasterData("Quench", "Max", 45000, 45999);
                    MakeMasterData("Quench", "Min", 40000, 40999);
                    MakeZeroPMC(5, 967);
                }

                if (CheckBitData(5, 968) == true)                                   
                {
                    DumpMasterDataG1V();
                    MakeZeroPMC(5, 968);
                }
                if (CheckBitData(5, 969) == true)                                   
                {
                    DumpMasterDataG1Q();
                    MakeZeroPMC(5, 969);
                }
                if (CheckBitData(5, 970) == true)                                   
                {
                    DumpMasterDataG2V();
                    MakeZeroPMC(5, 970);
                }
                if (CheckBitData(5, 971) == true)                                   
                {
                    DumpMasterDataG2Q();
                    MakeZeroPMC(5, 971);
                }
            
                System.Threading.Thread.Sleep(10);
            }

Richard Deeming10-Nov-22 2:00

Re: My Code gets stuck at MessageBox.Show() after pressing OK it does not move further.

10-Nov-22 2:00

"Step over" will execute the line, which will show the message box. The code won't continue until you press "OK" in that message box.

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

Radheya Patil10-Nov-22 16:37

Re: My Code gets stuck at MessageBox.Show() after pressing OK it does not move further.

10-Nov-22 16:37

Yes at last iteration also, it is executing message show box line then message show box appears then i press ok. Only after i press ok message box disappears and control of code remains on that same line it doesn't continue my for(;;). And my application doesn't responds to futher triggers

jsc4210-Nov-22 5:08

jsc42

10-Nov-22 5:08

How are you expecting to escape from your infinite loop? Your first line is

for(;;)

, so when your main inner loop has finished, it will start all over again unless you have a

break

lower down that we cannot see.

Re: My Code gets stuck at MessageBox.Show() after pressing OK it does not move further.

Radheya Patil10-Nov-22 16:39