|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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 – ∞)
|
|
|
|
|
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
{
[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;
public double[] param = new double[5];
}
}
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;
}
public void SaveParameters(Parameters obj)
{
Stream stream = File.Open("Parameters.bin", FileMode.Create);
BinaryFormatter formatter = new BinaryFormatter();
formatter.Serialize(stream, obj);
stream.Close();
}
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()
{
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.
|
|
|
|
|
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.
|
|
|
|
|
using System.Runtime.Serialization;
using System.Runtime.Serialization.Formatters.Binary;
using System.IO;
namespace Base_NIR
{
[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;
public double[] param = new double[5];
}
[NonSerialized()]
public static string member5 = "hello world!";
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";
}
public void SaveParameters(Parameters obj)
{
Stream stream = File.Open("Parameters.bin", FileMode.Create);
BinaryFormatter formatter = new BinaryFormatter();
formatter.Serialize(stream, obj);
stream.Close();
}
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);
pr.ReadParameters(out pr);
}
But everytime I write in a field I have the error of nullReference exception.
|
|
|
|
|
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.
|
|
|
|
|
Sorry Pete, to be clear, please can you write 5 lines of code of example to better explain ?
|
|
|
|
|
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";
|
|
|
|
|
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 ?
|
|
|
|
|
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;
public double[] param = new double[5];
}
}
(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.
|
|
|
|
|
Thanks Bob you were, as usual, clear and helpful. Now the work is running in the right way!
|
|
|
|
|
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.InitParameters();
p[0] = new Parameters.product();
p[0].productName = "H2O";
p[0].preProcessId[0] = 0;
p[0].preProcessId[1] = 1;
param.SaveParameters(p[0]);
param.ReadParameters(out p);
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
{
[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;
public string preProcessingName;
public double[] preProcessingParms = new double[5];
}
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++)
{
p[i].preProcessId[j] = 0;
}
}
}
public void SaveParameters(Parameters obj)
{
Stream stream = File.Open("Parameters.bin", FileMode.Create);
BinaryFormatter formatter = new BinaryFormatter();
formatter.Serialize(stream, obj);
stream.Close();
}
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();
}
}
}
|
|
|
|
|
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;
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;
}
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++)
{
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.
|
|
|
|
|
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.
|
|
|
|
|
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#
|
|
|
|
|
Member 10678352 wrote: Please provide code in C#
If you need code samples then you should try searching for them.
|
|
|
|
|
i have already searching for code but i not did not found any code...
|
|
|
|
|
|
|
|
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
|
|
|
|
|
Hi ,
i am a iphone app developer, i have decided to move to asp.net mvc now  .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.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
