re-ordering rows/records in datagrid

[Patrick.O.Ige]

I would like to re-order my rows in the datagrid.
So on each row i want to have up and down images to go up one row or down
Whats the easiest way to tackle this?
Any sample guides are welcome.

 

[Remy]

Its pretty much built into the new ASP.NET 2.0 GridView.
http://www.asp.net/QuickStart/aspnet/samples/data/GridViewSorting_vb.aspx
http://asp.net/Tutorials/quickstart.aspx

for normal asp, its not complicated either:
http://msdn.microsoft.com/library/d...ml/vbtskaddingsortingtodatagridwebcontrol.asp

Have fun

Remy

 

[Patrick.O.Ige]

Thx for the reply
Remy what i want is to Move up level or down one level between rows
I don't want to do sorting really but want to re-arrange the rows
accordingly
This post is very similar of what i want to do
http://aspadvice.com/lists/message.aspx?MessageID=97710

 

[Guest]

Hi Patrick,

I put this demo quickly to answer your question:
http://www.webswapp.com/codesamples/aspnet20/datatable_rowsreorder_ondatagrid/

 

[Rote Rote]

Thanks Phillip for the email and the hint and the approach
Will i be able to bind it to a table with this structure
id doc rank
1 a.doc 1
2 b.doc 2
3 c.doc 3
4 d.oc 4

What i really want to achieve is to be able to rank the doc files on
that table from 1-4 with no duplicates.
Would it be easy to retrieve my data from the database table to achieve
the same result?
Patrick

 

[Guest]

Hello Patrick,

Sorting based on a Rank field might eliminate the issue you encountered to
save the datatable. Try this demo:

http://www.webswapp.com/codesamples/aspnet20/datatable_rowsreorder_ondatagrid/sort_on_rank.aspx
--
HTH,
Phillip Williams
http://www.societopia.net
http://www.webswapp.com

Phillip i have taken time to look at your interesting sample
and i could move up and down the row using values from a table in the DB but
i need to update changes to the table
I hooked it up with a submit button but it doesn't change the values
any ideas.. sleeping.

void Bind()
{
if (Session["FilesOrder"] == null)
{
dt = new DataTable("FilesOrder");
const string strSQL = "select * from FilesOrder";
SqlCommand myCommand = new SqlCommand(strSQL, myConnection);
SqlDataAdapter myAdapter = new SqlDataAdapter(myCommand);
myConnection.Open();
myAdapter.Fill(dt);
Session["FilesOrder"] = dt;
}
else
{
dt = (DataTable)Session["FilesOrder"];
}

Thanks Phillip for the email and the hint and the approach
Will i be able to bind it to a table with this structure
id doc rank
1 a.doc 1
2 b.doc 2
3 c.doc 3
4 d.oc 4

What i really want to achieve is to be able to rank the doc files on
that table from 1-4 with no duplicates.
Would it be easy to retrieve my data from the database table to achieve
the same result?
Patrick

 

[Patrick.O.Ige]

Thanks alot Phillip
I would try that out

Hello Patrick,

Sorting based on a Rank field might eliminate the issue you encountered to
save the datatable. Try this demo:

http://www.webswapp.com/codesamples/aspnet20/datatable_rowsreorder_ondatagrid/sort_on_rank.aspx
--
HTH,
Phillip Williams
http://www.societopia.net
http://www.webswapp.com

Phillip i have taken time to look at your interesting sample
and i could move up and down the row using values from a table in the DB
but
i need to update changes to the table
I hooked it up with a submit button but it doesn't change the values
any ideas.. sleeping.

void Bind()
{
if (Session["FilesOrder"] == null)
{
dt = new DataTable("FilesOrder");
const string strSQL = "select * from FilesOrder";
SqlCommand myCommand = new SqlCommand(strSQL, myConnection);
SqlDataAdapter myAdapter = new SqlDataAdapter(myCommand);
myConnection.Open();
myAdapter.Fill(dt);
Session["FilesOrder"] = dt;
}
else
{
dt = (DataTable)Session["FilesOrder"];
}

Thanks Phillip for the email and the hint and the approach
Will i be able to bind it to a table with this structure
id doc rank
1 a.doc 1
2 b.doc 2
3 c.doc 3
4 d.oc 4

What i really want to achieve is to be able to rank the doc files on
that table from 1-4 with no duplicates.
Would it be easy to retrieve my data from the database table to achieve
the same result?
Patrick