You can get the data using stored procedure like this.[^].
If you are having the data in dataset then you can put it whereever you want.

Best Regards,
Apurva Kaushal

hello !!!
cud neone hlp me find out how can i prevent users from saving the web page on their local systems ....i:e no File-> save as ...

MARTAND SHARDUL

I doubt that's ever been possible, but the advent of things like Firebug make it completely impossible. Users can copy and paste your HTML, quite trivially.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

There's a hack you can use that'll prevent it from working in some versions of IE. But as CG stated, you really can't prevent it reliably.

If you really need your users to be annoyed when they use your site, consider using lots of animation, clashing colors, and popups every time they click something. If they never come back, they'll never be able to save...

----

...the wind blows over it and it is gone, and its place remembers it no more...

That would make for one interesting article!

LOL - this made my day.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Just to confirm, not possible.

Brad
Australian

- "Bash.org" on "The opposite of Love"

<+pf_work> what's the opposite of <3?
<Lokii> h8
<Rodry> </3
<sdoherty> >3
<Lems> !<3

Hi all.

I managed to get this code but cant tell why it doesnt show the results.Its suppose to display the dropdownlist with all the values from the database.

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>

<%
Option Explicit

'-- Variables we are using
dim objConn, objRS, objRS2, strSQL

'-- Define our objects
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Recordset")
Set objRS2 = Server.CreateObject("ADODB.Recordset")

'-- Database path and Data provider
objConn.ConnectionString = Server.MapPath("C:\dropdowns.mdb")
objConn.Provider = "Microsoft.Jet.OLEDB.4.0"
objConn.Open

'-- Sub Procedure that builds the dropdown list
Sub showDropDownList(c, r, table)

'-- SQL Statement
strSQL = "SELECT * FROM " & tblDropDownTest & " ORDER BY Title ASC"
'-- Execute our SQL statement and store the recordset
Set r = c.Execute(strSQL)

'-- If we have records to return
if r.eof = false then
'-- Open a form/select tag
Response.Write ""
Response.Write "" & vbCrLf
Response.Write "Choose...."
'-- loop and build each database entry as a selectable option
While r.EOF = false
Response.Write "" _
& r.Fields("Title").Value & "" & vbCrLf
'-- Move recordset to the next value
r.movenext
Wend
else
response.write"<"Sorry, no records selected">"
end if
'-- close select/form tags
Response.Write "" & vbCrLf

End Sub

'-- Sub Procedure that builds the dropdown list
Sub showDropDownList2(c, r, table)

'-- SQL Statement
strSQL = "SELECT * FROM " & tblDropDownTest & " ORDER BY Title ASC"
'-- Execute our SQL statement and store the recordset
r.Open strSQL, c, 3, 3

'-- If we have records to return
if r.eof = false then
'-- Open a form/select tag
Response.Write ""
Response.Write "" & vbCrLf
'-- loop and build each database entry as a selectable option
'filter
r.Filter = ("Type = 'fruit'")
Response.Write "Choose...."
Response.Write ""
While r.EOF = false
Response.Write "" _
& r.Fields("Title").Value & "" & vbCrLf
'-- Move recordset to the next value
r.movenext
Wend

r.Filter = adFilterNone

r.Filter = ("Type = 'veg'")
Response.Write ""
While r.EOF = false
Response.Write "" _
& r.Fields("Title").Value & "" & vbCrLf
'-- Move recordset to the next value
r.movenext
Wend
end if
'-- close select/form tags
Response.Write "" & vbCrLf

End Sub
%>

<title>Dynamic dropdown lists in ASP(VBScript) - designplace.org

Dynamic dropdown lists using Active Server Pages and Microsoft Access

Below is an example of a drop down list, dynamically populated from a
database table.

<%
' -- Call the sub procedure to build the drop down list, with the connection and recordset objects and the source table (In quotes).
call showDropDownList(objConn, objRS, "tblDropDownTest")
Sub showDropDownList(c, r, table)

'-- SQL Statement
strSQL = "SELECT * FROM " & tblDropDownTest & " ORDER BY Title ASC"
'-- Execute our SQL statement and store the recordset
Set r = c.Execute(strSQL)

'-- If we have records to return
if r.eof = false then
'-- Open a form/select tag
Response.Write "

"
Response.Write "" & vbCrLf
Response.Write "Choose...."
'-- loop and build each database entry as a selectable option
While r.EOF = false
Response.Write "" _
& r.Fields("Title").Value & "" & vbCrLf
'-- Move recordset to the next value
r.movenext
Wend
else
response.write"<"Sorry, no records selected">"
end if
'-- close select/form tags
Response.Write "" & vbCrLf

End Sub
%>

Here is the same drop down list, but this time it has been filtered to show
fruit first under a heading, then veg.

<%
' -- Call the sub procedure to build the drop down list, with the connection and recordset objects and the source table (In quotes).
call showDropDownList2(objConn, objRS2, "tblDropDownTest")
%>

kagiso

I m not understand wat is your problem is just write wat is the problem not all coding..

Viral
YahooID : just_viral
My Site : www.theseoworld.info

--------------------------------------------------------------------------------------------------
Hiral Shah
India

Hi to all,
does any one knows how it is possible to control file input type field at form? I read a lot about this and i tried a lot of examples and suggestions but I couldn't get good results.
If it is possible to do it by HTA which has APPLICATION=yes as attribute then how? I also tried to use ActiveXObject classes, last one which I tried is InternetExplorer.Application.
Main issue with solutions in VBS and JScript is ADODB.Stream which is loading complete file in client memory. If I tried to upload at least 700MB to server by some working code I get error message from script that there is no more memory to store a file.
HELP, please if there is any solution to use existing file input field and to change value dynamically to upload multi files.

Sniffer

You can't do much at all with a file input field, it's very restricted in order to protect the user. Also it sends the file in a request, which is not a good way to send large files.

If you want things like large file upload and multi upload, look for a component that does this.

---
single minded; short sighted; long gone;

Hi All,

I am writing internet application proxy for which i have to convert HttpContext.Current.Request object to WebRequest object such that i pass on all the information from Request to WebRequest.

Any ideas?

Thanks,
Amit

You can't convert a HttpRequest object to a WebRequest object, so you have to copy the information you want from one object to the other.

---
single minded; short sighted; long gone;

Hey all,

I wanted to get some recommendations for merchant account/gateway/shopping cart solutions for a Canadian based web store.

The store is pretty typical: <100 products, physical merchandise (hats, tshirts, toys, etc.), currently considering both manual and real time transaction processing.

I'd prefer the technology solution to be ASP.NET and C#.

Has anyone implemented a similar solution and would recommend their choice of vendor?

Thx

I have a really fancy (at least to me) effect I want to use, I'm not sure where to start, what to use, or even if it's even possible. Any help would be great, I mostly need a push in the right direction.

The final result I'd like it a Bubble (crystal ball, something like that) with text in it. As the users scrolls (scroll wheel enabled) I want the text to fade in from the bottom then fade out at the top. I don't want a normal fade though, I want it to expand/shrink also so it stays with the curve of the bubble. I would also like it to be HTML compatible so I can have links, pictures, headers, etc. I want the HTML used in the bubble to be changeable on the fly so I can have AJAX update the text as links are clicked. The height/width needs to be scalable so it fills the area no mater what size the browser is. Lastly I want it cross-browser compatible.

I think that's it, I know I'm looking for a lot, but as I said I'm just looking for a direction to start in. Currently I'm pretty good in ASP.NET with VB.NET, PHP, Javascript, ASP, CSS, and HTML (duh). I'm thinking the best fix for my problem is Java or Flash, but I'm hoping to stay with what I know.

Thanks for any help given,
Nick

You might want to investigate the AJAX Control toolkit for ASP.NET... specifically the Animation control... it might let you do what you want to do.

http://ajax.asp.net/ajaxtoolkit/Animation/Animation.aspx[^]

I'm not sure the scroll wheel will throw an event in javascript, have you found that out? There is a scroll event for elements but I'm not sure how it works (you might be able to put the text inside a scrolling div and hook into the divs scroll event to shape the text). I've no doubt it could be done with Flash (and take the content as HTML from another source).
You could easily get the 'fade' effect by using an image with a transparent ball in the middle (with some nice gradients on the top and bottom of course), and the content underneath that in the z-index order, but it won't resize the content width as it scrolls.

RX Maverick wrote:
I don't want a normal fade though, I want it to expand/shrink also so it stays with the curve of the bubble.

Consider using Flash. HTML really isn't built for this sort of thing (you could probably make it work using canvas, but that doesn't work on IE).

----

...the wind blows over it and it is gone, and its place remembers it no more...

Hi All,

I am developing an website application for client which would be hosted by US and but it need to access client database. I have made client webservice to access database but main problem comes when pages hosted by my application need to access client webservice.

client is not ready to open up webservice to internet(quite understandable)? I was thinking of writing internet application proxy which will reside on client. It will access client webservice and also will access my pages.

Do you guys have any other idea or if there is sample code for similar idea being implemented, please forward it to me?

Thanks,
Amit

You could set up a sub-domain that is password protected and has its own database. Something like test.domain-name.com as a sub-domain of www.domain-name.com.

I do that for development and testing of new features to a production site so that only authorized people can gain access and the new features can be throughly tested on the actual web server that they will eventually be deployed on.

That model would also work for rolling out new web services. You could throughly test the services before cut over to the production domain.

Simply Elegant Designs JimmyRopes Designs
Think inside the box! ProActive Secure Systems

I'm on-line therefore I am.
JimmyRopes

Hi I am using AJAX in my my website.Its working fine on the localhost
but when i upload the application on to the server its giving the following error..

CS0234: The type or namespace name 'AsyncPostBackErrorEventArgs' does not exist in the namespace 'System.Web.UI' (are you missing an assembly reference?)

Any Help..PLz..

The server probably doesn't have the same version of AJAX ASP.NET installed as on your machine. Try to compare the versions.

the versions are same..
and moreover i hav another pagewith ajax in the same site and that page is working fine..
hmm..wat cud be the problem?? D'Oh! | :doh:

Well you could also compare the web.config files to see if both versions contain the same assembly references (under system.web/compilation/assemblies). Maybe the file on the production server is missing one that the local contains. If this is also not the case then I've run out of ideas..

Web Development

Dynamic dropdown lists using Active Server Pages and Microsoft Access