|
Except that bubba there wanted to make it db agnostic, and I've worked with a couple of databases in the past that have crap date and time support (hello Ingres, yes I'm talking about you, you malformed piece of relational dataloss crapturd).
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
we could agree on Ingres not being a database then, hence no need to dumb down the whole world and turn agnostic into stupid. Next someone will find a "database" that can't handle real numbers; or strings of more than 6 characters; or Unicode...
When he asks "Does it make sense to avoid the use of the datetime objects..." my answer is NO.
|
|
|
|
|
Or one that doesn't have operator precedence?
|
|
|
|
|
Luc Pattyn wrote: When he asks "Does it make sense to avoid the use of the datetime objects..." my answer is NO.
I'd agree with that
Luc Pattyn wrote: agree on Ingres not being a database
and that.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
Pete O'Hanlon wrote: I'd agree with that and that.
I'm glad to see you're back to normal; I suggest you keep ignoring the toaster. 
|
|
|
|
|
Luc Pattyn wrote: I suggest you keep ignoring the toaster.
I've kicked the hussy out. I only have eyes for the microwave now.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
Pete O'Hanlon wrote: I only have eyes for the microwave now
I must warn you, microwaves can harm the eyes. And Ray-Ban won't offer adequate protection.
|
|
|
|
|
Ryan Minor wrote: Does it make sense
No, it doesn't.
I use several different database systems and the only problem I've had with DateTimes is that they don't all agree on which range of dates to support. So unless you're storing historical (or far future) data, you probably won't have any trouble.
|
|
|
|
|
IMHO adding a non-exhaustive list of those DB systems would turn that into the perfect answer...
|
|
|
|
|
Ooookaaay... I'll get right on that.
|
|
|
|
|
One thing to bear in mind is whether this database will be used for anything else, e.g. accessed directly from reporting tools rather than through your application code. In this case, holding the dates as a double may cause problems for the person writing the reports.
Personally, I would consider making the data access layer pluggable, with a separate table gateway[^] for each RDBMS you are going to support. That way, if your database has good date type support you can use it, if not you can fall back on using doubles. Either way, the bulk of your code doesn't know and doesn't care. In fact, you might only need two gateways: one that supports date types and one that doesn't. Then you have a simple configuration switch to flick at deployment time to control how the application stores data.
(Actually, that link above isn't the most helpful in the world. Buy the book, it's very good.)
|
|
|
|
|
hi,
i have developed a windows service with c# and in my service a routine run at specific time to fetch data from sql server but i saw sometime i am getting error like below
A network-related or instance-specific error occurred while establishing a connection to SQL Server
can anyone tell why i am getting the above error some time. please help.
thanks in advance
tbhattacharjee
|
|
|
|
|
1. Make sure your database engine is configured to accept remote connections
• Start | All Programs | SQL Server 2005 | Configuration Tools | SQL Server Surface Area Configuration
• Click on Surface Area Configuration for Services and Connections
• Select the instance that is having a problem | Database Engine | Remote Connections
• Enable local and remote connections
• Restart instance
2. Check the SQL Server service account
• If you are not using a domain account as a service account (for example if you are using NETWORK SERVICE), you may want to switch this first before proceeding
3. If you are using a named SQL Server instance, make sure you are using that instance name in your connection strings in your ASweb P.NET application
• Usually the format needed to specify the database server is machinename\instancename
• Check your connection string as well
Did you, even for a second, consider using google? I got over 36000 hits on that error message.
.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
|
|
|
|
|
After working in Visual Studio 2008 with SP1 on my application, everything works sweet with visifire charts.
I then create an install for my application and deploy it to a seperate machine. Charts do not work, and we get system.exception with Eventype:clr20r3
Can visifire be run without VS 2008? I don't expect to install VS 2008 SP1 on every install instance of my app with visifire.
I'm using WPF, and am creating the chart dynamically through code. I'm using the latest stable/non-beta version of visifire, v2.1
|
|
|
|
|
Have you asked the visifire folks?
.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
|
|
|
|
|
I have ask to visifire but i still waiting a response.
|
|
|
|
|
Well, wait until they can't answer your question, and THEN ask it here.
For future reference, many of us here have never even heard of VisiFire, so asking here is pretty much a waste of time.
.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
|
|
|
|
|
Please don't cross post. It makes it difficult for people to form a coherent and cohesive answer for you because bits of information end up being scattered in multiple forums.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
Hi, I m using DataGridView in c#.net, can anyone help me with the code to obtain the following.
------------------------------------------------------------|
Student Details | Course Details |
------------------------------------------------------------|
Name | Address | Name | Code No |
------------------------------------------------------------|
aaa | India | CS | 123 |
------------------------------------------------------------|
Thanks
|
|
|
|
|
No, because...
0) It sounds like homework
1) You provided absolutely no frame of reference - AT ALL.
.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
|
|
|
|
|
The DataGridView does not support merging cells (or headers) like you find in Excel.
You'll have to use a third party grid to do this. I don't know of one that does, but that doesn't mean they don't exist.
|
|
|
|
|
Is there any way to display arbitrary numbers as subscript in a treeview node's text?
|
|
|
|
|
I would start with making the control owner-drawn, and handling the DrawItem event.
.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
|
|
|
|
|
Hi Omnicoder,
fyi : I am using an excellent WinForms TreeView control called the Integral UI TreeView [^] from Lidor Systems.
Doing html/xml formatted text in Node Text, or in complex content (including other WinForm controls "inside" the Node !) is a great feature : here's an example of how easy it is to do subscripted text :
iuTV1.Nodes[0].Content = "<div>A text with Subscript <font size=\"5\">12</font></div>";
That would result in the first (root level) TreeNode in the instance of the Integral UI TreeView named "iuTV1" being having its run-time text set to
"A text with Subscript " followed by the subscripted text "12."
You could even put a whole HTML/XML table with really complex formatting in Node Text, or anywhere else, if you wished; it's using a very standard "vanilla" set of the most commonly used basic HMTL object and property codes.
Ability to import/export the "whole" Integral UI TreeView (with all its complex visual styles and, possibly, use of controls in Nodes) to XML : that's built-in, implemented simply and cleanly, and does support "HTML Entity Codes" for ASCII like  
If you want to just export/import part of an IUTV (some node with all its possibly nested sub-nodes, or some very complex multi-selection of Nodes) : easy to implement in your own code with a simple work-around (I just instantiate a "hidden" instance of an IUTV [i.e., never actually placed on a Winform], clone the selection to that IUTV, and then save that whole "hidden" IUTV), and I understand that will soon be built-in to the IUTV so you can import/export part of an IUTV to, or any selection to XML as simply as you can save the whole IUTV now.
I've been using the IUTV intensely for over a year; I upgraded to their entire Suite once I saw how good the IUTV was; their technical support is excellent; I'm delighted to say they've actually put a few features into the IUTV that I've suggested over the course of the last year
So it gives me pleasure to recommend their TreeView to you.
best, Bill
"Many : not conversant with mathematical studies, imagine that because it [the Analytical Engine] is to give results in numerical notation, its processes must consequently be arithmetical, numerical, rather than algebraical and analytical. This is an error. The engine can arrange and combine numerical quantities as if they were letters or any other general symbols; and it fact it might bring out its results in algebraical notation, were provisions made accordingly." Ada, Countess Lovelace, 1844
modified on Friday, December 18, 2009 6:31 PM
|
|
|
|
|
I am trying to use a hashtable (or equivalent) to store and recover a number of small structures or classes.
The hashtable record will need to have a UInst32 key and an associated data structure or class that looks some thing like this:
bool bRecUsedFlag;
UInt32 uiPGN;
UInt32 uiRecCtr;
byte[] bPGNData;
I can see odd references that indicate that this is possible but every attempt I have to code it is failing.
Can anyone give me a small example of how to create this table, add records to it and get records from it please?
Many thanks, Bruce
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
