C# Discussion Boards - CodeProject

24-Mar-14 3:17

If you're using WCF, I would advise reading the answers detailed here[^].

Developing a C# Project

Bobba Praneeth24-Mar-14 0:09

Bobba Praneeth

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.

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.[^]

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

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.

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

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 – ∞)

Mario 5623-Mar-14 22:23

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

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.

Pete O'Hanlon23-Mar-14 22:48

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

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.

Mario 5623-Mar-14 23:43

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

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.

Pete O'Hanlon24-Mar-14 2:23

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

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.

Mario 5624-Mar-14 2:42

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

24-Mar-14 2:42

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

Pete O'Hanlon24-Mar-14 2:48

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

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

Mario 5624-Mar-14 5:54

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

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 ?

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

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

24-Mar-14 6:17

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

Mario 5624-Mar-14 7:44

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

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();
        }
    }
}

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