|
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = "server='servername';database=D_MART;IntegratedSecurity=True";
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT PRODUCT_ID FROM PRODUCT_DETAILS";
cmd.Connection = conn;
conn.Open();
Console.WriteLine("Connection open!");
SqlDataReader sdr = cmd.ExecuteReader();
while(sdr.Read())
{
int PRODUCT_ID = (int)sdr["id"];
Console.WriteLine(PRODUCT_ID);
}
conn.Close();
}
catch(Exception ex)
{
Console.WriteLine("can not open connection!");
}
}
}
|
|
|
|
|
This is not the appropriate forum for this question. Under the Code Project logo at the top of the page, mouse over "quick answers" and click on "Ask a Question" in the menu that appears. Or use this link[^] and include "SQL" as one of the Tags.
|
|
|
|
|
Although I understand the point of removing the rep points from deleted items... the guy below could have a point.
If an article has been downloaded and upvoted and so on, but it gets so old that is really not worth to keep it online anymore... shouldn't the legitime reputation points awarded back in the day remain in the authors account?
If an article gets nuked due to spam, plagiarism or whatever other choice... then yes delete the reputation too.
In my opinion there should be a possibility to keep the points for something that just "aged" bad, without incurring in anything wrong with site policies.
I could imagine a button for the owner and / or staff that appears after X minimum time online and allows deletion without removing the reputation.
What do you think?
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
I agree there is a point. However, if points are kept, it should concern both negative and positive points.
However, that's only the authors side. I believe that a mechanism that would allow to close an article and clearly state it obsolete would be a good idea. All the article text should remain but the article would contain a clear statement that this idea/technology/approach is obsolete. This way the search engines would still find the content but when a reader comes in, she/he sees that this is something that should be avoided these days.
I think this approach would greatly help people that come in touch with something 'old' and don't yet know what to think about it or how to use it.
|
|
|
|
|
Wendelius wrote: but when a reader comes in, she/he sees that this is something that should be avoided these days.
And how would that work? Spend a little time in QA and see how many "developers" are proliferating, not just bad, but seriously dangerous, code. If an article is not valid then it should be deleted for ever.
I do take Nelek's comment about the reputation points.
|
|
|
|
|
Quote: If an article is not valid then it should be deleted for ever.
I would hope it wouldn't get through moderation in that case. Now, there's "not valid" for being dangerous and wrong, as you mentioned, and "not valid" for being obsolete, as Wendelius mentioned. The latter shouldn't be deleted, because legacy systems have remarkable tenacity. A few readers might even find such articles interesting from an historical perspective. But a comment noting their obsolescence would be a helpful warning to those doing new development.
|
|
|
|
|
But when the only text in the article is, "obsolete", it serves no purpose.
|
|
|
|
|
I agree that article without the original text servers no purpose. I also agree that if the article is initially bad it should not pass moderation or if it does, voting hopefully shows how bad an idea is.
What I mean is that over time things become obsolete and while I understand Nelek's initial post was about rep points (as was the first paragraph in my answer), I think it would be worth while to have a discussion what to do with obsolete articles.
Just an example, what about an article discussing about new features of a product version which nowadays is end-of-life and the features do not necessarily exist in newer versions. What if there would be an option to report such article as obsolete and if enough reports have been given, an 'obsolete' watermark would be added. Probably not the best way to handle such situation but some food for thoughts.
|
|
|
|
|
Wendelius wrote: What I mean is that over time things become obsolete and while I understand Nelek's initial post was about rep points (as was the first paragraph in my answer), I think it would be worth while to have a discussion what to do with obsolete articles.
To be honest... My original thought was about the complain below of losing the points for an obsolete article.
But to be honest I like the idea of keeping a good article with the warning "this is old stuff" or even "obsolete" if the content deserves it.
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Richard MacCutchan wrote: But when the only text in the article is, "obsolete", it serves no purpose.
That's why the article below got correctly deleted, and noone is saying anything about it.
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Richard MacCutchan wrote: If an article is not valid then it should be deleted for ever.
Obsolete != not valid.
I still read things from MSDN from 2005 or so, on totally obsolete parts of the .Net Framework but their content is so good that for me is very relevant today.
There is crappy / middle things that wouldn't be missed if deleted at all, but there still exist items where you can still learn about how to do things correctly, even when you can't exactly use that code because it got obsolete.
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
In the context of the article referred to the expression "not valid" means that there is no content that has anything relevant to technology. As the article that he wanted left on the website containing just the word "obsolete", there was no point in keeping it.
|
|
|
|
|
You are still speaking of the article below...
We are one or two steps ahead and speaking about possible suggestion / new functionality for the site...
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
I don't see how rewarding a poster that allows his code to become old should usurp any tendency o f the site, with all it's "editors" (you and I), to decide to punish him by retracting points from his ORIGINAL score; the score he receives for enlightening the community, and passing the censors (you and I, again), once his article/tiptrick/blog/project/etc squeezes through the moderation pipeline and ends up rattling around in new-CP-space.
Certain riding thoughts accompany this probably true scenario. One being that writers of ARTICLES know that their content is being downloaded. And I'll stop there because ... obviously they already have more knowledge about the point system than I do so further discussion would make my additions purely conjectural.
On that second thought then, there have been attempts by the authors of CP (not you and I, not members; whatever creature is running in the wheel at the time of it's appearance) to make light of the fact that much of the scoring is tallied in realtime and available at the touch of that coding wizard's paw, and I'd submit that you and I actually have little say at all when it comes to scores commensurate with identities and therefore shouldn't bother to care about such things.
|
|
|
|
|
|
When your article was (rightly) deleted, any reputation points attaching to it were also deleted, hence the changes. I am not sure what you are so unhappy about, there is no point in leaving a non-article (i.e the one marked obsolete) cluttering up the site.
|
|
|
|
|
Sorry Richard
I disagree 100% with your argumentation
(and honestly: sorry, seem you do not read carefully the message)
- The article was bookmarked. The bookmarks stay (at least) on the browser. now any bookmark is a broken link. (Error 404 is never a good thing)
- As I said: «If I had had the chance, my choice would have been to keep the old article and add a link to the new article» And the chance was not given to me. At all.
- When you buy handkerchiefs then, do you ask to be refunded when you throw them away after using them? (why should I lost my points after an article was deleted?)
- I wrote the article then is somehow I am the owner of that article (in the good and in the bad). Don't you think I have the right to participate in the decision to cancel it?
- If I had been aware that deleting an article means losing the relative points. I would never have deleted it. (this is cluttering the site !!!!)
I write some messages and participated to others, what I observed is a large percentage of people participating in the "chat" just to get "reputation points". I think that is a big limitation of this site!
Cheers
Vincenzo
|
|
|
|
|
The decision to remove your article was taken by one of the site admins, after discussion with you:
Re: Obsolete article? - Article Writing Discussion Boards[^]
Based on Sean's comment, you did have the chance to participate in that discussion. But the eventual decision on whether or not to leave a non-article published on this site rests with the site owners.
Your suggestion about redirecting links from the old article to the new article has some merit, and is worth discussing in this forum. I suggest you concentrate on that, rather than complaining about your non-article being removed.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
CodeErgoSum wrote: I disagree 100% with your argumentation
Well that is your free choice. But I doubt that the site is going to change the rules because one person disagrees with them.
CodeErgoSum wrote: now any bookmark is a broken link. (Error 404 is never a good thing)
Well that holds true for any bookmark anywhere on the internet.
And if people wish to read your article it is easy enough to find, via the search facilitiy, or by going to your home page.
And out of all this we come back to the question: Why did you mark the article as obsolete rather than just updating it with whatever new information you wished to add? That would have resolved all your questions without any difficulty, and you would keep your reputation points.
|
|
|
|
|
I Talked with the people of CodeProject: they wish to improve the voting system. Obviously, the site "is not going to change the rules because one person disagrees with them". But they are ready to have a positive confrontation and if the case...
«Well that holds true for any bookmark anywhere on the internet.»:
wrong.
«Well that holds true for any, not properly managed, bookmark anywhere on the internet.»:
That's correct!
«And if people wish to read your article it is easy enough to find, via the search facility, or by going to your home page.»
That could be a solution.
A "site centric" (ego-centric) solution.
I prefer a "custom centric" solution that makes easier the life of the user providing a direct link to the new article
«Why did you mark the article as obsolete rather than just updating it with whatever new information you wished to add? That would have resolved all your questions without any difficulty, and you would keep your reputation points.»
Why?
Just because Sean suggest to me to do that way.
Is that enough for you?
Let me finish saying that thinking more before speaking, this could have been the place where the community could have initiated a serious conversation that could possibly have led to some results
|
|
|
|
|
CodeErgoSum wrote: Let me finish saying that thinking more before speaking, this could have been the place where the community could have initiated a serious conversation that could possibly have led to some results
I did think; I was merely trying to explain why some things happened, and how they could be resolved.
|
|
|
|
|
In the "Discussions" block on the home page, threads are prefixed with a count. For a while it puzzled me that the counts often appeared too low, but I finally twigged that the displayed count is the number of direct responses to the original post (indent level one). [edit] .. or maybe something else again ... [/edit]
Maybe the total thread length might be a more useful number to display.
Not a biggie, in fact barely above the noise level...
Cheers,
Peter
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
modified 22-Jun-21 20:53pm.
|
|
|
|
|
Both Chris and I have looked and didn't see a discrepancy. If you see it again, could you capture an image, or at least describe what you see and identify the message that is of concern.
Thanks
"Time flies like an arrow. Fruit flies like a banana."
|
|
|
|
|
Actually, it appears to be a caching issue. I think I need to reduce the cache duration.
"Time flies like an arrow. Fruit flies like a banana."
|
|
|
|
|
Hi. I've been trying to add ESP32, STM32 and ESP-IDF tags to submitted content, but they do not show up.
I've checked my reputation/privileges and it says I can add tags. After trying twice, here I am.
What am I missing? I simply go to the article I'm editing, to the tag heading, and as items in the comma delimited list I type ESP32, ESP-IDF and nothing happens when I submit. It's as though I never entered them.
So my question is, how do I add tags?
Real programmers use butterflies
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
