|
It really all depends on what you are doing!
There is no "this is best" solution - or we would all just use that and the other solutions would fall by the wayside...
The SQL server SQLite decision is a case in point: Are you expecting only one person to use the information, or multiple people? If it's one person, then yes, SQL Server can be overkill. But if it's two people who need access to the DB, then a server based solution (SQL Server or MySql) is absolutely a good idea, and SQLite is a very poor decision because it will give you enormous hassles. But...Yesterday I spent ten minutes swapping one of my utility apps from SQLCE to SQL Server despite being the only person who uses it, simply because I was fed up with the low speed on start up / shut down - so it's isn't always as black and white as it seems...
The tables are the same: it depends what you are doing! I have systems which do it both ways: but generally if two people can change the data, then local caching becomes a problem, unless you use some SQL triggering to force an update on your application - which is not a trivial job!
So no, we can't tell you which way to go: just keep you data layer separate from your business and presentation layers so if you did chose the wrong solution, you can "undo" it as easily as possible!
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 – ∞)
|
|
|
|
|
Thanks Griff, you've put into words exactly what I wanted to hear. there's about 50 teachers, and it's remotely possible that they will all be entering results at the same time. Taking your advice, I've decided to use SQL server. The project will be on separate laptops, each with 8Gb of memory (don't you just love school standardisation?), so downloading all the data at run time won't be a problem, and I will have a trigger to flag updates. Not quite figured out how to do that yet, but I'm sure it can be done.
I'm going to use Entity Framework, as my data layer, with the business and presentation layers separated as well. In fact the only problem I can see is convincing the management team that the data is actually secure, even though it is on a remote server.
|
|
|
|
|
You're welcome!
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 – ∞)
|
|
|
|
|
Just a thought: You could keep a table in the database with revision numbers per table (or the whole database). Cash the data and refresh when the revision number is higher then local (small query that runs every minute). When you update, delete or insert data increment the revision number. You should use stored procedures in sql server, queries are very slow.
|
|
|
|
|
joost.versteegen wrote: You should use stored procedures in sql server, queries are very slow. Explain me how sprocs are a magnitude (!) faster than a normal query?
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Sprocs are compiled and then stored. queries have to be compiled every time.
|
|
|
|
|
|
oow...i see. Back in the old days when I learned sql server (4.1 or so) they where faster. sorry!
|
|
|
|
|
Wasn't exactly sure where to put this question...
We are currently using Programmers File Editor (which hasn't had an update since 1999 I think) to edit and view large and small data files before processing. Since moving to 2008 R2 it's been acting up a bit and will just close and other normal not supported software behavior. The key features I'm looking for is the ability to view files with large rows (col count over 35,000), checking for updated files before saving (basically have a file open twice, make changes in both places it should notify you that the file has changed before the second save happens), and kinda going with the last, notifying you of file changes if you move off it and go back (drop focus then gain focus), displaying row and col position is very handy as well.
Thanks!
|
|
|
|
|
Notepad++ should do all of that for you.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
|
Just tried it, and it overwrote the file changes without asking...
This check before saving thing is basically because of one file that should be a database table.
Thanks for the suggestion though...
|
|
|
|
|
Visual Studio will handle this for you admirably (you can use the free versions if necessary). If a file is updated, VS will notify you and ask if you want to reload it.
|
|
|
|
|
I have also found EmEditor, just need to test it out a bit. However yes apparently I could use VS as a text editor, though I haven't tested it yet on the file that is 77,000 columns. Basically it's a data file all on one line with 74 white spaces defining a page break.
|
|
|
|
|
I use either ConText or gVim for all my 'text' file needs. VS will do it and sometimes better but it just takes to dang long to load.
Jack of all trades, master of none, though often times better than master of one.
|
|
|
|
|
I have been using UltraEdit for years; it's very fast at handling huge files, has a variety of modes for various programming languages' syntax, xml, csv files, etc.
Does auto-save, auto-notify if a file is changed, supports multiple same-file edits, and about a million other features. imho very reasonably priced. It integrates with other IDM products like UltraCompare and UltraFinder.
They have trial versions you can test [^].
“I speak in a poem of the ancient food of heroes: humiliation, unhappiness, discord. Those things are given to us to transform, so that we may make from the miserable circumstances of our lives things that are eternal, or aspire to be so.” Jorge Luis Borges
|
|
|
|
|
when I connected my modem there are 2 ports. but how can I detect that which is data port and which is voice port by C#.net coding?
|
|
|
|
|
Since you're asking about the functionality of a very specific piece of hardware that most people are not going to have access to or experience with, your single BEST source of information is going to be the support forums of the company that made the modem.
|
|
|
|
|
|
|
I've set (or get) the background color NavBar Control but it isn't ? you see code below.
set background color NavBar Control:
navBarControl1.Appearance.GroupBackground.BackColor = Color.White;
navBarControl1.BackColor = Color.White;
or get background color NavBar Control:
System.Drawing.Color c1 = navBarControl1.Appearance.GroupBackground.BackColor;
System.Drawing.Color c2 = navBarControl1.BackColor;
webBrowser1.Document.BackColor = c1;
webBrowser2.Document.BackColor = c2;
do you know set or get the background color NavBar ?
|
|
|
|
|
Since you apparently purchased a very expensive software suite to use this component, why not take advantage of the DevExpress support forums, and ask a question there, or, perhaps, find your question already answered here: [^], and here: [^].
“Use the word 'cybernetics,' Norbert, because nobody knows what it means. This will always put you at an advantage in arguments.” Claude Shannon (Information Theory scientist): letter to Norbert Weiner of M.I.T., circa 1940
|
|
|
|
|
Hello,
I'm trying to load this site http://www.terra.com.br, an object webBrowser with WindowsForm,
but not loads, is only thinking someone would know how to please
webBrowser1.Navigate("http://www.terra.com.br");
Thanks
William
|
|
|
|
|
It's impossible to tell you anything useful from what you posted.
There isn't anything wrong with the code as far as I can tell and you haven't given a description of what is happening when you go to that site, other than "it doesn't work". That isn't very helpful at all.
|
|
|
|
|
Thanks for the reply.
I just want to load the site described in webbrowser, for example if I upload http://www.globo.com works perfectly if I put http://www.terra.com.br it does not load the site is only Loading before worked but change the layout of the site and loads more I downloaded this project here on CodeProject and the same thing happens
http://www.codeproject.com/Articles/60179/Web-Browser-in-C
thank you
William
|
|
|
|
|
I couldn't tell you why it doesn't show up. I don't have access to it from work.
The WebBrowser control is a kind of wrapper around the rendering engine of the version of Internet Explorer you have installed on your machine. It's not a 100% working version of IE or a web browser. It has it's limitations.
For example, if the version of IE you have installed is IE9, the rendering engine the webbrowser control uses will look like, the the website your browsing, IE7. The rendering engine is common to IE versions 7 through 9.
If you have IE6 installed, it gets worse. You're actually using the rendering engine that come in IE 4!
Open your application and have it navigate to http://www.whatsmyuseragent.com[^] and you can see how websites see your application.
|
|
|
|