CODEWITHSUNDEEP
c#ms-access-2007
Naga Raj
Naga Raj

Reputation: 105

Sort Data by date in Asc in Access in c#

I want fetch data based on date in ascending. The code is fetching data but in wrong format e.g.:

14/02/2014
16/01/2014
17/04/2013

i.e dates is sort based on "dd" only month and year is not considered the code is below

string constr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Auto_Finance.accdb;Persist Security Info=False;";
OleDbConnection con = new OleDbConnection(constr);
con.Open();
string sql=@"select p.PName,p.hpno,c.Credit,C.Debit,c.Dates from Party_Det p inner join cd c on p.Loanno=c.Loanno order by c.Dates asc";
OleDbCommand cmd = new OleDbCommand(sql, con);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
con.Close();

But I want result like below 

17/04/2013
16/01/2014
14/02/2014

I am using c# as front end and Microsoft Access as front end.

Upvotes: 2

Views: 1856

Answers (2)

user2794419
user2794419

Reputation: 11

your query is

@"select p.PName,p.hpno,c.Credit,C.Debit,c.Dates from Party_Det p inner join cd c on p.Loanno=c.Loanno order by c.Dates desc"

as Gordon said
replace "c.Dates desc" by "c.Dates ASC"

Upvotes: 1

shA.t
shA.t

Reputation: 16968

Try this:

string sql = @"select p.PName,p.hpno,c.Credit,C.Debit,c.Dates from Party_Det p inner join cd c on p.Loanno=c.Loanno order by c.Dates desc";

or this:

string sql = @"select p.PName,p.hpno,c.Credit,C.Debit,c.Dates from Party_Det p inner join cd c on p.Loanno=c.Loanno";
...
dataGridView1.DataSource = dt;
dataGridView1.Sort('Dates', SortDirection.Descending);

Upvotes: 0

Related Questions