|
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
|
|
|
|
|
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.
|
|
|
|
|
make sure that you don't have the javascript running on the server side
runat="client"
|
|
|
|
|
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;
|
|
|
|
|
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.
|
|
|
|
|
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;
|
|
|
|
|
that makes sense, thanks for the clarification.
|
|
|
|
|
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
|
|
|
|
|
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;
|
|
|
|
|
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
|
|
|
|
|
|
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
|
|
|
|
|
Araj01 wrote: AuthUserFile password
Try a fully qualified path to the password file. Something like;
AuthUserFile /XXXXXXX/XXXXXXX/htpasswd
|
|
|
|
|
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
|
|
|
|
|
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?
|
|
|
|
|
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[^]
|
|
|
|
|
Johnny ² wrote: WAMP[^]
Thanks, this will do it.
|
|
|
|
|
Can someone please help me on how I can get over the 401 error?
|
|
|
|
|
Araj01 wrote: Can someone please help me on how I can get over the 401 error?
If putting in the fully qualified path to the password file didn't work then I am out of suggestions. That is the only thing I see in your original post that may have been causing your problems.
As I have stated I have never installed Apache server on a windows machine so I don't have any working models in that environment.
Perhaps others in this forum have experience with that platform and can help you.
|
|
|
|
|
message sent to the server is
POST https://localhost/cgi-bin/cgi_xml.exe HTTP/1.1
Host: MyFirm
Connection: close
User-Agent: GetURL
Authorization: BASIC dGVzdCA6IHRlc3QxMjM=
Content-Length: 747
Content-Type: application/xml; charset=UTF-8
response received from the server is
HTTP/1.1 401 Authorization Required
Date: Fri, 27 Jul 2007 20:11:03 GMT
Server: Apache/2.0.59 (Win32) mod_ssl/2.0.59 OpenSSL/0.9.8d
WWW-Authenticate: Basic realm="restricted stuff"
Content-Length: 506
Connection: close
Content-Type: text/html; charset=iso-8859-1
Can anyone tell me if the header information i am providing is incorrect?
|
|
|
|
|
Hi Guys,
Is there a way to extract the value below and place it inside an array?
Below are sample data to be extracted:
<area coords="323,233,335,292" href="1300A0-11">
<area coords="355,123,433,169" href="1102A0-11">
Below are the exctrated data:
1 - 323
2 - 233
3 - 335
4 - 292
5 - 1300A0-11
6 - 344
7 - 264
8 - 234
9 - 57
10 - 110230-11
I hope you can help me with this.
Thanks in advance
hifiger2004
|
|
|
|
|
Hi,
I have a nested DIV structure (not shown here) where both have an onclick event, hence
I am cancelling the event from bubbling up to the outer DIV, but this
has caused the Panel to remain opened when I click on another dropdown
(in another item within my repeater) or anywhere else on the page, and
I am wondering if anyone knows how to close the panel manually using
the AjaxControlToolkit.DropDownBehavior?
Here is some source code:
<asp:repeater id="Repeater1" runat="server">
<itemtemplate>
<%# Eval("Text") %>
<asp:label id="TextLabel" runat="server" text="Select your
favorite exotic ice-cream flavor"
="" style="display: block; width: 300px; padding:2px; padding-
right: 50px; font-family: Tahoma; font-size: 11px;">
<asp:panel id="DropPanel" runat="server"
cssclass="ContextMenuPanel" style="display :none; visibility:
hidden;">
<asp:linkbutton commandargument="www.google.ca"
runat="server" id="Option1" text="Mocha Blast"
cssclass="ContextMenuItem" onclick="OnSelect">
<asp:linkbutton commandargument="www.google.ca"
runat="server" id="Option2" text="Java Cyclone"
cssclass="ContextMenuItem" onclick="OnSelect">
<asp:linkbutton commandargument="http://www.google.ca"
runat="server" id="Option3" text="Dry Fruit"
cssclass="ContextMenuItem" onclick="OnSelect">
<asp:hyperlink id="HyperLink1" runat="server"
text="HyperLink" navigateurl="http://www.google.ca"
cssclass="ContextMenuItem">
<ajaxtoolkit:dropdownextender runat="server" id="DDE"
="" targetcontrolid="TextLabel" dropdowncontrolid="DropPanel">
<asp:updatepanel id="Update" runat="server">
<contenttemplate>
<asp:label id="lblSelection" runat="server"
style="padding: 5px;">
<triggers>
<asp:asyncpostbacktrigger controlid="Option1"
eventname="Click">
<asp:asyncpostbacktrigger controlid="Option2"
eventname="Click">
<asp:asyncpostbacktrigger controlid="Option3"
eventname="Click">
The JavaScript:
function cancelEvent(e) {<br />
<br />
alert('cancel');<br />
if(window.event) {<br />
alert('1');<br />
if (!e) e = window.event;<br />
e.cancelBubble = true;<br />
}<br />
else if ( e.stopPropagation) {<br />
e.stopPropagation();<br />
}<br />
else {<br />
alert('3');<br />
return false;<br />
} <br />
}
|
|
|
|
|
Hello All,
I have a DHTML and Javascript Dropdown menu. Menu is at the top of the Page. And DropdownList or Combo Box is little bit down from the Menu.
DropdownMenu populates when it shows the Submenu the Dropdownlist overlapping the Submenu(DHTML Menu).
I tried in the Google. They said, if you use iframe you can resolve the problem. But i dont know how to use.
Please help me...
Thanks in Advance
Thanks & Regards
Kumaran
|
|
|
|
|
|
Luay.Essa wrote: Use Ajax
To do what exactly?
The problem arises since combos aren't rendered as proper HTML elements in IE6 (IE7 doesn't have the problem, so quick fix == upgrade lol!), but are actually rendered as windowed elements - just like IE itself.
The iFrame workaround uses the fact that iFrames are also windowed elements, so appear in front of the combos.
To use, you need to set up a pge with the contents of your popup, and put an iFrame in it's place on the original page. When showing the popup, you then need to set the src of the iFrame to the new page. This isn't a particularly good solution though, but the others aren't much better! (My personal fave is setting the display to none for any windowed elements before showing the popup, but that can SUCK badly dependent on the page)
"Knock me down, I'll get straight back up again, I'll come back stronger than a powered up pacman"
(Lilly Allen / Kaiser Chiefs)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
