|
Hi.
I want to insert a record in a table and then get it's ID(which is an autonumber field) to use it as a reference in another table. What is the best approach?
Thanks.
|
|
|
|
|
blackjack2150 wrote: I want to insert a record in a table and then get it's ID(which is an autonumber field) to use it as a reference in another table. What is the best approach?
What is the database?
|
|
|
|
|
If this is a MS-SQL database Ive gotten this to work by using a stored procedure and returning @@IDENTITY from the stored proc.
The only other way I know of is to timestamp the record at the time of writing and return the record with that timestamp(or some other form of identifying field) in a query statment.
|
|
|
|
|
Let's continue on the database forum.
This topic can now be deleted by the admin.
Thanks.
|
|
|
|
|
blackjack2150 wrote: This topic can now be deleted by the admin.
Why should he? The admin is busy enough with other things.
|
|
|
|
|
Dear All,
Please let meknow how can I encrypt a string and store the encrypted string in database, then reterive the encrypted string and decrypt it.
thanx
|
|
|
|
|
Depends on how strong the encryption must be.
The easiest and most fun way is XOR encryption. I'm sure you'll find plenty of information and examples on the web.
|
|
|
|
|
|
|
|
plz try this article:
http://www.codeproject.com/useritems/Encrypt_an_string.asp
> use RC2 algoritm
First and the Foremost: FIGHT TO WIN
About Me
|
|
|
|
|
I usually develop my own encryption methods, two methods to encode and decode using very basic ways, like getting the integer value of the string, play with it, store it. Do the opposite when retrieving it.
Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)
|
|
|
|
|
The biggest problem with crypto is keeping the secret secure.
There are plenty of libraries available that will do Rijndael/AES. Including some stuff that ships with .Net
I've used the .net libraries a few times in the past, although if i could find a properly peer reviewed open source verison i'd be much happier using it.
XOR should only be used for the very lightest crypto requirements, it's very oldhat and can be easily broken.
I suppose it depends what you want to do. XOR will hide your girlfriend's phone numbers from your wife but it wouldn't hold up very long against the forces of the RIAA trying to prove that you once looked at a copy of that DVD key.
Russell
|
|
|
|
|
How can I disable dots (as show in below given link) from studio.net2005 editor? these dots are displayed instead of space.
thnkx in advance
http://www.geocities.com/lxcitesplanet/dotsinvseditor.jpg
First and the Foremost: FIGHT TO WIN
About Me
|
|
|
|
|
I've never seen that before. Perhaps the Visual Studio will be suitable for this question.
|
|
|
|
|
Hari Om Prakash Sharma wrote: disable dots
do you mean replace??
yourString.Replace('.','');
Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)
|
|
|
|
|
Edit/Advanced/View White Space
|
|
|
|
|
Thanks a lot!!!
First and the Foremost: FIGHT TO WIN
About Me
|
|
|
|
|
DOH .. How the hell did you understand his question
Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)
|
|
|
|
|
I guess by looking at the picture!
|
|
|
|
|
Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)
|
|
|
|
|
good editors have the option of showing characters that normally are hidden,
such as space, tab, carriage return. It exists in Word, in Visual, etc.
|
|
|
|
|
hello guys..my program is about drawing some shapes like (lines ,polygons..etc)my nightmare is after drawing the shapes i wanna to save them as atext which contains the (start point , end point , color ,..etc)
iam using V.S 2003...i will apprecaite any help .
Regards ;
|
|
|
|
|
mr jets wrote: i wanna to save them as atext which contains the (start point , end point , color ,..etc)
The first step is to define the format of the text. I presume this will be a text file that will have to be read back in at some point.
|
|
|
|
|
yah bro..thats right i wanna to save my drawing as text file..but iam stuck..!
|
|
|
|