C#

microuser_2000 wrote:

i wanna take the value of the indx after it has been inserted and to save it to use it in another statment ...

Judah Himango wrote:

For #2, it's common to keep user names in plain text in the database. However, passwords do not need to be kept in plain text on the server. For this, you should simply encrypt the plain text using MD5 (again, look in System.Security.Cryptography) or another encryption algorithms to encrypt the password, then save the encrypted password to the database. When a user logs in, encrypt the password he typed, and compare it against the encrypted version in the database. If they match, the passwords match.

using System.Security.Cryptography;
using System.Text;

...

string password = "super secret password";
byte[] passwordBytes = UnicodeEncoding.UTF8.GetBytes(password);
MD5 md5 = MD5CryptoServiceProvider.Create();
byte[] hashedPassword = md5.ComputeHash(passwordBytes); // <-- this is what you store in the database.

The Apocalyptic Teacup wrote:

It looks as though Office 2003 includes the Primary Interop Assemblies, whereas Office XP does not

Judah Himango wrote:

A quick google search reveals you can download[^] the Office XP PIAs from Microsoft.

using System.Reflection;
using Excel = Microsoft.Office.Interop.Excel

using System.Reflection;

Process.Start("Setup.exe", "/q");

File.Copy("MyOldPath.exe", "MyNewPath.exe", true);

Regards