|
I'm developing a membership app that allows the user to view information in a highly dynamic way. For instance the user can click through folder like structures, add/edit/move/delete records. Right now I'm saving the data to an Access database and I'm fine with that. My concern is that with the methods I've established, this dynamic interface will require a lot of table creation. I need answers to the following questions:
1. Does excessive amounts of tables slow the performance of an Access db or does only the amount a records slow the performance.
2. Is there a better way to save my data? I am wanting to write the code so it can adapt to a multi-user program.
Thanks a million!
Richard
may your code be error free.
(okay, maybe two lines.)
|
|
|
|
|
programmingAddict wrote: Right now I'm saving the data to an Access database
programmingAddict wrote: so it can adapt to a multi-user program.
I don't believe Access is recommended for multi-user systems. But since your data is highly dynamic that could be a special case. My experience is limited to data that is sort of dynamic.
led mike
|
|
|
|
|
You need to live a little. I've seen data so dynamic that it blurs when you save it to the database.
Of course its a pain to debug because the exceptions can fly right past your eyeballs, and the sonic boom can spilt coffee mugs at ten paces.
I'm terrible at debugging without coffee 
|
|
|
|
|
Richard,
I've had a million rows in some Access databases, no problem.
I'm trying to understand why you are creating tables on the fly.
What sort of data are you saving?
Can you define a set number of tables and use your UI to populate those tables?
How many members are we talking about?
modified 27-Feb-21 21:01pm.
|
|
|
|
|
The reason I want to allow the user to create their own data structures (in addition to the ones that have already been created) is because it would give the user so much more flexibility. In addition I want to create a interface that allows the user to organize the data in the way they best relate to. The Windows File/Folder system is the best example. I could do a conventional file system but I don't think that will work in multi-user enviroment. Can you see my dilemma?! 
may your code be error free.
(okay, maybe two lines.)
|
|
|
|
|
Ok, now I see where you are going.
I've done this before with XML structures. You "could" serialize the XML data to a single record as a binary stream for that customer. Access supports this, along with SQL Server. You application will determine if each customer needs one or more records to handle the features you need. But this should be easy to figure out.
Using an XML data structure allows for free data structure that can be dynamic.
Depending on your search requirements you may want to index some or all of the data. Without knowing all the pieces I can't advise with authority.
Have you thought about SQL Server Express. It's free, multi user and FAST.
Hope this helps, time for bed. 
modified 27-Feb-21 21:01pm.
|
|
|
|
|
programmingAddict wrote: because it would give the user so much more flexibility.
Do you have a specific User community so that you know this is a good idea?
Most users would just hang themselves with the flexibility. I mean many software developers are not capable of designing schemas properly, what makes you think you want to delegate that responsibility to users?
programmingAddict wrote: I could do a conventional file system but I don't think that will work in multi-user enviroment.
I'm pretty sure it works for Sharepoint
led mike
|
|
|
|
|
I understand your point but Microsoft allows their users to organize music/videos/documents/folders like they want to.
Okay, lets say I was creating a photo organizer app. How would a developer design a muti-user application that allows the users to create/edit/organize their photo collections. For instance, what if the user with administrative privileges would want to create a folder that stores all photo's of his aunt's vacation to the Bahammas. He would probably want to name it: Aunts Trip To Bahammas.
No predefined template can acommodate all these variables.
Thanks for all the input so far!
may your code be error free.
(okay, maybe two lines.)
|
|
|
|
|
Hi all,
Any one please suggest me how to call a javascript function inside a asp:hyperlinkcolumn column. I want to call a javascript function when a user click the asp:hyper link text. In html link we can do tht using onclick function, is there any option like this in asp:hyperlink?
Also i need one more suggestion, plz suggest me some web sites from where i can learn Hibernate using .NET with some basic samples.
Thanks in advance
Know is Drop, Unknown is Ocean
|
|
|
|
|
Exelioindia wrote: Any one please suggest me how to call a javascript function inside a asp:hyperlinkcolumn column. I want to call a javascript function when a user click the asp:hyper link text. In html link we can do tht using onclick function, is there any option like this in asp:hyperlink?
Add your JavaScript function call to the NavigateUrl property of your control.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hello Friends,
In my application i have to transfer a number of files from one folder to another folder on the same machine.
I am unable to fetch multiple files and also help me how to store these files to another location.
Thanks in advance............
Deepak Nigam
Deepak Nigam
|
|
|
|
|
Don't cross post in multiple forums. It's considered rude around here, and other sites.
|
|
|
|
|
Hello,
I have a small application that exposes various behaviors via dialog windows. I want to modify the application so that instead of popping up dialog windows it will simply show a new panel in the main window area.
My idea is to create several Panels to replace the dialog boxes. I want to be able to design these Panels in the designer just like you would design a new form.
The designer doesn't support this, so I must be barking up the wrong tree. I really want to treat each panel separately in the designer rather than just stacking all these panels on the main window (which makes it difficult to see what's going on).
Did I articulate that well enough? Any thoughts?
Thanks!
|
|
|
|
|
Is a user control what you are looking for?
Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Individuality is fine, as long as we do it together - F. Burns
|
|
|
|
|
That's exactly what I'm looking for!
Thanks! (I accidentally selected "custom control" which is entirely different and confused my one-track mind).
|
|
|
|
|
Hey friends, I have been searching but couldn't find any examples where i can make my custom controls transparent (see through). Is it even possible to do in C#.
thanks
|
|
|
|
|
|
Did you try setting the controls backcolor to Color.Transparent?
|
|
|
|
|
I am controlling the paint method but when i set the style in the constructors it does funny thing but still my control is not tranparent
public UserControl1()
{
InitializeComponent();
SetStyle(ControlStyles.SupportsTransparentBackColor, true);
this.BackColor = Color.FromArgb(0, 0, 0);
}
|
|
|
|
|
Isn't (0,0,0) black?
Did you try
this.BackColor = Color.Transparent;
?
|
|
|
|
|
Or pehraphs you could even use the correct overload, with that extra zero for the alpha channel. Which is what you want.
this.BackColor = Color.FromArgb(0,0,0,0);
Also, Color.FromArgb(0,0,0,0) == Color.Transparent; or at least the result is the same.
My current favourite word is: Nipple!
-SK Genius
|
|
|
|
|
Can anybody give me link or suggestions on implementing good exception handling mechanism in the C# project. Not just try...Catch block but beyond that.
I have something in mind,
1. Create something like Error Dictionary (resx file) with user-defined Error Codes, Description and build my own error information with user-defined exception class.
2. This class may accept error code or something for generating good exception object, which can be thrown to the consumer.
3. Exception Consumer will then use this object and pass it to Some class, which eventually will display Vista Type task dialog where atleast Title, Main Instruction and Description of the errors will be shown.
Any Inputs are very much appreciated.
Thanks
|
|
|
|
|
Why have a method return an error code which you pass to an error code processing method when you can just throw the appropriate exception when it occurs. Your stack trace looks right that way.
|
|
|
|
|
eggsovereasy wrote: Why have a method return an error code which you pass to an error code processing method when you can just throw the appropriate exception when it occurs.
Why? Obviously it's an exceptional condition. 
led mike
|
|
|
|
|
Thanks for the reply. Only the thing i want to know is the best design to implement Exception\message Handling, using custom exception classes and resource files contains errors/message keys and descriptions.
Thanks
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
