I created a ASP.NET page using C# and I'm using two components to access a
MS-Access database, which are:
- oleDbConnection
- oleDataAdapter
The MS-Access database is in the correct directory, IIS has permission to
write. Everything seems ok, but IIS says that it can't open the file because
there is someone else using it exclusively (impossible, I'm using a stand
alone computer and I closed everything) or I need permission to open the
file, which is strange too.
I also would like to know if the way I'm trying to save date/time to the
database is correct.
--------- code ---------
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.RequiredFieldValidator
RequiredFieldValidator1;
protected System.Web.UI.WebControls.TextBox nome;
protected System.Web.UI.WebControls.RequiredFieldValidator
RequiredFieldValidator2;
protected System.Web.UI.WebControls.TextBox msg;
protected System.Web.UI.WebControls.Label Label2;
protected System.Data.OleDb.OleDbConnection oleDbConnection1;
protected System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1;
protected System.Data.OleDb.OleDbCommand oleDbSelectCommand1;
protected System.Data.OleDb.OleDbCommand oleDbInsertCommand1;
protected System.Web.UI.WebControls.Label Erro;
protected System.Web.UI.WebControls.Button Button1;
private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
if (IsPostBack)
{
try {
oleDbConnection1.Open();
oleDbDataAdapter1.InsertCommand.CommandText =
"INSERT INTO [msg log] "+
"(hora, msg, nome) "+
"VALUES ("+
"'"+DateTime.Now.ToString()+"', "+
"'"+nome.Text+"', "+
"'"+msg.Text+"')";
oleDbDataAdapter1.InsertCommand.ExecuteNonQuery();
oleDbConnection1.Close();
nome.Text = "";
msg.Text = "";
Erro.Visible = false;
}
catch (System.Data.OleDb.OleDbException exception)
{
Erro.Visible = true;
Erro.Text = "Erro no servidor: " +
exception.ToString();
}
}
}
--------- code ---------
Thanks.