Web Development

bound datalist to database

7-Mar-02 10:44

Add the http-header Content-Disposition, with at value of "attachment; filename=xxx".

You can do this using asp (example using jscript):
Response.AddHeader("content-disposition","attachment; filename="+TheFileName);

Or you can change the content-type of the file to something the browser isn't going to recognize.
This can be done in IIS Manager or asp.

- Morten

Mazdak6-Mar-02 8:10

Mazdak

6-Mar-02 8:10

I'm designing a web site ASP.NET and C#,and I have a access database.
Now I add a DataList to my page,then I put a Label in the DataList,the quetion is this:
How can I bound this label on the datalist,to one of the column of database?

Mazy

"So,so you think you can tell,
Heaven from Hell,
Blue skies from pain,...
How I wish,how I wish you were here."
Wish You Were Here-Pink Floyd-1975

Javascript Sorting Problem

Nick Parker6-Mar-02 6:32

6-Mar-02 6:32

Ok here is the situation. I need to be able to sort a table of data that is returned in a paged recordset layout. The idea I am trying to create for the user is that if they click on the "Head" of the column once the data will be sorted descending, again and it will be sorted ascending. I have found a script on another site to do this however it doesn't work in Netscape and the application I am working on requires browser compliance across the board. Does anyone have any suggestions? Thanks in advance.

P.S. - Right now the application will sort the entire contents of the returning results, I only want to sort descending or ascending of the 10 records per page that is being displayed.

Nick Parker

mortrr7-Mar-02 10:56

7-Mar-02 10:56

I assume you're talking about requesting the data again from the database, and not using dhtml (which could be he only reason why the script doesn't work with netscape) to sort the single page.

Getting your 10 records from the database, in the right order within a single page, can only be done by requesting those specific records by ID. So you'll have to send the IDs of the records back to the server (hidden input) with the sort field.

MS SQL:
"SELECT * FROM myTable WHERE ID IN ("+myIDs+") ORDER BY "+orderField

myIDs contains comma-separated IDs.

Paging after sorting using a different field, will be a bit confusing though, as the user whould have to return to your default sort-order.

- Morten

Nick Parker7-Mar-02 18:19

7-Mar-02 18:19

Morten Rasmussen wrote:
I assume you're talking about requesting the data again from the database

I am actually looking into methods that will allow me to sort the data without returning to the server. I do have a script that does this but it is only effective in IE. Thanks

Nick Parker

mortrr7-Mar-02 21:52

7-Mar-02 21:52

It can be done in the browser, including NS (but only NS6).

Give all cells an ID.
Cell_00_00 - Cell_00_01 - Cell_00_02
Cell_01_00 - Cell_01_01 - Cell_01_02
Cell_02_00 - Cell_02_01 - Cell_02_02

Create an Array for client-side javascript that contains all data (no need to read data from the table, before each sort).

On click, sort the data (same array or to new array) and insert cell by cell.

- Morten

Nick Parker8-Mar-02 5:51

8-Mar-02 5:51

I beleive we are basing our tests off the earlier versions of Netscape 4. Seem to run into a brick wall everytime. Mad | :mad:

Nick Parker

mortrr8-Mar-02 6:10

8-Mar-02 6:10

If you don't have any form elements in the table, you can try:
http://www.mattkruse.com/javascript/sorttable/index.html
It's not extremely stable in NS 4.x, but it works if you don't click around too fast (as all NS layering).

The buttom sample works in NS.
Not the top one, as it contains form elements.

You must have a very insistent customer, since you're trying to implement it for NS 4.0x
The user base is propably below 1 percent now, and why ruin the "experience" for users keeping up to date?

- Morten

Nick Parker8-Mar-02 6:16

8-Mar-02 6:16

Morten Rasmussen wrote:
The user base is propably below 1 percent now, and why ruin the "experience" for users keeping up to date?

You are probably correct; the company I work for represents a conglomerate of independent telephone companies, none of which we can require them to use IE.

Nick Parker

mortrr8-Mar-02 6:22

8-Mar-02 6:22

Still, if you have to use hours upon hours implementing a single feature that will at best work flakily in NS 4.x for what is most likely a small userbase (even in phone companies - unless they're using OS/2), the time could be used better developing other features.

To get the "tablesort" to work a bit better in NS, you could disable the click event for the coloumn-headings until the table is redrawn.

- Morten

Good drop down menu example

11-Mar-02 1:19

Morten Rasmussen wrote:
for what is most likely a small userbase

Unfortunately we cover 147 independent telephone companies in Iowa so we do have quite a large user base. Smile | :)

alex.barylski5-Mar-02 13:40

Re: Good drop down menu example

5-Mar-02 13:40

Anybody know a good cross-browser dropdown menu example I can rip apart and re-assemble (with changes of course) as my own...?

Does code project have anything like this...?

"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr

Chris Maunder6-Mar-02 3:10

Chris Maunder

6-Mar-02 3:10

I've been looking at implementing a couple of different versions of dropdowns but each one I've seen seems to have problems. I've pretty much decided that if I add dropdowns it's going to be IE only. Netscape is just too much of a dog's breakfast.

cheers,
Chris Maunder

Re: Good drop down menu example

alex.barylski6-Mar-02 13:05

Re: Good drop down menu example

6-Mar-02 13:05

I was at a site which generated the menu for you, which I believe was cross browser friendly...I'd like cross-browser anyway...

Most people use IE here at CP I assume...?

I agree NS is so much more work, for what..? How many people actually use that heffty clump of shite known as NS anyways...?

p.s-Drop down menus would be a nice interface for CP. Smile | :)

"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr

Nick Parker6-Mar-02 6:36

Loading URL in current window

6-Mar-02 6:36

This should do the trick, this drop down menu will work in IE, Netscape and Opera Smile | :)

Here is the link: Best Lil' Drop Down Menu Around.
Hope this helps.

Nick Parker

alex.barylski5-Mar-02 11:25

Re: Loading URL in current window

5-Mar-02 11:25

How can I load a URL into the current window using JavaScript..??? Mad | :mad:

function showProducts(index)
{
  switch(index)
  {
    case 0:
	alert("Please select a categorey");
	break;
    case 1:
	window.open("prod2.htm",_top );
	break;
    case 2:
	window.open("prod1.htm",_top );
	break;
    default:
	alert("Invalid index, application error!");
  }
}

The above is what I currently have. Notice the _self as a parameter in the window.open function...?

When using anchors and specifying _self you can load an external URL into the current window, this is the effect I am after, but I must do it like the above...

I don't want to dynamically write the new contents to the current document window, but I will have to by tomorrow if I can't figure out a simpler solution.

Can I name the document in HTML or something...?

Is the name paramter in window.open() only good for window names retured by previous calls to open()..?

Anyways I really need the quick fix for the above problem only...if you could assist me...that'd be great!

Thanx you muchly!!!

"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr

alex.barylski5-Mar-02 11:52