Forgot your password?
Sign in with
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View PHP questions
View Visual Basic questions
All Message Boards...
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Design and Architecture
Internet of Things
C / C++ / MFC
ATL / WTL / STL
Objective-C and Swift
Hardware & Devices
Hosting and Servers
.NET (Core and Framework)
Site Bugs / Suggestions
Spam and Abuse Watch
The Insider Newsletter
The Daily Build Newsletter
Most Valuable Professionals
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
What is 'CodeProject'?
Ask a Question
Bugs and Suggestions
Article Help Forum
Comments by Member 12719658 (Top 19 by date)
I apologize if I came across wrong. I edited my question previously since I was on my phone writing it. As per my edit, I was just wanting to know what would be the best way to store data in a database without losing the integrity of the formatted data from a C# program. I have noticed before by updating or inserting data from a string - character returns and spacing have changed and I wanted to make sure I didn't lose them. So I asked if encrypting or hashing would be better. However, I provided a block of code as an example of what would be stored and was only to show the format of the text. I didn't realize that compressing and decompressing would do the trick.
I apologize if I was not clear enough and will give you stars for your help. I just could not see where Ordering came into play, however, I may have wrote a question that was not understandable.
Thanks for your help.
Well, that had nothing to do with my question. It was asking if I should update database with formatted text or encrypt it / hash. Nothing to do about ORDER BY or AUTOINCREMENTS or DataTypes. I think your response was auto generated or something so no points for you.
Well, right now I am AES encrypting the text. Everything works fine, but not sure if i should keep it encrypted or would hashing it to hex or something would be better.
What do you think? The code blocks that I insert into SQLite can be pretty long (its actually text from my .cs files and could be text from java file also) so I do not know if there is a way to make sure to keep the integrity of the format more secure or would encrypting it be fine.
I do not care about security of the files really.
I will use the improve question widget and move my response. I am sorry that my original question did not make sense; however, it did in my mind at that time. To have the responses that I had were totally immature and people that want to reply and just make statments like "You are unhappy, too bad for you" is just ignorant. I would think if a question is not concrete enough to understand a simple, "Can you supply more information because it is unclear why you are asking" is far more respected then an insult or childhood drama. Maybe 3 tours in Afghanistan made me see differently and I cannot see the humor behind their reaponses, but it just seems irresponsible and not very professional from someone that wants to call themselves a professional.
Thank you and I will "improve my question.
I am 45 years old, full time job and not going to school. My daughter is 7 years old. There was no "guiding" involved, but complete put downs. I never took coding when I went to school and I am sure schools these days dont ask for a project about dogs barking. I will just tell my daughter to write everything down and we can try to figure out the percentage and math on paper. Assuming is not the correct way to reply to a person question.
Thank you for your reply; however, I may have not explained it correctly or you do not undertand what I wrote. Instead of saying I have a lack of logic why don't you instead ask if I could be more clear? Otherwise, please do not reply at all.
I understand a bark is an event, but my statement is not meaningless and it has logic that makes perfect sense.
What I am looking for is a way to get a prediction of when a dog would bark the most throughout the day, week or month. If I have a record that shows that an event occurs 3 times during a week at 10 am and twice at 1 pm, and to track that event for one week would show that the dog barked 33.33% of the time at 10 am and 66% of the time at 1pm. This, to me, is perfect programming logic.
Now if the dog barked on Monday at 10 am and again at 1 pm then again on Wednesday at 1 pm that would change the percentage to not only 33% at 10 am, but would make Monday 66% of the barks.
What I am not understanding is when trying to come up with a percentage how would someone take onto account a day, week and month?
I have watched many tuts and think I have a working API. At least I it is working on my PC. Now, I need to put it online, however, not sure where and what will the web address be? What files go online and how do I put other files in WPF program so when user clicks a button it will use the API and check?
Thank you for that link. Now, I am sure this should be a different forum question, but right now I am using godaddy with a dedicated server on a Linux server. I see letsencrypt you have to have apache enabled and this comes with godaddy's Linux, however, I might change to Windows server instead so I can add some online forms. Do you know about SSL on Windows hosted server?
Looking at my website - godaddy charges for HTTPS that I cannot afford right now. If my website will not be HTTPS enabled right now, I will just need to encrypt the API code correct?
Thanks for the reply. Yes, the namespace does match my application. That part I didn't copy and paste over.
The errors are now only in regard to:
1. Cannot implicitly convert type 'object' to 'int' (int usage = dataReader["Usage"];)
2. (in the DBConnect class)The name 'kc' does not exist in the current context
3. (in the DBConnect class)The name 'usage' does not exist in the current context
4. (in the WPF Window)The name 'getKeyCode' does not exist in the current context
5. (in the WPF Window) The name 'UpdateKeyCode' does not exist in the current context
Regarding this code - I am trying to test and I am getting a lot of errors that names do not exist in the current context and also names cannot be found. If you have time - could you look over the code and/or send me a demo solution?
Question - with this code it will leave the connection string in the code. Would this be vulnerable having the server connection string to my online database hard coded?
Thank you for your reply. I will check this out and test to see if I have any issues. Always, when it comes to this type of subject - I want to test everything to see what direction I need to go.
Great! Thank you for the API link. This is going to be a huge help. With your example and help on this link i think i can have this closed.
Thank you very much for the reply. So with this call I suppose the controller is a file located on my web. If so, I don't see where it is looking into a database and if value is there and other value = 0 then authenticate. I have never created API's before so sorry if I am completely clueless on this.
Thanks P_Z. I accepted yours as the Best Solution because I like your idea of creating a temp table to do this. Now, I will need to search on how to put this into my original code. :)
Thanks again P_Z. I figured out how I need to do this. This was awesome and very fast to get a response. This can be closed as I am using your suggestion. :)
Thank you for the quick replies. I found out that the column "Value" is a tinyint datatype, which is causing issues while trying to run the statement. I am trying to come up with a way to copy the table to another table then run it - Like in P_Z reply. Unless you have any suggestions?
So, with your suggestion, it should look like this?
SqlCommand objcmd = new SqlCommand("SELECT LastName, FirstName, ( case Value
when 1 then 'Started'
when 2 then 'Stopped'
when 3 then 'Stopping'
end )as Status, FROM table1", myConnection);
Keeps saying error on the Fill(dt).
Last Updated 1 Jan 1900
All Rights Reserved.