Comments by Crixalis Paul (Top 75 by date)

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.

Sir

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?

sir i already improve it

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

Your code only show the data but i want to update it

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?

5 for me to and thaNk you :D

Sir Everything :(

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

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.

I don't know what to search and how to start it. can you give me a sample site?

can you give me an explanation for that.

Can you give me a tip or any substitute at my question?

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.

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?

Please Help me with this

In the calculation of age.
how can i do that? do i need to use update? but how sir?

this is not working sir in the textchanged event

How is the code for that sir?
I am only new in this programming

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?

Sir can this be apply on Microsoft Access Database?

I already improve it sir

why did you not reply sir

Sir?

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"

No sir :(

I already answer my question number 2 please help me on the first question please. just on the first question

Sir please give me a sample code and i will continue the rest of it just a hint sir

Sorry sir :(
how can i code this?

Sorry for what I've Done

Good Tutorial but sorry i will not Accept it "Accept Solution"

I dont know what to say :(
I just need a right answer for my problem. a very big help is i need

What i need to do to publish my website w/out web hosting?

Please give me further Explanations

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

Thats not the answer. I need Sorry

than you sir

sir can you convert it in vb.net? because your edit is made on c-csharp and im not good in that

AND THE FORM 2 WILL HIDE

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

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

I already remove that sir. but its still not working

The error is (Sytax Error in Insert Statement
)

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
-

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

not to the front of the last label on the top of it

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 :(

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 :(

5.

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?

Thank you for the Solution it means a lot but i think this is not what i want regardless about system designs

I will make this in Vb.net windows Form

TY for the code

vb.net windows form sir

I think Sir. in making this program you must take many considerations.

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. :(

oK sir i give it a try

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

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

Sir. Sergey i just wanna ask if you can help me with this.

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

So you mean i need to filled up all the necessary fields? and dont leave any blank textboxes?

Sir. Sergey i just wanna ask if you can help me with this.

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 :)

Sir. Thank you for your time discussing it with me. I will do what you have suggested. Its a great honor meeting you.

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?

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

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