Re: Array of classes nested into array of classes (and serialization) - C# Discussion Boards

Bobba Praneeth24-Mar-14 0:09

24-Mar-14 0:09

Hi fellow members

I'm working on a personal C# project , in which i estimate the budget - assets , account receivables , debts ... etc. The main requirement is that the code should not interact with a server side database , instead it can interact with a client MS access database. Wink | ;)

It has a snowflake schema . Need your help in understanding how we can setup a MS access database and use it in C# code.

If any such code is available ,please send the link.

Appreciate your help
Thanks
Praneeth

Bob.

Re: Developing a C# Project

Keith Barrow24-Mar-14 1:23

Keith Barrow

24-Mar-14 1:23

bobba praneeth wrote:
If any such code is available ,please send the link.

You really just need to google "c# ms access database tutorial", this returns in excess of 23,000,000 results. At least one of these is going to get you started.

Unless you are tied to Access for some reason, you could swap to SQL express, this will allow you to use Entity Framework which takes a lot of the effort out of pushing information in/out of objects.

PB 369,783 wrote:
I just find him very unlikeable, and I think the way he looks like a prettier version of his Mum is very disturbing.[^]

Re: Developing a C# Project

V.24-Mar-14 3:49

24-Mar-14 3:49

Here is an article I wrote on database connection[^], but if you can help it avoid Access databases. They are a pain in the ass. Both Oracle and SQL-Server have free versions out there and MySQL and PostgreSQL are also very good alternatives (both free as well)

If you're developing pure .Net I'd go for SQL-Server Express.

PS: My article is one way of doing things, there are other ways as well.

hope this helps.

V.

(MQOTD rules and previous solutions)

OriginalGriff wrote:
V is absolutely right

Re: Developing a C# Project

BobJanova24-Mar-14 3:58

BobJanova

24-Mar-14 3:58

The wording 'set up an Access database' implies you don't have it yet and therefore have a free choice of tech. In which case: don't use access. Even a System.Data.DataSet serialised to disk is probably better than that. Really you should set yourself up a proper ODBC data source (e.g. SQL Server, mySQL etc) and use System.Data to interact with it.

Re: Developing a C# Project

OriginalGriff24-Mar-14 6:23

OriginalGriff

24-Mar-14 6:23

Just to back up what the others say: if you are using this for multi-user at all - i.e. if at any time there will be more than one user using the database in any way, then Access is a poor solution, and will give you nasty problems. You do need to use a "proper" multiuser system, and that means SQL Server or MySql.

If you only ever need it for a single user, then Access will work, but I'd still be tempted to use SQLCE or SQLite instead - and I have Access on my system!

If you must use Access, then you need to install the appropriate ACE driver: 32 bit or 64 bit (you can't install them both on the same machine), and use OleDbConnection and OleDBCommand objects to access them: Google can help with that.

Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)

[solved] Array of classes nested into array of classes (and serialization)

Mario 5623-Mar-14 22:23

Mario 56

23-Mar-14 22:23

Many times in C/C++ I have used arrays of structs into struct and it was very nice and useful to aggregate data sets. Now with C# My question is, can I make the same using class ? I know, there are struct also in C#, but they are allocated into stack and I don't want use to much stack area, and I have two method to serialize and deserialize not static objects classes and I don't know if and how struct are serializable.
Here is my code:

using System.Runtime.Serialization;
using System.Runtime.Serialization.Formatters.Binary;
using System.IO;

namespace My_Space
{
    // the object that needs to be serialized.
    [Serializable()]
    public class Parameters
    {
        public int autoLockTime;
        public int screenOffTime;
        public int loopAutoStartTime;

        public class product
        {
            public bool enabled;
            public string productName;
            public double zero;
            public double span;
            public string unit;

            public class preProcessing
            {
                public string preProcessingName;        // preprcessing name
                public double[] param = new double[5];  // 5 parameters from preprocessing
            }
        }

        // init object class Parameters
        public void InitParameters()
        {
            autoLockTime = 0;
            screenOffTime = 0;
            loopAutoStartTime = 0;
            product[] p = new product[30];
            p[0].enabled = false;
            p[0].unit = "mm";
            p[0].productName = "H2O";

            product.preProcessing[] pp = new product.preProcessing[10];
            pp[0].preProcessingName = "Derivative";
            pp[0].param[0] = 100.0f;
            pp[0].param[1] = 200.0f;
// BUT I CANNOT LINK THE 10 PRE-PROCESSING ARRAY TO
// THE 30 PRODUCTs AND WRITE something like with struct
// p[3].pp[2].param[4] = 123.45f;
        }

        //-----------------------------------------------------------------
        // Opens a file and serializes the object into it in binary format.
        // Let the input object unchanged.
        //-----------------------------------------------------------------
        public void SaveParameters(Parameters obj)
        {
            Stream stream = File.Open("Parameters.bin", FileMode.Create);
            BinaryFormatter formatter = new BinaryFormatter();

            formatter.Serialize(stream, obj);
            stream.Close();
        }

        //-----------------------------------------------------------------
        // Opens file "Parameters.bin" and deserializes the object from it.
        // Return the output object in the same input object !!!!!
        //-----------------------------------------------------------------
        public void ReadParameters(out Parameters obj)
        {
            Stream stream = File.Open("Parameters.bin", FileMode.Open);
            BinaryFormatter formatter = new BinaryFormatter();

            obj = (Parameters)formatter.Deserialize(stream);
            stream.Close();
        }
    }
}

I can also write in other classes:

private Parameters q = new Parameters q();
private Parameters.product[] p = new Parameters.product[30];
private Parameters.product.preProcessing[] pr = new Parameters.product.preProcessing[10];

public Form()
{
    // Return the output object in the same input object !!!!!
    q.ReadParameters(out q);

    p[0].productName = "aaa";
    pr[0].preProcessingName = "bbb";

}

but I cannot link the preProcessing object to the product object and I cannot serialize array of classes as p or pr.

Maybe using static class ... ?
How can I serialize/deserialize structs ?
What is the best solution ?
Thanks

modified 24-Mar-14 12:21pm.

Re: Array of classes nested into array of classes (and serialization)

Pete O'Hanlon23-Mar-14 22:48

Pete O'Hanlon

23-Mar-14 22:48

The problem here is that you have only marked one of your classes as Serializable. You need to mark all of the classes that can be serialized like this.

Re: Array of classes nested into array of classes (and serialization)

Mario 5623-Mar-14 23:43

Mario 56

23-Mar-14 23:43

This code seems to work:

using System.Runtime.Serialization;
using System.Runtime.Serialization.Formatters.Binary;
using System.IO;

namespace Base_NIR
{
    // the object that needs to be serialized.
    [Serializable()]
    public class Parameters
    {
        public int autoLockTime;
        public int screenOffTime;
        public int loopAutoStartTime;

        public class product
        {
            public bool enabled;
            public string productName;
            public double zero;
            public double span;
            public string unit;
            public preProcessing[] preProc = new preProcessing[10];
        }
        public class preProcessing
        {
            public string preProcessingName;        // preprcessing name
            public double[] param = new double[5];  // 5 parameters from preprocessing
        }

        [NonSerialized()]
        public static string member5 = "hello world!";  // A field that is not serialized.

        // init object class Parameters
        public void InitParameters()
        {
            autoLockTime = 0;
            screenOffTime = 0;
            loopAutoStartTime = 0;
            preProcessing[] pr = new preProcessing[10];
            pr[0].preProcessingName = "bbb";
            product[] p = new product[30];
            p[0].preProc[1].preProcessingName = "aaa";
            p[0].enabled = false;
            p[0].unit = "mm";
            p[0].productName = "H2O";
            p[0].preProc[3].param[5] = 123.45f;
            p[0].preProc[2].preProcessingName = "Derivative";
        }

        //-----------------------------------------------------------------
        // Opens a file and serializes the object into it in binary format.
        // Let the input object unchanged.
        //-----------------------------------------------------------------
        public void SaveParameters(Parameters obj)
        {
            Stream stream = File.Open("Parameters.bin", FileMode.Create);
            BinaryFormatter formatter = new BinaryFormatter();

            formatter.Serialize(stream, obj);
            stream.Close();
        }

        //-----------------------------------------------------------------
        // Opens file "Parameters.bin" and deserializes the object from it.
        // Return the output object in the same input object !!!!!
        //-----------------------------------------------------------------
        public void ReadParameters(out Parameters obj)
        {
            Stream stream = File.Open("Parameters.bin", FileMode.Open);
            BinaryFormatter formatter = new BinaryFormatter();

            obj = (Parameters)formatter.Deserialize(stream);
            stream.Close();
        }
    }
}

And I can also write:

private Parameters.product[] p = new Parameters.product[30];
private Parameters pr = new Parameters();

public MainForm()
{
    pr.InitParameters();
    pr.ReadParameters(out pr);
    p[0].preProc[2].preProcessingName = "xxx";
    pr.SaveParameters(pr);
    // Return the output object in the same input object !!!!!
    pr.ReadParameters(out pr);
}

But everytime I write in a field I have the error of nullReference exception.

Re: Array of classes nested into array of classes (and serialization)

Pete O'Hanlon24-Mar-14 2:23

Pete O'Hanlon

24-Mar-14 2:23

You're facing another issue here, and it's a common misunderstanding. The issue is down to the fact that newing up arrays doesn't actually add class instances, you have to explicitly add them yourself. So, after you have allocated your array, you need to add a new instance of the class against each item in the array.

Re: Array of classes nested into array of classes (and serialization)

Mario 5624-Mar-14 2:42

Mario 56

24-Mar-14 2:42

Sorry Pete, to be clear, please can you write 5 lines of code of example to better explain ?

Re: Array of classes nested into array of classes (and serialization)

Pete O'Hanlon24-Mar-14 2:48

Pete O'Hanlon

24-Mar-14 2:48

This should give you an idea. The line in bold is the one I added.

preProcessing[] pr = new preProcessing[10];
pr[0] = new preProcessing();
pr[0].preProcessingName = "bbb";

Re: Array of classes nested into array of classes (and serialization)

Mario 5624-Mar-14 5:54

Mario 56

24-Mar-14 5:54

OK thanks Pete. Sorry, it wasn't so easy to use that objects for me but now it's working fine. Do you have some other idea on how it would be better to implement them. What do you thinks about to use these classes with Lists ?

Re: Array of classes nested into array of classes (and serialization)

BobJanova24-Mar-14 4:14

BobJanova

24-Mar-14 4:14

There's two problems here which I think come from the same misunderstanding.

In C, the code

struct A {
 int someField;
 struct B {
  long somethingElse; }
 } B;
}

... defines an object tree. That is, I can say

A a;
a.B.somethingElse = 12L;

In C#, you have not written the equivalent. Nested classes (and structs) define only the class, they do not define a field that goes with it. The fact that they're nested only affect name resolution and visibility. You need to also provide a field or property that is linked to an instance or array of the inner class.

That means I think you want:

public class product
{
    public bool enabled;
    public string productName;
    public double zero;
    public double span;
    public string unit;
    public preProcessing[] pp;

    public class preProcessing
    {
        public string preProcessingName;        // preprcessing name
        public double[] param = new double[5];  // 5 parameters from preprocessing
    }
}

(Set aside for the moment questions of array vs list and public fields.) That means you can say

var p = new product();
p.pp = new product.preProcessing[10];
p.pp[0] = new product.preProcessing();
p.pp[0].param[3] = 12.8;

You've made the same mistake at the top level: Parameters should have a field of type product[].

When you do that you'll see the second mistake, because your code will stop compiling due to inconsistent [Serializable] attributes. You need to put [Serializable] on all the inner classes that are part of your data tree, too.

Re: Array of classes nested into array of classes (and serialization)

Mario 5624-Mar-14 6:17

Mario 56

24-Mar-14 6:17

Thanks Bob you were, as usual, clear and helpful. Now the work is running in the right way!

Re: Array of classes nested into array of classes (and serialization)

Mario 5624-Mar-14 7:44

Mario 56

24-Mar-14 7:44

Sorry, my application doesn't serialize/deserialize. How can I save all my classes together in the same file ? With only one simple class (Parameters) it was correct, now with more classes I don't know how to fix the code. The code to test the serailize and deserialize method now is:

        private Parameters param = new Parameters();
        private Parameters.product[] p = new Parameters.product[30];
        private Parameters.preProcessing[] pp = new Parameters.preProcessing[10];

        public MainForm()
        {
//          param.ReadParameters(out param);
            param.InitParameters();
            p[0] = new Parameters.product();
            p[0].productName = "H2O";
            p[0].preProcessId[0] = 0;
            p[0].preProcessId[1] = 1;
            param.SaveParameters(p[0]);  // <<=  COMPILER ERROR
            param.ReadParameters(out p); // <<=  COMPILER ERROR

            pp[0] = new Parameters.preProcessing();
            pp[0].preProcessId = 0;
            pp[0].preProcessingName = "Derivative";
            pp[0].preProcessingParms[0] = 10.0;
            pp[0].preProcessingParms[1] = 20.0;
       }

and the file with the classes to save and the serialize/deserialize methods is:

using System.Runtime.Serialization;
using System.Runtime.Serialization.Formatters.Binary;
using System.IO;

namespace My_Test_Space
{
    // the object that needs to be serialized.
    [Serializable()]
    public class Parameters
    {
        public int autoLockTime;
        public int screenOffTime;
        public int loopAutoStartTime;

        [Serializable()]
        public class product
        {
            public bool enabled;
            public string productName;
            public double zero;
            public double span;
            public string unit;
            public int[] preProcessId = new int[10];
        }
        [Serializable()]
        public class preProcessing
        {
            public int preProcessId;          // a number from 0 to 9
            public string preProcessingName;
            public double[] preProcessingParms = new double[5];  // max 5 parameters x preProcessing
        }

        // init object class Parameters
        public void InitParameters()
        {
            autoLockTime = 0;
            screenOffTime = 0;
            loopAutoStartTime = 0;

            preProcessing[] pp = new preProcessing[10];
            for (int i = 0; i < 9; i++)
            {
                pp[i] = new preProcessing();
                pp[i].preProcessId = i;
                pp[i].preProcessingName = "";
                for (int j = 0; j < 5; j++) pp[i].preProcessingParms[j] = 0.0;
            }

            product[] p = new product[30];
            for (int i = 0; i < 30; i++)
            {
                p[i] = new product();
                p[i].enabled = false;
                p[i].unit = "mm";
                p[i].productName = "H2O";
                p[i].zero = 0.0;
                p[i].span = 0.0;
                for (int j = 0; j < 10; j++)                    // we can have at max 10 preProcessing for product
                {
                    p[i].preProcessId[j] = 0;
                }
            }
        }

        //-----------------------------------------------------------------
        // Opens a file and serializes the object into it in binary format.
        // Let the input object unchanged.
        //-----------------------------------------------------------------
        public void SaveParameters(Parameters obj)
        {
            Stream stream = File.Open("Parameters.bin", FileMode.Create);
            BinaryFormatter formatter = new BinaryFormatter();

            formatter.Serialize(stream, obj);
            stream.Close();
        }

        //-----------------------------------------------------------------
        // Opens file "Parameters.bin" and deserializes the object from it.
        // Return the output object in the same input object !!!!!
        //-----------------------------------------------------------------
        public void ReadParameters(out Parameters obj)
        {
            Stream stream = File.Open("Parameters.bin", FileMode.Open);
            BinaryFormatter formatter = new BinaryFormatter();

            obj = (Parameters)formatter.Deserialize(stream);
            stream.Close();
        }
    }
}

Re: Array of classes nested into array of classes (and serialization)

BobJanova24-Mar-14 8:05

BobJanova

24-Mar-14 8:05

You still haven't quite got the concept that an instance of Parameters should contain all references to instances of the subclasses. You're storing references to the inner classes in MainForm – that means they're not in the same object tree and really aren't related to the object 'param' you create.

Your MainForm initialisation should just be

private Parameters param = new Parameters();

Parameters.InitParameters should build the instances of products and products.preProcessing – not as local variables it is now. You're currently building arrays in that function that are never assigned to anything and go out of scope immediately.

public void InitParameters()
        {
            autoLockTime = 0;
            screenOffTime = 0;
            loopAutoStartTime = 0;
 
// Don't do this
//          preProcessing[] pp = new preProcessing[10];
            this.pp = new preProcessing[10];
            for (int i = 0; i < 9; i++)
            {
                pp[i] = new preProcessing();
                pp[i].preProcessId = i;
                pp[i].preProcessingName = "";
                for (int j = 0; j < 5; j++) pp[i].preProcessingParms[j] = 0.0;
            }
 
// or this
//          product[] p = new product[30];
            this.p = new product[30];
            for (int i = 0; i < 30; i++)
            {
                p[i] = new product();
                p[i].enabled = false;
                p[i].unit = "mm";
                p[i].productName = "H2O";
                p[i].zero = 0.0;
                p[i].span = 0.0;
                for (int j = 0; j < 10; j++)                    // we can have at max 10 preProcessing for product
                {
                    p[i].preProcessId[j] = 0;
                }
            }
        }

You'll have to add the declarations for p and pp to the Parameters class as I explained in my previous post to make those assignments work.

Now, all you have to do is serialise an instance of Parameters (i.e. MainForm.param), and it will serialise the whole object tree.

Re: Array of classes nested into array of classes (and serialization)

Mario 5624-Mar-14 10:24

Mario 56

24-Mar-14 10:24

OK Bob, now it works! I'm sorry for my stupidity, but from the beginning the 3 classes (which in fact contain much more data) were divided into 3 different files with 3 different classes so I have created a lot of confusion to forget even the most basic concepts. I tried many solutions to solve the problem of the persistence of the data (w/o databases or registry) using settings at first, then with the structures, then with static classes (and all thre 3 worked very well) but at the end also to study more deeply the dynamic classes and the problem of their serialization now I am very happy for the results achieved with your help.

Regarding Role based Login

Member 1067835223-Mar-14 22:08

Member 10678352

23-Mar-14 22:08

Dear all please provide code we have 2 role 1)admin 2)user but we have only single login page when we select admin role in login page page redirect to admin panel and when role select at login page redirect to user panel

Please provide code in C#

Re: Regarding Role based Login

Richard MacCutchan23-Mar-14 23:01

Richard MacCutchan

23-Mar-14 23:01

Member 10678352 wrote:
Please provide code in C#

If you need code samples then you should try searching for them.

Re: Regarding Role based Login

Member 1067835224-Mar-14 18:28

Member 10678352

24-Mar-14 18:28

i have already searching for code but i not did not found any code...

Re: Regarding Role based Login

Richard MacCutchan24-Mar-14 22:23

Richard MacCutchan

24-Mar-14 22:23

https://www.google.com/search?q=role+based+login[^].

Geolocation with c# winforms

Member 1069141122-Mar-14 12:37

Member 10691411

22-Mar-14 12:37

Hi,

i'm debutante in c# and i'm developing my final project,
how can i add something like this http://universimmedia.pagesperso-orange.fr/geo/loc.htm[^]

thank u

Re: Geolocation with c# winforms

Peter Leow22-Mar-14 17:05

Peter Leow

22-Mar-14 17:05

Refer:
1. gecko-for-windows-forms-and-geolocation[^]
2. getting-device-location-in-c-sharp-tutorial[^]

dynamic sql result not shown in DevExpress DataGrid

Jassim Rahma21-Mar-14 12:26

Jassim Rahma

21-Mar-14 12:26

I am trying the following sql statement on a simple windows form textbox:

select count(*) from job_orders;

then I am running the code using the following:

when I use the dtandared DataGrid from Microsoft Visual studio I get the correct result (total_count) in the row

but when I use the same with DevExpress xtraGrid I just get blank row although other sql statements are working fine in xtraGrid such as:

Select * from job_orders;

here is the code:

sql_connection = new MySqlConnection("Server=127.0.0.1;Port=3306;Database=MyDB;Uid=root;Pwd=MyPwd;Connect Timeout=360;");
sql_connection.Open();
sql_command = new MySqlCommand(txtQuery.Text, sql_connection);
sql_command.CommandType = CommandType.Text;
sql_adapter = new MySqlDataAdapter(sql_command);
sql_adapter.Fill(data_table);
dataGridView1.DataSource = null;
dataGridView1.ResetBindings();
dataGridView1.DataSource = data_table;

Technology News @ www.JassimRahma.com

moving from iphone to asp.net

dsp120-Mar-14 23:41

dsp1

20-Mar-14 23:41

Hi ,
i am a iphone app developer, i have decided to move to asp.net mvc now Smile | :)

.I have litele knowledge on VC++ and c# long back.
Is it a gud decission or not?
If yes how do i start.Can any one guide me plz?

modified 21-Mar-14 5:55am.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.