User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 401,535 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,385 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Views: 961 | Replies: 11 | Solved
Reply
Join Date: Jul 2007
Posts: 100
Reputation: hawisme000 is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 2
hawisme000's Avatar
hawisme000 hawisme000 is offline Offline
Junior Poster

How to Make Encrytion on Database? using VB

  #1  
Feb 4th, 2008
my prof told me to make my thesis system encrypt all that i save on it (on the add/save part of
a file maintenance) ... thats all he said,

ive seen something like this, but cnt remember...

can any1 help me on making a program that when ever i save a data to a database(using VB)
that data will be encrypt?? or some what be jumbled??

my only idea for this is using the ..... hmmm, changing the keydown sumthing of each letter i write when saving it to a database,


ex.

i try to save the word "MYNAME" on a database

then when i open the database

instead "MYNAME" is there

i will see sumthing like "SJWCNZ" (it changes the letter/or somewhat jumbled)


pls help me, i wanna learn how to make this,
thx a million for those who's willing to share
Last edited by hawisme000 : Feb 4th, 2008 at 12:26 pm.
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Nov 2007
Location: ★ Jogja ★
Posts: 2,473
Reputation: Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light 
Rep Power: 9
Solved Threads: 215
Jx_Man's Avatar
Jx_Man Jx_Man is offline Offline
Nearly a Posting Maven

Re: How to Make Encrytion on Database? using VB

  #2  
Feb 4th, 2008
See this my encryption method, this a simple one. you can use this code to save the encryption result to database and read database with encryption reading.
Encrypt.zip
This is a screenshoot from my encryption.
Encrypt.bmp
Last edited by Jx_Man : Feb 4th, 2008 at 2:50 pm.
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
Reply With Quote  
Join Date: Jul 2007
Posts: 100
Reputation: hawisme000 is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 2
hawisme000's Avatar
hawisme000 hawisme000 is offline Offline
Junior Poster

Re: How to Make Encrytion on Database? using VB

  #3  
Feb 4th, 2008
ok sir ive seen your code, and its really good, but theres something i cnt understand about it

the line

CriptVariable = Asc(Mid(Label1.Caption, i + 1, 1)) - 77

whats "Asc" , "Mid" use?
also what are those number for?
i + 1, 1)) - 77
what do they do?

pls explain it to me,

ohh 1 more thing about the

"reDim" also pls....


TY!!
Reply With Quote  
Join Date: Nov 2007
Location: ★ Jogja ★
Posts: 2,473
Reputation: Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light 
Rep Power: 9
Solved Threads: 215
Jx_Man's Avatar
Jx_Man Jx_Man is offline Offline
Nearly a Posting Maven

Re: How to Make Encrytion on Database? using VB

  #4  
Feb 5th, 2008
asc = to get ascii.
mid = take a letter from taken value position and sum of value which it taken.
ex: mid("perfect",2,4) result = erfe
ReDim statement to serve as the initial declaration of a dynamic array. The array does not have to be declared anywhere else.

Asc(Mid(Label1.Caption, i + 1, 1)) - 77
get letter from label1 with mid function start from i+1 as many one letter and the result convert to ascii. then ascii be shift as 77.
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
Reply With Quote  
Join Date: Jul 2007
Posts: 100
Reputation: hawisme000 is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 2
hawisme000's Avatar
hawisme000 hawisme000 is offline Offline
Junior Poster

Re: How to Make Encrytion on Database? using VB

  #5  
Feb 5th, 2008
ex: mid("perfect",2,4) result = erfe


so the number "2" will be start ??
and then the number "4" will be how many letters it will get from the word?
pls correct me. if wrong

what if this will be the code

mid("username",4,3)

will the result be = rna ?
Reply With Quote  
Join Date: Nov 2007
Location: ★ Jogja ★
Posts: 2,473
Reputation: Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light 
Rep Power: 9
Solved Threads: 215
Jx_Man's Avatar
Jx_Man Jx_Man is offline Offline
Nearly a Posting Maven

Re: How to Make Encrytion on Database? using VB

  #6  
Feb 5th, 2008
yes
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
Reply With Quote  
Join Date: Jan 2008
Posts: 37
Reputation: ITKnight is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 1
ITKnight's Avatar
ITKnight ITKnight is offline Offline
Light Poster

Re: How to Make Encrytion on Database? using VB

  #7  
Feb 7th, 2008
what a wonderful code...
Reply With Quote  
Join Date: Jul 2007
Posts: 100
Reputation: hawisme000 is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 2
hawisme000's Avatar
hawisme000 hawisme000 is offline Offline
Junior Poster

Re: How to Make Encrytion on Database? using VB

  #8  
Feb 7th, 2008
Thx! help me alot,

got 1 more question its ok if you wont answer it anymore,,, (il try 2 solve it)
bcuz maybe ur bz,

after encryting , how can i turn it back to normal? if im going to get it from the database,


again THX! A LOT! sir!
Reply With Quote  
Join Date: Nov 2007
Location: ★ Jogja ★
Posts: 2,473
Reputation: Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light 
Rep Power: 9
Solved Threads: 215
Jx_Man's Avatar
Jx_Man Jx_Man is offline Offline
Nearly a Posting Maven

Re: How to Make Encrytion on Database? using VB

  #9  
Feb 7th, 2008
you see the program have a reading encryption code. it working if label encryption changed. see the code when label encryption result change (label1 in program).
when you want to show data again after save, use the code to reading encryption after load data then show it to user.

Encrypt data in database -> load data -> encryption reading -> show data after encrypt to normal.

Ok. hope this helps.
all for the best friend.

NB : don't forget to mark this solved
Last edited by Jx_Man : Feb 7th, 2008 at 1:32 pm.
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
Reply With Quote  
Join Date: Jul 2007
Posts: 100
Reputation: hawisme000 is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 2
hawisme000's Avatar
hawisme000 hawisme000 is offline Offline
Junior Poster

Re: How to Make Encrytion on Database? using VB

  #10  
Feb 8th, 2008
ok sir! thx again for everything ,
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb Visual Basic 4 / 5 / 6 Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Other Threads in the Visual Basic 4 / 5 / 6 Forum

All times are GMT -4. The time now is 3:14 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC