C# Discussion Boards - CodeProject

10-May-07 0:02

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.

Colin Angus Mackay10-May-07 0:08

Colin Angus Mackay

10-May-07 0:08

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?

Upcoming events:
* Glasgow: SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services...

Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton

My website

tcss10-May-07 0:26

tcss

10-May-07 0:26

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.

blackjack215010-May-07 0:27

10-May-07 0:27

Let's continue on the database forum.
This topic can now be deleted by the admin.
Thanks.

Colin Angus Mackay10-May-07 2:02

Colin Angus Mackay

10-May-07 2:02

blackjack2150 wrote:
This topic can now be deleted by the admin.

Why should he? The admin is busy enough with other things.

Cryptography

Mr Perfect9-May-07 23:49

Mr Perfect

9-May-07 23:49

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

blackjack215010-May-07 0:01

10-May-07 0:01

Depends on how strong the encryption must be.
The easiest and most fun Smile | :)

way is XOR encryption. I'm sure you'll find plenty of information and examples on the web.

Mr Perfect10-May-07 0:10

Mr Perfect

10-May-07 0:10

Just give me a sample

blackjack215010-May-07 0:33

10-May-07 0:33

Here's you example. A very nice one, too.

http://www.eggheadcafe.com/tutorials/aspnet/8b53894c-a889-4914-8c46-122980cc44ae/simple-xor-encryption.aspx[^]

Mr Perfect10-May-07 0:49

Mr Perfect

10-May-07 0:49

Thanx for the sample

Hari Om Prakash Sharma10-May-07 0:03

Hari Om Prakash Sharma

10-May-07 0:03

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

Muammar©10-May-07 0:06

Muammar©

10-May-07 0:06

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

How can I disable dots from studio.net2005 editor

Russell Jones10-May-07 1:09

Russell Jones

10-May-07 1:09

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

Hari Om Prakash Sharma9-May-07 23:48

Hari Om Prakash Sharma

9-May-07 23:48

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

Re: How can I disable dots from studio.net2005 editor

blackjack21509-May-07 23:58