16,015,559 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Crixalis Paul (Top 75 by date)
Crixalis Paul
7-Jun-16 21:53pm
View
Im not Good in C# :(
Crixalis Paul
7-Jun-16 21:38pm
View
Do you think sir the answer you post can be connected in Database?
Crixalis Paul
7-Jun-16 21:33pm
View
Im sorry sir, It wont happen again. I will communicate with you asap. TYSM for help
Crixalis Paul
6-Jun-16 21:41pm
View
Sir are you still online? I hope you can help me. This is Winforms
Crixalis Paul
6-Sep-14 14:57pm
View
please sir bear with me im just an amateur programmer is there other way like links? :(
Crixalis Paul
6-Sep-14 14:47pm
View
thank you for the the link i want to know how can i export my selected map into a file and connect this on my website that im making.
Crixalis Paul
12-Feb-14 4:25am
View
Sir
Crixalis Paul
12-Feb-14 4:11am
View
Sir that is my code i am using as of know.
let me give you an example to check that the data inserted exist, we decided to have a daily check for example:
Monday: Data has been saved
Tuesday: Inserted data exist
Wednesday: Inserted data exist
Thursday: Inserted data exist
Friday: Data is lost
How can i fix it?
Crixalis Paul
12-Feb-14 4:02am
View
sir i already improve it
Crixalis Paul
7-Feb-14 7:04am
View
i want to do it even if it hard because you say it is possible please help me because the data is very important for me. plsss
Crixalis Paul
30-Jan-14 23:40pm
View
Your code only show the data but i want to update it
Crixalis Paul
23-Dec-13 3:22am
View
mysql> SELECT surname,effdate
-> FROM personinfo
-> WHERE (effdate between '12/01/2013' and '12/21/2013') and (workstatus in
('HIRED','REASGD'))
-> ORDER BY surname ASC limit 1,10;
+-----------+------------+
| surname | effdate |
+-----------+------------+
| BALICAO | 12/15/2012 |
| BATINO | 12/16/2009 |
| BERNARDEZ | 12/16/2002 |
| BOSI | 12/1/2013 |
| CRUZADO | 12/1/2007 |
| DALISAY | 12/1/2006 |
| DAPAC | 12/17/1999 |
| DIANA | 12/16/2013 |
| DIANA | 12/16/2013 |
| FACTOR | 12/14/1992 |
+-----------+------------+
10 rows in set (0.06 sec)
there is 1992,2012,2006 how can i fix this?
Crixalis Paul
21-Dec-13 20:58pm
View
5 for me to and thaNk you :D
Crixalis Paul
16-Dec-13 23:10pm
View
Sir Everything :(
Crixalis Paul
16-Dec-13 17:47pm
View
Sir Im sorry I didnt get your point even i tried. I just want to put the new colored image in the right position and thats in the picturebox
Crixalis Paul
3-Oct-13 19:17pm
View
For example: You give your picture, a formal picture to me and for example i have a sample picture of haircut. what will happen is that my picture of hair will fit to your head perfectly.
Crixalis Paul
19-Sep-13 8:59am
View
I don't know what to search and how to start it. can you give me a sample site?
Crixalis Paul
19-Aug-13 5:23am
View
can you give me an explanation for that.
Crixalis Paul
8-Aug-13 0:43am
View
Can you give me a tip or any substitute at my question?
Crixalis Paul
8-Aug-13 0:21am
View
As of know I am using Microsoft Access Database but after I finished my Project the database that I am using will be changed to Microsoft SQL.
Crixalis Paul
5-Aug-13 11:05am
View
Sir can you give me simple tip for that? cause i know what your talking about. lets just say that your the panel and i will give it to you to check and also approve. what can you say sir?
Crixalis Paul
1-Aug-13 2:13am
View
Please Help me with this
Crixalis Paul
1-Aug-13 1:33am
View
Deleted
.....
Crixalis Paul
1-Aug-13 1:22am
View
In the calculation of age.
how can i do that? do i need to use update? but how sir?
Crixalis Paul
28-Jul-13 8:06am
View
this is not working sir in the textchanged event
Crixalis Paul
28-Jul-13 6:31am
View
How is the code for that sir?
I am only new in this programming
Crixalis Paul
28-Jul-13 6:27am
View
No sir i will not include any spaces at all. If i will input pauledward it must be p,a,u,l,e,d,w,a,r,d and there is no spaces will be put and how to do that will the data is typing?
Crixalis Paul
28-Jul-13 5:54am
View
Sir can this be apply on Microsoft Access Database?
Crixalis Paul
25-Jul-13 1:33am
View
I already improve it sir
Crixalis Paul
21-Jul-13 8:09am
View
why did you not reply sir
Crixalis Paul
21-Jul-13 7:58am
View
Sir?
Crixalis Paul
21-Jul-13 7:48am
View
Sir can you make the same code in this kind of simulation?
For Example if I input "a" in textbox2.text so the output will show in label39.text like this
"a"
If i input "y" the output will be "a","y"
and lastly if i input "b" the output must be "a","b","y"
Crixalis Paul
21-Jul-13 7:28am
View
No sir :(
Crixalis Paul
21-Jul-13 7:13am
View
I already answer my question number 2 please help me on the first question please. just on the first question
Crixalis Paul
21-Jul-13 6:52am
View
Sir please give me a sample code and i will continue the rest of it just a hint sir
Crixalis Paul
21-Jul-13 6:40am
View
Sorry sir :(
how can i code this?
Crixalis Paul
21-Jul-13 6:33am
View
Sorry for what I've Done
Crixalis Paul
11-Jul-13 0:43am
View
Good Tutorial but sorry i will not Accept it "Accept Solution"
Crixalis Paul
7-Jul-13 10:20am
View
I dont know what to say :(
I just need a right answer for my problem. a very big help is i need
Crixalis Paul
7-Jul-13 10:15am
View
What i need to do to publish my website w/out web hosting?
Crixalis Paul
7-Jul-13 10:04am
View
Please give me further Explanations
Crixalis Paul
4-Jul-13 21:51pm
View
Sorry sir for my bad English what i am trying to say is That I am sorry because that's not the answer i need, but i will accept what you said because many people say the same answer as what you said. Sorry for arguing with you
Crixalis Paul
30-Jun-13 7:12am
View
Thats not the answer. I need Sorry
Crixalis Paul
24-Jun-13 22:46pm
View
than you sir
Crixalis Paul
24-Jun-13 22:42pm
View
sir can you convert it in vb.net? because your edit is made on c-csharp and im not good in that
Crixalis Paul
24-Jun-13 22:37pm
View
AND THE FORM 2 WILL HIDE
Crixalis Paul
24-Jun-13 22:36pm
View
I will explain it.
My Form1 is Login Form
and My Form2 is The Main Program.
So its obvious that the user must pass a login form (kind of security) before he/she enters the prgram.
and when i run the program i make both form1 and form 2 to show and the form2 is set false in the enbled property and it will only turn to true if the user pass the security and the log in form will hide.
my log in form code is ok and the codes for saving the user's name is also ok.
My only problem is that the code for saveing the user's name is embeded on the event called
FormClosing and its working.
I just wanna know if form hide is not suitable what else of event can i use to initiate the code of saving user's name without affectiong the form2.
TY -SA
Crixalis Paul
24-Jun-13 22:28pm
View
I have a program that will save the user who log in in the system and its working, but its working when login form closes so the whole program close so i want to know how to run it when the login form hides
Crixalis Paul
20-Jun-13 0:33am
View
I already remove that sir. but its still not working
Crixalis Paul
20-Jun-13 0:20am
View
The error is (Sytax Error in Insert Statement
)
Crixalis Paul
20-Jun-13 0:10am
View
These is my whole code and i will show you each of it with explanations.
I have an access database namely register and with a table named login.
In the login table these are my fields
-PersonelName
-Position
-Username
-Password
-PIN
then I save this as 2003 filr (register.mdb) in the desktop location
These is my 1st code that includes imports.
Imports System.DateTime
Imports System.Data
Imports System.Data.OleDb
Imports System.Windows.Forms
My second code is all the declarations together with the Provider.
Dim cnnOLEDB As New OleDbConnection
Dim strConnectionString = "Provider=Microsoft.jet.oledb.4.0;data source=C:\Users\mypc\Desktop\register.mdb;"
Dim cmdInsert As New OleDbCommand
Dim cmdupodate As New OleDbCommand
I put this on the public class form.
Then I put the code below on the form load
cnnOLEDB.ConnectionString = strConnectionString
cnnOLEDB.Open()
then lastly this is my code on insert that need to pass all the validations before inserting.
If TextBoxX1.Text = "" And TextBoxX2.Text = "" And TextBoxX3.Text = "" And TextBoxX4.Text = "" And TextBoxX5.Text = "" And TextBoxX6.Text = "" Then
MsgBox("Please fill out all the Information.")
ElseIf TextBoxX1.Text = "" Then
MsgBox("Please provide your name.")
ElseIf TextBoxX2.Text = "" Then
MsgBox("Whats your position in the company?")
ElseIf TextBoxX3.Text = "" Then
MsgBox("Please provide us your Username.")
ElseIf TextBoxX4.Text = "" Then
MsgBox("Please provide your Password.")
ElseIf TextBoxX5.Text = "" Then
MsgBox("Please Re-Type your Password.")
ElseIf TextBoxX6.Text = "" Then
MsgBox("Create your Own Personal Identification Number")
ElseIf Not (TextBoxX4.Text = TextBoxX5.Text) Then
MsgBox("Password and Repeat Password are not Equal.")
Else
Dim msg As String
msg = MsgBox("Filling Up Complete,Do you want to save It?", vbYesNo)
If msg = vbYes Then
cmdInsert.CommandText = "INSERT INTO [login] (PersonelName,Position,Username,Password,Repassword,PIN) VALUES (@PersonelName,@Position,@Username,@Password,@Repassword,@PIN);"
cmdInsert.Parameters.AddWithValue("@PersonelName", TextBoxX1.Text)
cmdInsert.Parameters.AddWithValue("@Position", TextBoxX2.Text)
cmdInsert.Parameters.AddWithValue("@Username", TextBoxX3.Text)
cmdInsert.Parameters.AddWithValue("@Password", TextBoxX4.Text)
cmdInsert.Parameters.AddWithValue("@Repassword", TextBoxX5.Text)
cmdInsert.Parameters.AddWithValue("@PIN", TextBoxX6.Text)
MsgBox("Registration Complete")
cmdInsert.CommandType = CommandType.Text
cmdInsert.Connection = cnnOLEDB
cmdInsert.ExecuteNonQuery()
TextBoxX1.Text = ""
TextBoxX2.Text = ""
TextBoxX3.Text = ""
TextBoxX4.Text = ""
TextBoxX5.Text = ""
TextBoxX6.Text = ""
Else
End If
End If
Thats all I hope its. oK
-
Crixalis Paul
19-Jun-13 23:24pm
View
Sir its still not working :(
Dim msg As String
msg = MsgBox("Filling Up Complete,Do you want to save It?", vbYesNo)
If msg = vbYes Then
cmdInsert.CommandText = "INSERT INTO login (PersonelName,Position,Username,Password,Repassword,PIN) VALUES (@PersonelName,@Position,@Username,@Password,@Repassword,@PIN)"
cmdInsert.Parameters.AddWithValue("@PersonelName", TextBoxX1.Text)
cmdInsert.Parameters.AddWithValue("@Position", TextBoxX2.Text)
cmdInsert.Parameters.AddWithValue("@Username", TextBoxX3.Text)
cmdInsert.Parameters.AddWithValue("@Password", TextBoxX4.Text)
cmdInsert.Parameters.AddWithValue("@Repassword", TextBoxX5.Text)
cmdInsert.Parameters.AddWithValue("@PIN", TextBoxX6.Text)
MsgBox("Registration Complete")
cmdInsert.CommandType = CommandType.Text
cmdInsert.Connection = cnnOLEDB
cmdInsert.ExecuteNonQuery()
TextBoxX1.Text = ""
TextBoxX2.Text = ""
TextBoxX3.Text = ""
TextBoxX4.Text = ""
TextBoxX5.Text = ""
TextBoxX6.Text = ""
Else
End If
Crixalis Paul
14-Jun-13 22:11pm
View
not to the front of the last label on the top of it
Crixalis Paul
6-Jun-13 1:34am
View
Im only just a simple student and Im new in programming world and yet I want kinds of program that looks hard to be created. It makes me shy if my menthor.Sie Sergey KNOWS ABOUT it i dont know how to code it pls healp. TY :(
Crixalis Paul
6-Jun-13 1:02am
View
Im only just a simple student and Im new in programming world and yet I want kinds of program that looks hard to be created.
It makes me shy if my menthor.Sie Sergey KNOWS ABOUT it
i dont know how to code it pls healp.
TY :(
Crixalis Paul
6-Jun-13 0:50am
View
5.
Crixalis Paul
5-Jun-13 22:57pm
View
I will explain it.
When running the program.
I will generate my first label.
(OK)
I will generate my second label
(OK)
THE first label will move down and the second label will be put on the top if the first label.
what is the code on that?
Crixalis Paul
5-Jun-13 22:53pm
View
Thank you for the Solution it means a lot but i think this is not what i want regardless about system designs
Crixalis Paul
5-Jun-13 22:48pm
View
I will make this in Vb.net windows Form
Crixalis Paul
5-Jun-13 5:40am
View
TY for the code
Crixalis Paul
5-Jun-13 5:33am
View
vb.net windows form sir
Crixalis Paul
5-Jun-13 4:25am
View
I think Sir. in making this program you must take many considerations.
Crixalis Paul
5-Jun-13 1:55am
View
Sir Ive Tried what you have been said to me and Its oK. but my point is I want to create a vb.net program of picture password as same exactly as Windows 8 Picture Password and I think its Hard. :(
Crixalis Paul
5-Jun-13 1:49am
View
oK sir i give it a try
Crixalis Paul
5-Jun-13 1:35am
View
Honestly I dont know where to start and what Should I do. Actually i didnt do anything if you will ask what i have done for now. sorry :( just a simple tutorial for me will be a great help. pls do help me
Crixalis Paul
5-Jun-13 1:35am
View
Honestly I dont know where to start and what Should I do. Actually i didnt do anything if you will ask what i have done for now. sorry :(
just a simple tutorial for me will be a great help. pls do help me
Crixalis Paul
5-Jun-13 1:33am
View
Sir. Sergey i just wanna ask if you can help me with this.
Crixalis Paul
4-Jun-13 1:32am
View
Maybe the reason of my problem is too much tiredness, Sir Sergey the code you see at the top is my latest code, but before that i declared a cmdinsert like this
dim cmdinsert as new oledbcommand
but on the top you will only see is cmd in addwithvalue
it also shows errors so i declared the cmd to address this issue
dim cmd as new oledbcommand
but the error is no value given in required parameters.
My solution is I delete what i declared "cmd" and change all the cmd's to cmdinsert's and it works well.
Menthor Sergey: Thank you for your Intention to Help
Crixalis Paul
4-Jun-13 0:41am
View
So you mean i need to filled up all the necessary fields? and dont leave any blank textboxes?
Crixalis Paul
3-Jun-13 23:51pm
View
Sir. Sergey i just wanna ask if you can help me with this.
Crixalis Paul
3-Jun-13 23:35pm
View
Yes Sir. youre right about that and it will be a great alternative security for system that is using text as username and password to access programs and i think it will also prevent sql injections or attack in my own opinion.
Youre welcome sir. from what you have said early
HONESTLY youre my 1st Menthor here :)
Crixalis Paul
3-Jun-13 23:04pm
View
Sir. Thank you for your time discussing it with me. I will do what you have suggested. Its a great honor meeting you.
Crixalis Paul
3-Jun-13 22:59pm
View
Thanks for what you had said. Is this the example of parameters you where talking about?
cmdInsert.Parameters.Add(cmdInsert.CreateParameter).ParameterName = "surname"
cmdInsert.Parameters.Item("surname").Value = TextBox1.Text
if not, can you give an example?
Crixalis Paul
3-Jun-13 22:48pm
View
Thank you for your solution, Is it fine if I don't use Parameters because the system i will make will only implement in a little business. or I just really need to use parameters
Crixalis Paul
3-Jun-13 22:42pm
View
Ron Beyer, your Right its really a nightmare and i also know parameters that your talking about and if i do that code by parameter, it will be the my cause of death :) just kidding I hope someone will help me further, anyway thank you for your suggestion. I appreciate it
Show More