bwalker

I have my ConnectionString in my web.config file and can access it through my code behing page easy enought,

Public oSQL AsNew OleDb.OleDbConnection(ConfigurationSettings.AppSet tings("SQLconn"))

but I can't access through the HTML page. I obviously don't want to bring my connectionstring into the HTML code.

Thanks for any assistance,
Bob

Rob

You are not really making yourself clear.

An HTML page will not be able to access your app settings simply because it's an HTML page

__________________
Rob - Webforumz Founder
Web Designer Support Network || Personal Project: Sanctuary for Student Midwives

bwalker

Thats what I was trying to find out. is there a place I should store Connectionstrings when working in HTML?

Rob

I still don't get you....

Why would an HTML page need a connection string.

__________________
Rob - Webforumz Founder
Web Designer Support Network || Personal Project: Sanctuary for Student Midwives

bwalker

OK, I'll start from the begining. I have a testbox where an account number is entered. On the 10th character I want to go to the database and get that account's info like the name and address. I couldn't find a way in the code-back page to track how many characters have been entered in a textbox, so I am tracking it in the HTML page using vbscript. And because this is in the HTML page, I don't want to but see no other way, to put the password infomation for the connectionstring in my code? I am looking for other ways to accomplish this.

QuikFrozen

Use another page. Instead of using a textbox to pick the account number, use an input, that way you can control the "onkeypress" event. Then you can use a javascript function that counts teh characters that the user has entered. When the count reaches to 10, redirect the page to another one and send the account number as a parameter. Thus you can control the database connectivity and query on the page_load event in the new page and then show the info you'd like.
Greetings...