Datalist refresh

[Simon Rigby]

Hi folks,

This seems to have been asked quite a bit but the solutions either dont
pertain to my case or the only response is to supply code. So here's
the question and the code is at the bottom.

I have a datalist which is displaying images in a gallery. Each image
has a pair of buttons to promote or demote the image in the list.

A little explanation about the code. The back end database contains two
tables Image and Gallery. Image contains a path to the image, an unique
ID a foreign key to the Gallery table to determine gallery membership
and an integer sequence number to determine the order it appears within
a gallery.

GalleryQuery is a class with a number of static methods that perform
operation on the backend sql server database. I'll refer to it as GQ in
the following for brevity

GQ.GetMinimumSe quenceNumber gets the lowest sequence number for a given
gallery

GQ.GetMaximumSe quenceNumber gets the highest sequence number for a
given gallery

GQ.GetSequenceN umber gets the sequence number for a specific image

GQ.PromoteImage swaps the sequence number of the chosen image with the
one above.

GQ.DemoteImage swaps the sequence number of the chosen image with the
one below

All of the above works as expected and if I check the backend database
after clicking a promote or demote button the relevent switch has
occured. Reviewing the page shows the switch has occured, however I
can't find a way of making the refresh occur without doing a
response.redire ct or server.transer back to the same page.
Unfortunately there are other controls on the page that lose their
state as a result.

I'm assuming that some thing is required at the points marked // ??? in
the code.

Any help greatly appreciated.

protected void CommandFunction (object source, DataListCommand EventArgs
e) {
int gallery = int.Parse(lstGa llery.SelectedV alue);
int min = GalleryQuery.Ge tMinimumSequenc eNumber(gallery );
int max = GalleryQuery.Ge tMaximumSequenc eNumber(gallery );
int current =
GalleryQuery.Ge tSequenceNumber (int.Parse(e.Co mmandArgument.T oString()),
gallery);
int currentImage = int.Parse(e.Com mandArgument.To String());

if (e.CommandName == "MoveUp") {
if (current min) {
GalleryQuery.Pr omoteImage(curr entImage, gallery);
// ???
}
} else if (e.CommandName == "MoveDown") {
if (current < max) {
GalleryQuery.De moteImage(curre ntImage, gallery);
// ???
}
}
}

[bruce barker \(sqlwork.com\)]

if you change the database, you need to rebind the datalist

-- bruce (sqlwork.com)

"Simon Rigby" <go****@simonri gby.co.ukwrote in message
news:11******** **************@ m73g2000cwd.goo glegroups.com.. .

Hi folks,

This seems to have been asked quite a bit but the solutions either dont
pertain to my case or the only response is to supply code. So here's
the question and the code is at the bottom.

I have a datalist which is displaying images in a gallery. Each image
has a pair of buttons to promote or demote the image in the list.

A little explanation about the code. The back end database contains two
tables Image and Gallery. Image contains a path to the image, an unique
ID a foreign key to the Gallery table to determine gallery membership
and an integer sequence number to determine the order it appears within
a gallery.

GalleryQuery is a class with a number of static methods that perform
operation on the backend sql server database. I'll refer to it as GQ in
the following for brevity

GQ.GetMinimumSe quenceNumber gets the lowest sequence number for a given
gallery

GQ.GetMaximumSe quenceNumber gets the highest sequence number for a
given gallery

GQ.GetSequenceN umber gets the sequence number for a specific image

GQ.PromoteImage swaps the sequence number of the chosen image with the
one above.

GQ.DemoteImage swaps the sequence number of the chosen image with the
one below

All of the above works as expected and if I check the backend database
after clicking a promote or demote button the relevent switch has
occured. Reviewing the page shows the switch has occured, however I
can't find a way of making the refresh occur without doing a
response.redire ct or server.transer back to the same page.
Unfortunately there are other controls on the page that lose their
state as a result.

I'm assuming that some thing is required at the points marked // ??? in
the code.

Any help greatly appreciated.

protected void CommandFunction (object source, DataListCommand EventArgs
e) {
int gallery = int.Parse(lstGa llery.SelectedV alue);
int min = GalleryQuery.Ge tMinimumSequenc eNumber(gallery );
int max = GalleryQuery.Ge tMaximumSequenc eNumber(gallery );
int current =
GalleryQuery.Ge tSequenceNumber (int.Parse(e.Co mmandArgument.T oString()),
gallery);
int currentImage = int.Parse(e.Com mandArgument.To String());

if (e.CommandName == "MoveUp") {
if (current min) {
GalleryQuery.Pr omoteImage(curr entImage, gallery);
// ???
}
} else if (e.CommandName == "MoveDown") {
if (current < max) {
GalleryQuery.De moteImage(curre ntImage, gallery);
// ???
}
}
}

[Simon Rigby]

doh. I cant believe I missed that. Moral of the story is stop trying to
multi task. I should know as a male that doesn't work.

Thanks Bruce (I'll be in the corner)
bruce barker (sqlwork.com) wrote:

if you change the database, you need to rebind the datalist

-- bruce (sqlwork.com)

"Simon Rigby" <go****@simonri gby.co.ukwrote in message
news:11******** **************@ m73g2000cwd.goo glegroups.com.. .

Hi folks,

This seems to have been asked quite a bit but the solutions either dont
pertain to my case or the only response is to supply code. So here's
the question and the code is at the bottom.

I have a datalist which is displaying images in a gallery. Each image
has a pair of buttons to promote or demote the image in the list.

A little explanation about the code. The back end database contains two
tables Image and Gallery. Image contains a path to the image, an unique
ID a foreign key to the Gallery table to determine gallery membership
and an integer sequence number to determine the order it appears within
a gallery.

GalleryQuery is a class with a number of static methods that perform
operation on the backend sql server database. I'll refer to it as GQ in
the following for brevity

GQ.GetMinimumSe quenceNumber gets the lowest sequence number for a given
gallery

GQ.GetMaximumSe quenceNumber gets the highest sequence number for a
given gallery

GQ.GetSequenceN umber gets the sequence number for a specific image

GQ.PromoteImage swaps the sequence number of the chosen image with the
one above.

GQ.DemoteImage swaps the sequence number of the chosen image with the
one below

All of the above works as expected and if I check the backend database
after clicking a promote or demote button the relevent switch has
occured. Reviewing the page shows the switch has occured, however I
can't find a way of making the refresh occur without doing a
response.redire ct or server.transer back to the same page.
Unfortunately there are other controls on the page that lose their
state as a result.

I'm assuming that some thing is required at the points marked // ??? in
the code.

Any help greatly appreciated.

protected void CommandFunction (object source, DataListCommand EventArgs
e) {
int gallery = int.Parse(lstGa llery.SelectedV alue);
int min = GalleryQuery.Ge tMinimumSequenc eNumber(gallery );
int max = GalleryQuery.Ge tMaximumSequenc eNumber(gallery );
int current =
GalleryQuery.Ge tSequenceNumber (int.Parse(e.Co mmandArgument.T oString()),
gallery);
int currentImage = int.Parse(e.Com mandArgument.To String());

if (e.CommandName == "MoveUp") {
if (current min) {
GalleryQuery.Pr omoteImage(curr entImage, gallery);
// ???
}
} else if (e.CommandName == "MoveDown") {
if (current < max) {
GalleryQuery.De moteImage(curre ntImage, gallery);
// ???
}
}
}