Web Development

27-Jul-07 4:21

there should be a bunch of examples online that will give you most if not all of the code you need. assuming that the value you want as the default is in the database, you just need to do dropDownList.SelectedValue = value; or you could use the SelectedIndex if you know exactly where the value will be in the data set and its location wont move. to bind the dropdownlist you just need to open an SqlConnection to the database set up a SqlCommand with your query and connection and use its ExecuteReader method to load a SqlDataReader which will then bind to a dropdown list like

sring sql = "";
SqlConnection myConnection = new SqlConnection(connectionString);
SqlCommad myCommand = null;
SqlDataReader myReader = null;

try{
myConnection.Open();
sql = "put your query here";
myCommand = new SqlCommand(sql, myConnection);
myReader = myCommand.ExectueReader();

dropDownList.DataSource = myReader;
dropDownList.DataTextField = "the field you want displayed";
dropDownList.DataValueField = "the value you want stored, like an id number"
dropDownList.DataBind();
//if you want to insert a value tat isnt in the database youjust need
dropDownList.Items.Insert(0,value);//i havnt used that ina while
//but is the locaiton in the array you want the item palces and value is the
//text to display
}catch(Exception e)
{
}
finally{
if(myCommand != null)myCommand.Dispose();
if(myReader !=null) myReader.Close();
myConnection.Close();
}

hope this helped

frame problem

SomeGuyThatIsMe27-Jul-07 2:59

27-Jul-07 2:59

I'm trying to use a repeater to display news articles with a link to each article or pdf or whatnot, however i dont really want the user to know that they've left one site to open one of the pdfs and i didnt really want to copy everything around since the news stories can be shown on multiple sites. so i have a javascript function that opens a new window to a htm page that has a frameset, then i try to se the location of the frameset in the same javascript like:

function newWindow(url)
{
var win;
win = window.open("news.htm","NewsArticle",
"toolbar=0,scrollbars=1,location=0,statusbar=0,menubar=0,resizable=1");
win.frmNews.location = url;
}

this works great on my machine, but it wont work when i put it on our web server, it says that frmNews in null or not an object.

that is the code from the news.htm file minus the title, meta tags, etc... the window opens but i cant change the link. any help would be greatly appreciated.

Ryanb5827-Jul-07 3:31

Ryanb58

27-Jul-07 3:31

make sure that you don't have the javascript running on the server side

runat="client"

Guffa27-Jul-07 3:38

Guffa

27-Jul-07 3:38

That's because the frameset hasn't yet loaded in the window.

Send the url as a parameter in the querystring to the frameset page, make the page asn aspx page, and user server code in it to get the url from the querystring and put it into the frame code.

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

SomeGuyThatIsMe27-Jul-07 4:13

27-Jul-07 4:13

Thanks, i got it working now, there was also a problem with the slashes in the url some were \\ instead of // and apparently js is rather perticular about it. i just used a loop to make the js wait until the frame was loaded then set its url, not necessarily good practice, but it works, and it completely hides the url i'm going to like it should.

Guffa27-Jul-07 8:23

Guffa

27-Jul-07 8:23

SomeGuyThatIsMe wrote:
there was also a problem with the slashes in the url some were \\ instead of // and apparently js is rather perticular about it.

It's rather the web server that is particular. If you use backslashes, it will not be treated as a separator between folders, but as a part of the filename.

So the url "http://www.site.com/folder\another\page.html" will try to get the file "folder\another\page.html" in the root folder of the web, not the "page.html" in some subfolder.

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

SomeGuyThatIsMe27-Jul-07 8:26

Re: Export to Excel or XML

27-Jul-07 8:26

that makes sense, thanks for the clarification.

image in IE7

Milind Panchal26-Jul-07 21:11

Milind Panchal

26-Jul-07 21:11

Hi,

I have created one web application by using html page. I have created run time images and they are creating at run time in IE6 but not in IE7.

function for creating image is

return "";

what is the solution for that ?

Thanks

Re: image in IE7

Guffa27-Jul-07 2:42

Guffa

27-Jul-07 2:42

You have shown too little of your code to give any possibility to see any problem with it.

That code doesn't create any image. It just creates a string and returns it. That code has to go into a function to work, and you have to call the function and do something with the result in order for something to happen.

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

Export to Excel or XML

Illegal Operation26-Jul-07 20:36

Illegal Operation

26-Jul-07 20:36

Morning Guys!

I have an issue. How would I go about exporting Data from a GridView to an Excel file or XML file? I would like it If I could export directly to excel.

Thanks!
Fritz Blignaut

Illegal Operation

Making Computer Software Talk

Vasudevan Deepak Kumar28-Jul-07 22:08

Vasudevan Deepak Kumar

28-Jul-07 22:08

To Excel:

http://aspalliance.com/771[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

how to perform basic authorization

Araj0126-Jul-07 8:39

Araj01

26-Jul-07 8:39

I have a apache server in which i have protected a file with user name and password as shown:

<directory "c:="" program="" files="" apache="" group="" apache2="" cgi-bin"="">
# AllowOverride AuthConfig
AuthType Basic
AuthName "restricted stuff"
AuthUserFile password
Require user test

from the client i am using POST command to access the server with authorization details as

Authorization: BASIC "base 64 encoded string of username and password"

even then i am getting 401 error.
kindly help

JimmyRopes26-Jul-07 11:50

26-Jul-07 11:50

Araj01 wrote:
AuthUserFile password

Try a fully qualified path to the password file. Something like;

AuthUserFile /XXXXXXX/XXXXXXX/htpasswd

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

I'm on-line therefore I am.
JimmyRopes

Araj0126-Jul-07 14:25

Araj01

26-Jul-07 14:25

I am using windows machine so will it be
AuthUserFile "c:/program files/apache group/apache2/bin/passwords"

if i give without quotes it gives me error

JimmyRopes26-Jul-07 14:43

26-Jul-07 14:43

Araj01 wrote:

if i give without quotes it gives me error

By all means specify it in quotes.

I am learning here, I didn't know that you could run an Apache server on a windows machine.

I would love to do that. Please tell me how I can proceed.

PS - did specifying the full path help?

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

I'm on-line therefore I am.
JimmyRopes

Johnny ²26-Jul-07 18:25

Johnny ²

26-Jul-07 18:25

JimmyRopes wrote:
I am learning here, I didn't know that you could run an Apache server on a windows machine.

I would love to do that. Please tell me how I can proceed.

WAMP[^]

JimmyRopes26-Jul-07 20:21

26-Jul-07 20:21

Johnny ² wrote:
WAMP[^]

Thanks, this will do it.

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

I'm on-line therefore I am.
JimmyRopes

Araj0127-Jul-07 7:31

Araj01

27-Jul-07 7:31

Can someone please help me on how I can get over the 401 error?

JimmyRopes27-Jul-07 8:08