I want to update some record in access data base, but the update command is
not updating the table...
Insertiion is working fine.. the code is:
com = new OleDbCommand("UPDATE ServerAuthorisation SET Permissions=@permission WHERE UserName=@user_name", conn);
conn.Open();
if (conn.State == ConnectionState.Open)
{
com.Parameters.Add("@user_name", OleDbType.Char, 100);
com.Parameters.Add("@permission", OleDbType.Char, 100);
com.Parameters["@user_name"].Value = user_name;
com.Parameters["@permission"].Value = permission;
}
try
{
com.ExecuteNonQuery();
conn.Close();
}
catch (OleDbException exe)
{
Console.WriteLine(exe.Message);
Console.ReadLine();
}
No exception is raised but the data base is not being updated... plz help...
