|
Oh,I got the point now.I can't find the solution too. I'd be so appreciate if you tell me when you find it.
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
|
I get an exception that says syntax error in UPDATE query:
UPDATE Login SET Password='blomma' WHERE User='elev2'
Login is the table, Password and User is columns
So what is wrong?????
Rickard Andersson@Suza Computing
C# and C++ programmer from SWEDEN!
UIN: 50302279
E-Mail: nikado@pc.nu
Speciality: I love C#, ASP.NET and C++!
|
|
|
|
|
Are you sure you choose correct database name that Login table exist in it?Andalso both those column are string(varchar,nvarchar,Text..) column?
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
|
This is the code:
public void OnSavePassword(object sender, System.EventArgs e)
{
if(EditPassword.Text == "")
{
ERROR.Text = "Du har inte skrivit in ett lösenord!";
return;
}
string connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("/mp219.mdb");
OleDbConnection connection = new OleDbConnection(connectString);
try
{
StringBuilder commandString = new StringBuilder();
commandString.Append("UPDATE Login SET Password='");
commandString.Append(EditPassword.Text);
commandString.Append("' WHERE User='");
commandString.Append(Context.User.Identity.Name);
commandString.Append("'");
Response.Write(commandString.ToString());
OleDbCommand cmd = new OleDbCommand(commandString.ToString(), connection);
connection.Open();
cmd.ExecuteNonQuery();
}
catch(Exception ex)
{
Response.Write("<br><br>");
Response.Write(ex.ToString());
ERROR.Text = "Ett undantag kastades, försök igen!";
return;
}
finally
{
connection.Close();
}
SUCCESS.Text = "Lösenordet är ändrat!";
}
Rickard Andersson@Suza Computing
C# and C++ programmer from SWEDEN!
UIN: 50302279
E-Mail: nikado@pc.nu
Speciality: I love C#, ASP.NET and C++!
|
|
|
|
|
Well,I can't see any problem.When you debug your program,does your path,connectionstring and query string ok?
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
|
it's an ASP.NET application... so how to debug?
It's weird I know!
Rickard Andersson@Suza Computing
C# and C++ programmer from SWEDEN!
UIN: 50302279
E-Mail: nikado@pc.nu
Speciality: I love C#, ASP.NET and C++!
|
|
|
|
|
Rickard Andersson wrote:
so how to debug?
Easily.Just insert breakpoint and press F5.Also enable debugging in your project setting.Thats it.
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
|
Damn I forgot to tell ya one thing!
I use Dreamweaver MX and WebMatrix little webserver to try my ASP.NET applications!
I can't get IIS to run for some reason, and everytime I say this in any forum it's like in a western movie when a big bad cowboy enter a saloon and all people in there get quiet and just stare at him....
I will try re-install IIS and then do everything slower and read all pop-ups a little bit more better!
Good night!
Rickard Andersson@Suza Computing
C# and C++ programmer from SWEDEN!
UIN: 50302279
E-Mail: nikado@pc.nu
Speciality: I love C#, ASP.NET and C++!
|
|
|
|
|
So,be sure your problem is for your string or path.You will find it out after debug,but until the time you can debug your application,you can put a label on your form,and set the text of it,your string query and path before you do ExecuteNonQuery.Then you can see if it is ok or not.
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
|
I will keep trying find out what the heck is wrong with the god damn query!
grrr... this relly pisses me off!!
Rickard Andersson@Suza Computing
C# and C++ programmer from SWEDEN!
UIN: 50302279
E-Mail: nikado@pc.nu
Speciality: I love C#, ASP.NET and C++!
|
|
|
|
|
*Gets quiet and stares*
You will now find yourself in a wonderous, magical place, filled with talking gnomes, mythical squirrels, and, almost as an afterthought, your bookmarks
-Shog9 teaching Mel Feik how to bookmark
|
|
|
|
|
Are you sure that Password and User aren't both keywords?
Maybe try putting [] around those words and retrying the query.
Cheers,
Simon
"Sign up for a chance to be among the first to experience the wrath of the gods.", Microsoft's home page (24/06/2002)
|
|
|
|
|
Keywords... hm.. you mean 'Password' and 'User' could be reserved?
but when I think back they can't... because I read from the database when the user is trying to log on to a protected webpage (I store username and password in the database).
So.... Daaah!!!
Rickard Andersson@Suza Computing
C# and C++ programmer from SWEDEN!
UIN: 50302279
E-Mail: nikado@pc.nu
Speciality: I love C#, ASP.NET and C++!
|
|
|
|
|
SimonS wrote:
Maybe try putting [] around those words and retrying the query
IT WORKS!!!!!!!!!!!!
Thank you SO MUCH!!!
Rickard Andersson@Suza Computing
C# and C++ programmer from SWEDEN!
UIN: 50302279
E-Mail: nikado@pc.nu
Speciality: I love C#, ASP.NET and C++!
|
|
|
|
|
Sure, glad it helped.
In future, swop the roses for pics of AnnaK.
Cheers,
Simon
"Sign up for a chance to be among the first to experience the wrath of the gods.", Microsoft's home page (24/06/2002)
|
|
|
|
|
Hi Rick,
The way Access JET database gives error messages can be at times confusing. When you misspell parameters it will say as
'Too few parameters. Expected x'
where x can be no. of parameters misspelt.
Have a look at the following to ascertain the type of error and whether the file/directory where the MDB is located is also writeable(this if fails gives the message 'Operation must use an updateable query')
http://www.brinkster.com/GeneralDatabaseGuide.asp
http://www.brinkster.com/PremiumDatabaseGuide.asp
The above are actually a hosting providers' FAQ. However you can filter out those stuff related to keeping MDB over there and take the content that befits your needs and concern.
I have an article called WebSQL for ASP.NET. Perhaps you can download that and put in your query over there and have a preview of the same. Either you can view the WebSQL for ASP.NET Article from the 'articles from this author' link or you can follow this link to WebSQL sourcecode.
http://www15.brinkster.com/deepaknet/sourcescripts/websqlnet.htm
It is just about 4 kb and has an ASPx page and a codebehind .cs With WebMatrix, I think you may need to do some CTRL+C and CTRL+V from .cs to .aspx block so that WebMatrix server JITs the code at runtime, rather than depending on the compiled bin folder which WebMatrix might not support.
Hope this solves your problem.
deepak
|
|
|
|
|
What database are you using? "User" is reserved keyword in SQL Server and may not be used without brackets ([User]). Good practice with SQL Server: use brackets with all table/column names.
Vagif Abilov
MCP (Visual C++)
Oslo, Norway
Hex is for sissies. Real men use binary. And the most hardcore types use only zeros - uppercase zeros and lowercase zeros.
Tomasz Sowinski
|
|
|
|
|
I'm using Access 2000.
But it's cool man, I've solved the problem, or SimonS solved the problem!
Rickard Andersson@Suza Computing
C# and C++ programmer from SWEDEN!
UIN: 50302279
E-Mail: nikado@pc.nu
Speciality: I love C#, ASP.NET and C++!
|
|
|
|
|
There's CDaoWorkspace::CompactDatabase() for MFC but is there a way to do it with OLE DB/ATL ?
Thanks!
---------------
Concentrating on Ideas
http://www.edovia.com
|
|
|
|
|
You can use JRO for this. Create an instanse of "JRO.JetEngine " and call its function CompactDatabase (look in MSDN for more information on this function)
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
|
|
|
|
|
I know how to create a winform with a DataGrid which enables the user to change values in an Access DB, but now this DB is stored on a server, and I don't know how to create an OleDbConnection to this DB (in C#) because you can't use URLs in the constructor Can someone please help me out?
Thanks, Nicolas
|
|
|
|
|
Isn't it possible to do it as web service?
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
|
Yes, I'm sorry, but I found a good article on this subject in the VS.Net Walktroughs ("Creating a distributed application"). It uses SQL Server, but that's not really a big prob .
THX, Nicolas
|
|
|
|
|
Is it possible to include spaces when you create a table
sSql="CREATE TABLE Graph (Date TEXT, Hour NUMBER,Temp_ºC NUMBER)";
For instance: Temp ºC instead of Temp_ºC
Thanks
|
|
|
|
|
José Luis Sogorb wrote:
sSql="CREATE TABLE Graph (Date TEXT, Hour NUMBER,Temp_ºC NUMBER)";
For instance: Temp ºC instead of Temp_ºC
Yes, enclose the "invalid" table name with [ and ] e.g.
sSql="CREATE TABLE Graph (Date TEXT, Hour NUMBER,[Temp ºC] NUMBER)";
Just also remember when you reference that table to put the [ and ] in. (You can use this technique for reserved table names as well, e.g. Order must be used as [Order].
Paul Watson Bluegrass Cape Town, South Africa
Ray Cassick wrote:
Well I am not female, not gay and I am not Paul Watson
|
|
|
|