|
You're still using ADODB in a .NET application; you should look at switching to ADO.NET[^] instead, which has much better support.
Using ADO.NET for beginners[^]
Migrating from ADO to ADO.NET[^]
The problem is most likely that ADO is returning an ADODB.Field object, which can't be used with string concatenation. If I remember correctly, you need to access the field's Value property, and convert that value to a string:
sOutput2 = Convert.ToString(qresults("DEPT").Value)
You should also specify the types of your variables when you declare them:
Dim sOutput1 As String
Dim sOutput2 As String
Dim sOutput3 As String
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Thank you! The .value was it!!!!!!!! Wahoo!! I can finally finish this project that has taken way too long... 
|
|
|
|
|
This is classic ASP code, you can't just put it on an aspx page and expect it to work. You'll need to rewrite using c# (or vb.net which might be more familiar to you) and ADO.net
|
|
|
|
|
Hello,
I am not quite sure but using + operator will work for string.Please try and keep us updated
|
|
|
|
|
I have a scheduling service, which is a little WCF library hosted in a Windows Service, for the robustness of restarting on failure, and unattended startup. I have a small WPF GUI for both these services, to stop and start the host, and to force processing in the WCF, that normally only occurs every hour or so (Polling Timer #1), then to monitor a DB table I log events to. So, I have two processes running here, The Host (Windows Service), and the GUI, where the GUI is only supposed to run when needed, and the host runs constantly to ensure that the WCF is always able to do its hourly processing. Both processes are constantly using the event logging table in the DB.
I have had a wonderful learning experience (to keep things polite) in ensuring the GUI is always up to date, and responsive. This means the enabling and disabling of commands based on the service status, e.g. the "Start" button is enable based on whether the Windows service is running or not; then a TextBlock that shows the current status of the WCF, e.g. "Idle", "Polling", "Processing". Also, in the central/default view of the GUI, is the DataGrid that displays the contents the logging table (Polling Time #2), and I have a few methods where I wait on a Task that may time out (using a kludgy little util method, not async/await). After a hard few days, I have managed to slightly clear up what was an insane spaghetti mess of Timer, Task, and event threads and deadlocks.
I'm now trying to gather lots of advice, in general, from those of have gone before me with this pattern of requirements. Tips could include: How to avoid using timers; how to manage a Windows Service from you GUI and maintain sanity; how to absolutely minimise timers (apparently .NET, even at 4.5.1, simply erases exceptions that are thrown from within Timer event threads); how to survive exceptions that are thrown inside async void methods (apparently these burn the house down).
Then anything else you might recommend, besides barrels of alcohol.
PS: Oh yes, I have Polling Timer #3 as well, to monitor the status of the Host, to disable the GUI trying to communicate with it.
No object is so beautiful that, under certain conditions, it will not look ugly. - Oscar Wilde
modified 15-Mar-15 3:37am.
|
|
|
|
|
Brady Kelly wrote: Polling Timer #1
Replace the timer with a dedicated low-priority thread that loops with a long sleep. When creating a thread, always have a try-catch in the executing code that at least writes the ex.ToString() to the debugger.
Brady Kelly wrote: Also, in the central/default view of the GUI, is the DataGrid that
displays the contents the logging table (Polling Time #2),
If you are watching processes you own, then you could opt to have those processes not only log to a table, but simultaneous update a memory-mapped file. Updating from there whenever there's a change might be a bit faster. You'd also want to broadcast some event whenever you do such an update - the display-app need not poll if it can wait for such an event.
Aight, forget the memory-mapped file; your display-app could be updated over TCP/IP whenever there is something to report.
Brady Kelly wrote: Then anything else you might recommend
Try and catch in every thread, and give each thread a decent name. Helps in debugging
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Thanks Eddy, all good looking stuff, but what do you mean by "your display-app could be updated over TCP/IP"? I can add a callback to the WCF, but the WCF calls code all over town that logs stuff. It would take some work to make the WCF code aware whenever any one of my libraries logs something.
Just BTW, the logging all goes through NLog. That has something like a `MemoryTarget` somewhere, which does raise an event, but then I have to use one logger in all my library code, and have that injected from a core instance in the WCF code itself. Not a train smash, but I'll have to do some Unity refresher reading, and just hold thumbs I can get that working without introducing more bugs.
No object is so beautiful that, under certain conditions, it will not look ugly. - Oscar Wilde
|
|
|
|
|
Brady Kelly wrote: what do you mean by "your display-app could be updated over TCP/IP"? I can add a
callback to the WCF, but the WCF calls code all over town that logs stuff.
I don't know WCF, but I'm familiar with remote debugging. It's essentially a OutputDebugString over the network.
Brady Kelly wrote: That has something like a `MemoryTarget` somewhere, which does raise an event,
but then I have to use one logger in all my library code, and have that injected
from a core instance in the WCF code itself.
..here I don't know what a core instance is. Do me a favor, write an article on the code once it works
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
I've decided to rather stick with a timer for now, because there is a massive amount of logging going on here, and with a timer I can more easily ignore it if I prefer, instead of getting too wrapped in with something that only occasionally needs to be observed real time.
The mysterious "core instance" is just a bad term I used to describe the uncertainty I had over whether it should be a singleton, or a new instance for each injectee, but made by a factory that is a singleton, or maybe just conjured up by Unity or something.
There are so many blog rants paired with educational articles built up around this project it's not funny. I started late today (writing a blog, that is) but won't easily be able to stop. Just let it flow. 
No object is so beautiful that, under certain conditions, it will not look ugly. - Oscar Wilde
|
|
|
|
|
Brady Kelly wrote: The mysterious "core instance" is just a bad term I used to describe the
uncertainty I had over whether it should be a singleton, or a new instance for
each injectee, but made by a factory that is a singleton, or maybe just conjured
up by Unity or something.
"some object" 
Brady Kelly wrote: There are so many blog rants paired with educational articles built up around
this project it's not funny.
Often tied to a platform, specific logger, or the one example on how to inject a logger.
Brady Kelly wrote: I started late today
You're not using Worpress, right? 
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
As I typed, I had a vision of "some object" sitting quietly in the corner, but emanating out into the furthest reaches of the least covered library code. This suggested a name with some more meaning.
I am indeed using WordPress, but I kept my eye quite firmly on the "Save a draft" button until I closed that tab.
No object is so beautiful that, under certain conditions, it will not look ugly. - Oscar Wilde
|
|
|
|
|
|
Background: I am familiar with C# also Winforms - also did some programming there. Also familiar with Java. (Also bit of HTML)
Now,I wanted to decide which to learn Android development or ASP.NET MVC.
But your advice would be very valuable since I can't learn the two at the same time. Given my background which of them needs less commitment? Which requires less effort? In which there is less information to process? (I am asking like this because I have some other commitments at this stage too).
nb: Also I was but hesitant initially whether I liked web development (never tried though) - that is why I thought about Android because it resembles more desktop development I believe, due to API usage etc; and I know I like C# and Java should be fine too.
I would really appreciate your input. Because in my country the direction I am currently working in is not very demanded (C embedded, and bit of C++).
|
|
|
|
|
I love how ridiculous questions like these are.
Why? Well, it's easy. We don't know you. We have no idea what your REAL background is. We have no idea what you really know, what your skill set is really like, how fast you pickup new stuff, how well you apply your previous experience, ..., NOTHING.
Nika Dev10 wrote: ...since I can't learn the two at the same time
B U L L S H I T
Why did I just say that? See above.
For my current project at work, I had to learn Entity Framework, MVC, ASP.NET, Razor, javascript, HTML5, Kendo UI, jQuery, ... , oh and, at home, I'm teaching myself digital electronics, constructing USB controllers, PIC microcontrollers, Windows Drivers, kernel debugging, ... ALL AT THE SAME TIME!
Who gives a sh*t where your country is headed as far as demand? The real question is what do YOU want to do? Where do YOU want to take your skills?
|
|
|
|
|
I really advise you to calm down. There is nothing ridiculous going on here, except your reply!
Now, relax, read the question once more - try to
grasp what was asked there and then reply, without
your silly remarks please.
To get a hint how the proper reply should look like
please look on replies on Android forum - I posted it
there also (hope didn't violate any rules - people
there understood what I wanted unlike you).
Anyway, please let's end our discussion here
you show no sign whatsoever that it may make
sense to continue dialogue with you.
ps and please don't pollute the Android forum
in case you think up to post something there
with intent to spoil things.
pps I already gave you idea about my background
in the opening of my question
|
|
|
|
|
Really?
What if I told you it should take you 3 days to pickup ASP.NET/MVC and it didn't. It took you say, 3 months. What then?
How would you measure "effort" in a quantitative fashion, independent of individual abilities and experience?
All I'm saying is that YOU are the only person on this planet that can answer your question and the only way you're going to get a feel for how long it's going to take to be productive in your next project is to just jump right in.
Nobody ever stops learning this stuff so there is no way to "complete" the studying. There is always stuff to learn, even if you've been working with the technology for years.
|
|
|
|
|
Your response is stupid.
Of course everything depends on everything, but you can always
do some estimates.
And tell a person a rough (reasonable) estimate.
For example, which is more to learn,
whole iOS SDK and to get familiar with it,
or just HTML syntax? Does this answer also depend?
I told you my background
and asked a simple question but you don't want to
understand it. Ok I am done here.
|
|
|
|
|
Forget any pain ... and go for the "gold".
If you're open to learning a new platform, I would suggest Android over any flavor of ASP.NET (MVC; Forms).
"Freelance" Android opportunities are currently running around 10 to 1 compared to ASP.NET.
(Freelance is all I do; if you're really interested in a "corporate" job, then the spread is probably smaller).
Go for a steady income ... then start looking for other things to do if you're not having enough fun.
(Keeping in mind than if you do decide to concentrate on sharpening your C# skills, you can transfer those to Android via Xamarin's cross-platform development software).
|
|
|
|
|
Indeed. I have been woefully scanning past the tons of Android jobs in my freelance notification emails, looking for the one or two .NET jobs. Time to fire up Android Studio again and get learning.
No object is so beautiful that, under certain conditions, it will not look ugly. - Oscar Wilde
|
|
|
|
|
I agree with Dave, there is no way anyone on this planet can answer your question. Maybe you have a natural ability for one technology but not the other. Maybe you find one interesting but not the other. Maybe one resembles another technology you have used previously but not the other.
No one on this or any other forum can give you anything other than guess based on their own personal experience.
My advice would be to spend some time learning BOTH and see how you get on.
"There are two ways of constructing a software design: One way is to make it so simple that there are obviously no deficiencies, and the other way is to make it so complicated that there are no obvious deficiencies. The first method is far more difficult." - C.A.R. Hoare
Home | LinkedIn | Google+ | Twitter
|
|
|
|
|
how can we convert a code written in c# into matlab??
any idea?
|
|
|
|
|
By using an online Converter[^], or rewriting it by hand.
MATLAB will not have all the functionality of the .NET framework though.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Nor vice versa!
A positive attitude may not solve every problem, but it will annoy enough people to be worth the effort.
|
|
|
|
|
Hi everybody  !
I am looking for an automated tool or script that will take a huge Borland C++ buider project and convert it into Visual Studio .NET project. A full conversion is not necessary, rather a starting point for manual intervention.
So, after researches, i focused on the vcl conversion part to .Net, win api, so i want to know if is there a tool that can do this , at worst, just partially,
|
|
|
|
|
Please do not post the same question in multiple forums.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
