Re: C# or ASP.NET swtich(expr) expression can action on byte, long, String?(Engilsh is not my native language) - C# Discussion Boards

Re: C# or ASP.NET swtich(expr) expression can action on byte, long, String?(Engilsh is not my native language)

24-Jan-21 14:27

thank your reply
I guess boss get c/c++ test not .NET/C# test
Unfortunately my test is failed

Christian Graus19-Jan-21 9:54

Christian Graus

19-Jan-21 9:54

I guess if he's saying something that is untrue, create a project and show him you can switch on almost anything? That was a major step forward, he's thinking of C++ I reckon

Re: C# or ASP.NET swtich(expr) expression can action on byte, long, String?(Engilsh is not my native language)

Upin L24-Jan-21 14:40

Re: C# or ASP.NET swtich(expr) expression can action on byte, long, String?(Engilsh is not my native language)

24-Jan-21 14:40

thank your reply

Unfortunately i can not do this
(i mean => create a project and show him you can switch on almost anything...)
I am new for C#/.Net so i can not refute my boss

Right concept is very important for learning
And thanks you talk me the right answer

Christian Graus24-Jan-21 14:50

Christian Graus

24-Jan-21 14:50

That's just not how sh*t works. If you don't know C# well enough to show your boss he is wrong, you are in a world of trouble. You clearly should not have a boss who pays you to write code right now. You should leave this awful job, enrol in a course, and learn C#.

Re: C# or ASP.NET swtich(expr) expression can action on byte, long, String?(Engilsh is not my native language)

Upin L25-Jan-21 19:30

Re: C# or ASP.NET swtich(expr) expression can action on byte, long, String?(Engilsh is not my native language)

25-Jan-21 19:30

I know your meaning, and thanks your recommend

originally I am PHP engineer(almost 1 year), not C#/.Net engineer
But my boss want to use C# development
Os now I need use PHP and C# at same time/job

don't worry about trouble(

you are in a world of trouble

)
My boss is not first time do this(give me inappropriate information)
And thank you

20212a19-Jan-21 10:40

20212a

19-Jan-21 10:40

I cannot remember but it seems like a language I used in the past only allowed switches on integers. Christian implies that C++ is that way so my guess is your boss is not aware that most languages do allow switch on other types.

Re: C# or ASP.NET swtich(expr) expression can action on byte, long, String?(Engilsh is not my native language)

Upin L24-Jan-21 14:51

Re: C# or ASP.NET swtich(expr) expression can action on byte, long, String?(Engilsh is not my native language)

24-Jan-21 14:51

thank your reply

I just found c/c++/java on network for this problem
I not found any answer for c#/.Net

Now I feel confused about this test

20212a25-Jan-21 1:13

20212a

25-Jan-21 1:13

Upin L wrote:
confused

Why? Most all programming languages allow switching on various data types.

System.Windows.Forms.DataVisualization.Charting

Member 1483694318-Jan-21 1:40

Re: System.Windows.Forms.DataVisualization.Charting

18-Jan-21 1:40

Hi,

I am developing a Work Load Analysis platform and there I use System.Windows.Forms.DataVisualization.Charting. The problem i have is, Xaxis is not updated when switching between different value types in runtime.
Here is the code, which i use to update chart from DateTime valuetype to int.

Here _EndWeek and _StartWeek are integer parameters pass to this method.

List<int> _Weeks = new List<int>();
int _Week_Difference = _EndWeek - _StartWeek;

for (int i = 0; i <= _Week_Difference; i++)
{
    _Weeks.Add(_StartWeek+ i);
}

chart_Utilization.Series[0].Points.Clear();
chart_Utilization.Series[1].Points.Clear();
chart_Utilization.Series[2].Points.Clear();

chart_Utilization.Series[0].XValueType = ChartValueType.Int32;
chart_Utilization.Series[1].XValueType = ChartValueType.Int32;
chart_Utilization.Series[2].XValueType = ChartValueType.Int32;

chart_Utilization.ChartAreas[0].AxisX.Interval = 1;
chart_Utilization.ChartAreas[0].AxisX.IntervalType = DateTimeIntervalType.Number;
chart_Utilization.ChartAreas[0].AxisX.IntervalOffsetType = DateTimeIntervalType.Number;

chart_Utilization.ChartAreas[0].AxisX.LabelStyle.Format = "{0:0}";
chart_Utilization.ChartAreas[0].AxisX.Minimum = 1;
chart_Utilization.ChartAreas[0].AxisX.Maximum = 53;

chart_Utilization.Update();

I would be glad, if some could help me in this case.

Gerry Schmitz18-Jan-21 2:35

Re: System.Windows.Forms.DataVisualization.Charting

18-Jan-21 2:35

You cleared all your points; I don't see you adding any back in.

chart_Utilization.Series[0].Points.Clear();
chart_Utilization.Series[1].Points.Clear();
chart_Utilization.Series[2].Points.Clear();

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food

Member 1483694318-Jan-21 5:09

Re: System.Windows.Forms.DataVisualization.Charting

18-Jan-21 5:09

The data is added in a loop after this piece of code. Data is added, but the X-Axis labelling is wrong. They are still in Datetime format.

Gerry Schmitz18-Jan-21 5:33

Re: System.Windows.Forms.DataVisualization.Charting

18-Jan-21 5:33

The x-axis usually is "time" in a time-series. You've provided no new information.

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food

Member 1483694318-Jan-21 6:27

Re: System.Windows.Forms.DataVisualization.Charting

18-Jan-21 6:27

I want to change the XAxis Value type to Int. How can i change it in runtime?
Because, the XAxis value type is dynamically changed according to the filter inputs from the user.

Gerry Schmitz18-Jan-21 15:57

Re: System.Windows.Forms.DataVisualization.Charting

18-Jan-21 15:57

Then add "int" (object) points after your delete the previous points.

DataPointCollection.AddXY Method (System.Web.UI.DataVisualization.Charting) | Microsoft Docs

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food

Member 1483694318-Jan-21 18:15

Re: System.Windows.Forms.DataVisualization.Charting

18-Jan-21 18:15

Thanks a lot for your reply. I created sample application with same code here for your reference.
This method is called when form is loaded.

private void Format_Chart()
{

    ChartArea _Area = new ChartArea("Utilization");
    _Area.AlignmentOrientation = AreaAlignmentOrientations.Vertical;
    _Area.AlignmentStyle = AreaAlignmentStyles.All;
    chart_Utilization.ChartAreas.Add(_Area);
    chart_Utilization.ChartAreas["Utilization"].Position = new ElementPosition(0, 10, 100, 90);

    chart_Utilization.Series.Clear();

    Series _Series_Current_Utilization = new Series("Current Utilization");
    _Series_Current_Utilization.ChartArea = _Area.Name;
    _Series_Current_Utilization.XValueType = ChartValueType.Date;
    _Series_Current_Utilization.YValueType = ChartValueType.Double;
    _Series_Current_Utilization.YValuesPerPoint = 1;
    _Series_Current_Utilization.ChartType = SeriesChartType.StackedColumn;
    _Series_Current_Utilization.Color = Color.FromArgb(200, 20, 191, 154);

    Series _Series_Over_Utilization = new Series("Over Utilization");
    _Series_Over_Utilization.ChartArea = _Area.Name;
    _Series_Over_Utilization.XValueType = ChartValueType.Date;
    _Series_Over_Utilization.YValueType = ChartValueType.Double;
    _Series_Over_Utilization.YValuesPerPoint = 1;
    _Series_Over_Utilization.ChartType = SeriesChartType.StackedColumn;
    _Series_Over_Utilization.Color = Color.Red;//Color.FromArgb(80, 255, 0, 0);

    Series _Series_Target_Utilization = new Series("Target Utilization");
    _Series_Target_Utilization.ChartArea = _Area.Name;
    _Series_Target_Utilization.XValueType = ChartValueType.Date;
    _Series_Target_Utilization.YValueType = ChartValueType.Double;
    _Series_Target_Utilization.YValuesPerPoint = 1;
    _Series_Target_Utilization.ChartType = SeriesChartType.Line;
    _Series_Target_Utilization.Color = Color.FromArgb(200, 20, 191, 154);

    chart_Utilization.Series.Add(_Series_Current_Utilization);
    chart_Utilization.Series.Add(_Series_Over_Utilization);
    chart_Utilization.Series.Add(_Series_Target_Utilization);

    chart_Utilization.Legends[_Series_Current_Utilization.Legend].Docking = Docking.Top;
    chart_Utilization.Legends[_Series_Current_Utilization.Legend].Alignment = StringAlignment.Center;

    chart_Utilization.Legends[_Series_Target_Utilization.Legend].Docking = Docking.Top;
    chart_Utilization.Legends[_Series_Target_Utilization.Legend].Alignment = StringAlignment.Center;

    chart_Utilization.Legends[_Series_Over_Utilization.Legend].Docking = Docking.Top;
    chart_Utilization.Legends[_Series_Over_Utilization.Legend].Alignment = StringAlignment.Center;

    chart_Utilization.ChartAreas[0].AxisX.LabelStyle.Format = "yyyy-MM-dd";
    chart_Utilization.ChartAreas[0].AxisX.Interval = 1;
    chart_Utilization.ChartAreas[0].AxisX.IntervalType = DateTimeIntervalType.Days;
    chart_Utilization.ChartAreas[0].AxisX.IntervalOffset = 1;

    chart_Utilization.ChartAreas[0].AxisY.Maximum = (double)(120);
    chart_Utilization.ChartAreas[0].AxisY.Minimum = (double)(0);
}

There are two button click events to change the value type of XAxis.

1. To change to ChartValueType.Date

private void btnDates_Click(object sender, EventArgs e)
        {
            List<double> _Values = new List<double>();
            int _Count = 1;

            for(int i = 0; i < 10; i++)
            {
                _Values.Add(i * 2.5d);
            }
            chart_Utilization.Series["Current Utilization"].Points.Clear();
            chart_Utilization.Series["Over Utilization"].Points.Clear();
            chart_Utilization.Series["Target Utilization"].Points.Clear();

            chart_Utilization.Series["Current Utilization"].XValueType = ChartValueType.Date;
            chart_Utilization.Series["Over Utilization"].XValueType = ChartValueType.Date;
            chart_Utilization.Series["Target Utilization"].XValueType = ChartValueType.Date;

            chart_Utilization.ChartAreas[0].AxisX.Interval = 1;
            chart_Utilization.ChartAreas[0].AxisX.IntervalType = DateTimeIntervalType.Days;
            chart_Utilization.ChartAreas[0].AxisX.IntervalOffset = 1;

            foreach(double _dval in _Values)
            {
                var _point_current = new DataPoint(chart_Utilization.Series["Current Utilization"]);
                var _point_target = new DataPoint(chart_Utilization.Series["Target Utilization"]);
                var _point_over = new DataPoint(chart_Utilization.Series["Over Utilization"]);

                _point_current.SetValueXY(new DateTime(DateTime.Now.Year, DateTime.Now.Month, _Count), _dval);
                _point_target.SetValueXY(new DateTime(DateTime.Now.Year, DateTime.Now.Month, _Count), _dval);
                _point_over.SetValueXY(new DateTime(DateTime.Now.Year, DateTime.Now.Month, _Count), _dval);

                chart_Utilization.Series["Current Utilization"].Points.Add(_point_current);
                chart_Utilization.Series["Target Utilization"].Points.Add(_point_target);
                chart_Utilization.Series["Over Utilization"].Points.Add(_point_over);

                _Count++;
            }
        }

2. To change to ChartValue type to Int

private void btnInt_Click(object sender, EventArgs e)
        {
            List<double> _Values = new List<double>();
            int _Count = 1;

            for (int i = 0; i < 10; i++)
            {
                _Values.Add(i * 5d);
            }

            chart_Utilization.Series[0].Points.Clear();
            chart_Utilization.Series[1].Points.Clear();
            chart_Utilization.Series[2].Points.Clear();

            chart_Utilization.Series[0].XValueType = ChartValueType.Int32;
            chart_Utilization.Series[1].XValueType = ChartValueType.Int32;
            chart_Utilization.Series[2].XValueType = ChartValueType.Int32;

            chart_Utilization.ChartAreas[0].AxisX.Interval = 1;
            chart_Utilization.ChartAreas[0].AxisX.IntervalType = DateTimeIntervalType.NotSet;
            chart_Utilization.ChartAreas[0].AxisX.IntervalOffsetType = DateTimeIntervalType.NotSet;

            chart_Utilization.ChartAreas[0].AxisX.LabelStyle.Format = "{0:0}";
            chart_Utilization.ChartAreas[0].AxisX.Minimum = 1;
            chart_Utilization.ChartAreas[0].AxisX.Maximum = 53;

            chart_Utilization.Update();

            foreach (double _dval in _Values)
            {
                var _point_current = new DataPoint(chart_Utilization.Series["Current Utilization"]);
                var _point_target = new DataPoint(chart_Utilization.Series["Target Utilization"]);
                var _point_over = new DataPoint(chart_Utilization.Series["Over Utilization"]);

                _point_current.SetValueXY(_Count, _dval);
                _point_target.SetValueXY(_Count, _dval);
                _point_over.SetValueXY(_Count, _dval);

                chart_Utilization.Series["Current Utilization"].Points.AddXY(_Count, _dval);
                chart_Utilization.Series["Target Utilization"].Points.AddXY(_Count, _dval);
                chart_Utilization.Series["Over Utilization"].Points.AddXY(_Count, _dval);

                _Count++;
            }
        }

When i switch from Date to Int, the XAxis labelling still apears as DateTime value type. This is my issue.
Please let me know in which way i can solve this issue.

Member 1483694318-Jan-21 19:32

Re: System.Windows.Forms.DataVisualization.Charting

18-Jan-21 19:32

I solved the problem by myself.

It is by setting IsXValueIndexed = true for each series allocated for the chart area.

Gerry Schmitz19-Jan-21 4:31

How to use Excel's pivot table and pivot chart functionality in C#?

19-Jan-21 4:31

Good to hear.

Samples Environments for Microsoft Chart Controls in C#, HTML

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food

Alex Dunlop16-Jan-21 18:44

Alex Dunlop

16-Jan-21 18:44

I want to load an Excel file which contains my data, then create pivot table and pivot chart based on that file. Is there any library (free one) that can do this without limitation? Confused | :confused:

Re: How to use Excel's pivot table and pivot chart functionality in C#?

Richard MacCutchan16-Jan-21 22:37

Richard MacCutchan

16-Jan-21 22:37

Alex Dunlop wrote:
Is there any library ...

That is a question for Google. The generally useful libraries for accessing Excel data are in Microsoft.Office.Interop.Excel Namespace | Microsoft Docs[^], and the Microsoft Access Database Engine 2016 Redistributable from Official Microsoft Download Center[^].

change data by using a removable disk

Member 1504609314-Jan-21 6:40

Member 15046093

14-Jan-21 6:40

How to change data by using a removable disk in C Sharp language

OriginalGriff14-Jan-21 7:47

OriginalGriff

14-Jan-21 7:47

You're going to have to be a lot clearer about what your problem is: 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.

"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 1504609314-Jan-21 9:11

Member 15046093

14-Jan-21 9:11

I have a database designed in C Sharp, and I have to modify this data via the Internet remotely. I want a way to modify the data by means of a removable disk so that the user takes the disk and inserted it into his device and then the modification is done

OriginalGriff14-Jan-21 9:21

OriginalGriff

14-Jan-21 9:21

You can't do that automatically anymore - at least not without getting the user to change his settings, and that dangerous: Using AutoPlay and AutoRun in Windows 10 (Article from SamLogic)[^]
It's dangerous because it means any executable disk that's inserted will autorun, and it was disabled because of virus / trojan activity using it. Certainly, I wouldn't enable it on my systems!

So you would have to run an app on the client computer that either processes the data, or which detects a removable disk being inserted - this may help: Detecting USB Drive Removal in a C# Program[^]

Member 1504609314-Jan-21 9:36

Member 15046093

14-Jan-21 9:36

You don't understand what I mean yet

I have a database of 500 employees
And I have another device with the same employee database that I have. I want in the event that I change the employee's data, then transfer the update to the disk and give it to the user to get the update on the data of his employees