Click here to Skip to main content
15,925,781 members
Home / Discussions / C#
   

C#

 
GeneralRe: Readability of the code Pin
Vitaliy Tsvayer16-Aug-06 18:56
Vitaliy Tsvayer16-Aug-06 18:56 
GeneralRe: Readability of the code Pin
Stefan Troschuetz16-Aug-06 22:15
Stefan Troschuetz16-Aug-06 22:15 
AnswerRe: Readability of the code Pin
Filip van der Meeren16-Aug-06 6:23
Filip van der Meeren16-Aug-06 6:23 
GeneralRe: Readability of the code Pin
Vitaliy Tsvayer16-Aug-06 18:59
Vitaliy Tsvayer16-Aug-06 18:59 
Questionadding values on XML file Pin
Mohammad Daba'an16-Aug-06 3:12
Mohammad Daba'an16-Aug-06 3:12 
AnswerRe: adding values on XML file Pin
Guffa16-Aug-06 3:26
Guffa16-Aug-06 3:26 
QuestionPasswordDerivedBytes How To? Pin
Gywox16-Aug-06 2:58
Gywox16-Aug-06 2:58 
QuestionUpdate statement not executing properly with Access 2003 Pin
Arun Hegde16-Aug-06 2:50
Arun Hegde16-Aug-06 2:50 
Dear Sir,
I am working on a ASP.NET application, where i am using OLEdbConnection to connect to the Access 2003.
My objective of writing this code is to be able to change the existing password

Here :
T_EMP_PERSONAL is the table name

change_pwd.Text and pwd_txt.Text are the textboxes

Following is the code


private void ImageButton1_Click(object sender, System.Web.UI.ImageClickEventArgs e)


{
try
{
string qry;


qry="Update T_EMP_PERSONAL set PASSWORD='"+change_pwd.Text+"' where PASSWORD='"+pwd_txt.Text+"'";

Label1.Text=qry;


con.Open();
OleDbCommand cmd=new OleDbCommand(qry,con);
cmd.ExecuteNonQuery();
Response.Write("Done");
con.Close();
}
catch(Exception ex)
{
Response.Write(ex.Message);
}
OUTPUT
Syntax error in Update statement.

Where as, when i tried the same query in Sql server 2003 it executes succesfully

so could u pl help me out with this

thanks 4 ur kind support

arun
AnswerRe: Update statement not executing properly with Access 2003 Pin
led mike16-Aug-06 5:35
led mike16-Aug-06 5:35 
QuestionCrystal Reports in C# 2005 ? Pin
M Riaz Bashir16-Aug-06 2:15
M Riaz Bashir16-Aug-06 2:15 
Questionprint screen in C#.net Pin
Rohit Dev16-Aug-06 2:13
Rohit Dev16-Aug-06 2:13 
AnswerRe: print screen in C#.net Pin
Robert Rohde16-Aug-06 2:41
Robert Rohde16-Aug-06 2:41 
QuestionStupid Question - How Do I Find The Drive Letter My Program Was Called From? Pin
Ridlaw16-Aug-06 2:05
Ridlaw16-Aug-06 2:05 
AnswerRe: Stupid Question - How Do I Find The Drive Letter My Program Was Called From? Pin
Stefan Troschuetz16-Aug-06 2:19
Stefan Troschuetz16-Aug-06 2:19 
AnswerRe: Stupid Question - How Do I Find The Drive Letter My Program Was Called From? Pin
Christian Graus16-Aug-06 2:21
protectorChristian Graus16-Aug-06 2:21 
QuestionShowing Chinese and Japanese font on .net window form using c# Pin
vasantk16-Aug-06 2:04
vasantk16-Aug-06 2:04 
QuestionError in: Insert Date Value into Access Database Pin
M Riaz Bashir16-Aug-06 2:04
M Riaz Bashir16-Aug-06 2:04 
AnswerRe: Error in: Insert Date Value into Access Database Pin
Guffa16-Aug-06 2:34
Guffa16-Aug-06 2:34 
Questionhi Pin
pranu_1316-Aug-06 1:41
pranu_1316-Aug-06 1:41 
AnswerRe: hi Pin
Robert Rohde16-Aug-06 2:43
Robert Rohde16-Aug-06 2:43 
QuestionImplementing a CallBack COM Interface in C# Pin
James R. Twine16-Aug-06 1:12
James R. Twine16-Aug-06 1:12 
QuestionSQL DataAdapter disabled in toolbox?? Pin
raviroyx16-Aug-06 1:07
raviroyx16-Aug-06 1:07 
QuestionComboBox in a ListBox Pin
syntaxed16-Aug-06 0:53
syntaxed16-Aug-06 0:53 
AnswerRe: ComboBox in a ListBox Pin
stancrm16-Aug-06 1:25
stancrm16-Aug-06 1:25 
QuestionHow to reopen the existing opened File [modified] Pin
engsrini16-Aug-06 0:12
engsrini16-Aug-06 0:12 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.