Hi!

I want to make a logfile for my login-page (login-page allready works). I
use a MDB file which contains a table for each month. In the tables ar the
fields: Id, Datum, Uhrzeit, EMailAdresse and Kundennummer.

I tried to create the code, but I didn't understand some things. I marked
them with "???". And I can't find the end for the sql-command, this means
the sending of the sql-command.

Here is my code:

***
void Page_Load(Object sender, System.EventArgs e) {

// Aktuelle Uhrzeit in dtTemp speichern:
DateTime dtTemp = DateTime.get_Now();

// Benötigte Daten:
// """"""""""""""""
// Monat: month
// Datum: date
// Uhrzeit: time
// EMailAdresse: email
// Kundennummer: kdnr
String month = dtTemp.ToString("MMMM");
String date = dtTemp.ToString("yyyy-mm-dd");
String time = dtTemp.ToString("HH:mm:ss");
String email = "info (AT) businessname (DOT) com";
String kdnr = "20001";

// Gesammelte Daten am Bildschirm ausgeben:
get_Response().Write(month +"<br>");
get_Response().Write(date +"<br>");
get_Response().Write(time +"<br>");
get_Response().Write(email +"<br>");
get_Response().Write(kdnr +"<br>");

// Die Zugriffsart und die Datenbank festlegen:
String myCon = "Provider=Microsoft.Jet.OLEDB.4.0;";
myCon += "Data Source=C:/Inetpub/wwwroot/test/cjsTest_3/db1.mdb;";

// ???
OleDbConnection dbcon = new OleDbConnection(myCon);

// ???
dbcon.Open();

// Den SQL-Befehl erzeugen:
String sqlCommand = "INSERT INTO " +month +" (Datum, Uhrzeit,
EMailAdresse, Kundennummer) ";
sqlCommand += "VALUES (" +date +", " +time +", " + email +", " +kdnr
+")";

// sqlCommand am Bildschirm ausgeben:
get_Response().Write(sqlCommand);

// ???
OleDbCommand dbcom = new OleDbCommand(sqlCommand,dbcon);

//
// ???
//

//
dbcon.Close();

}
***

Can anyone help me?

Thanks and greetings,
christian.

I could resolve the problem!
Now I have only to do some tuning...

Greetings,
christian.

Hi Lars-Inge!

I know, but there is many to do, if the server should run clearly. The
SBS2003 is also the reason, why I want to change my PHP-Sites to
ASP.NET!

This means I should use my Access-Database-Files, oder I should use
MS-SQL?

Greetings,
christian.