Urgent Help Needed in our Project

Question

1.00/5 (5 votes)

See more:

Hey hi . . i am trying to run this part of code but problem is that it is not updating my access database

C#

con1.Open();
               
System.Data.OleDb.OleDbCommand cmd1 = new System.Data.OleDb.OleDbCommand(command, con1);
                
cmd1.ExecuteNonQuery();


System.Data.OleDb.OleDbCommand cmd2 = new System.Data.OleDb.OleDbCommand("UPDATE * from " + table_name + " order by Name", con1);

cmd2.ExecuteNonQuery();

con1.Close();

We are reading .mdb file and trying to sort it . . but it is not sorting :(

Posted 17-Apr-12 7:13am

Injectors

Updated 17-Apr-12 7:24am

Mehdi Gholam

v2

Add a Solution

Comments

Vivek Krishnamurthy 17-Apr-12 13:26pm

Make sure when you post a question,
1. headline should reflect what the problem is.
2. Do mention urgent, it is considered rude. This reduces chances of your question being answered.

[no name] 17-Apr-12 14:17pm

Your whole premise is ridiculous. There is absolutely no need at all to sort data in a database table. You sort the data when it's queried.

5 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Answer 1 · 2012-04-17T07:25:00

Solution 1

You should be using the following :

C#

System.Data.OleDb.OleDbCommand cmd2 = new System.Data.OleDb.OleDbCommand("SELECT * from " + table_name + " order by Name", con1);

Posted 17-Apr-12 7:25am

Mehdi Gholam

Comments

Injectors 17-Apr-12 13:32pm

Nope !! its the same code line we are using . .

Mehdi Gholam 17-Apr-12 13:39pm

If you look closely you will see that it is not what is in your question!

Injectors 17-Apr-12 13:44pm

Ohhh ya . . but i did changes .. problem is that it is not saving tht file !

Vivek Krishnamurthy · Answer 2 · 2012-04-17T07:30:00

Solution 2

Refer to the following link on using Update statement with access.
UPDATE Statement (Microsoft Access SQL)[^]

also, looking at your update statement there is no set clause or where clause, what is it updating ?

Posted 17-Apr-12 7:30am

Vivek Krishnamurthy

Comments

Injectors 17-Apr-12 13:33pm

Yes thr is no Where clause . . we just want to sort it according to Name u say . . .

El_Codero · Answer 3 · 2012-04-17T07:35:00

Solution 3

Don't know what command you're passing in cmd1 (it also doesn't matter in this case) but using the ORDER BY Statement is only allowed in association with SELECT command.

Using

SQL

"SELECT * from " + table_name + " ORDER BY Name", con1

should work for you.

Please take care of capitalization when using SQL Commands, it's clearly readable then.

Regards

Posted 17-Apr-12 7:35am

El_Codero

Comments

Injectors 17-Apr-12 13:40pm

Yeahhh . . everything is working fine while debugging .. but main problem is that it is not saving that file !! It is sorting but not saving i guess

El_Codero 17-Apr-12 13:45pm

As Mehdi Gholam also noticed you're using wrong association between commands (postet at same time), you'll need a subquery like this:
UPDATE table SET Name='something' WHERE Name in (SELECT * FROM Table WHERE Name='test' ORDER BY Name DESC);

Injectors 17-Apr-12 13:50pm

ya i did that changes .. code is running successfully but it is not saving !

El_Codero 17-Apr-12 13:54pm

you're using above UPDATE example now?if it's not saving I think you have some error in query command. please try to write the command as easy as it could be to make suke UPDATE command works, then add other statements like ORDER BY. we don't have a view into your database structure.

Injectors 17-Apr-12 14:13pm

no m using select command . .

scottgp 17-Apr-12 14:18pm

If you're expecting to store the underlying data in a sorted fashion, I don't think it will (in Access). You just need to be sure to specify the sort order when querying it back out.

El_Codero 17-Apr-12 14:21pm

as the UPDATE Statement implies, you need it to update existing record in your database (in association with SET), in addition you can specify WHAT exactly should be updated (when using SELECT Command). Please have a look at UPDATE-Syntax: http://www.w3schools.com/sql/sql_update.asp
Agree to scottgp, you should sort the output (view) of your command.Regards

phil.o · Answer 4 · 2012-04-17T09:32:00

Solution 4

Sorting a database table is completely useless.

You sort data when you query it ; there is absolutely no reason to sort the table itself.
Let the data engine handle the database, and focus on your requirements.

Posted 17-Apr-12 9:32am

phil.o

Mohammad A Rahman · Answer 5 · 2012-04-17T17:28:00

Solution 5

Please pick one of the link from Maintaining sort order of database table rows[^]

Hope it helps :)

Posted 17-Apr-12 17:28pm

Mohammad A Rahman

Urgent Help Needed in our Project

5 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0

Urgent Help Needed in our Project

5 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0

Existing Members

...or Join us