ASP.NET

Populating Drop Down Using XMLDatasource:

4-Jul-07 1:10

Via the Session object.

Please visit http://www.readytogiveup.com/ and do something special today.
Deja View - the feeling that you've seen this post before.

Shahzad.Aslam4-Jul-07 0:51

Shahzad.Aslam

4-Jul-07 0:51

Hi I m trying to populate dropdown list using XMLDatasource control.

code for DDL:
<asp:DropDownList ID="ddlLanguages" runat="server" Width="277px" DataSourceID="XmlDataSource1">
</asp:DropDownList>
Code for XMLDataSource:
<asp:XmlDataSource ID="XmlDataSource1" runat="server" DataFile="~/Languages.xml"></asp:XmlDataSource>

it does not displaying data, it is just showing system.web.UI.WebControls.XMLDatasource

Shahzad Aslam
Software Engineer

Re: Populating Drop Down Using XMLDatasource:

But_Im_a_Lady4-Jul-07 3:51

But_Im_a_Lady

4-Jul-07 3:51

See my example which works fine...

<code><asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="XmlDataSource1"
DataTextField="name" DataValueField="name">
</asp:DropDownList>
<asp:XmlDataSource ID="XmlDataSource1" runat="server" DataFile="~/XMLFile.xml">
</asp:XmlDataSource></code>

The xml file:

<code><?xml version="1.0" encoding="utf-8" ?>
<fruits>
<fruit name="apple" />
<fruit name="pear" />
</fruits></code>

HTH
Janet

Re: Populating Drop Down Using XMLDatasource:

Shahzad.Aslam4-Jul-07 19:39

Shahzad.Aslam

4-Jul-07 19:39

the following XML file i m using:

<languagenames>
- 
- <languagename>
<languageused>en</languageused>
<languagedescribed>aa</languagedescribed>
<name>Afar</name>
</languagename>
- <languagename>
<languageused>en</languageused>
<languagedescribed>ab</languagedescribed>
<name>Abkhazian</name>
</languagename>
</languagenames>

if i give name in the DataTextField or DataValueField it indicate following error:
"DataBinding: 'System.Web.UI.WebControls.XmlDataSourceNodeDescriptor' does not contain a property with the name 'name'"

Any Idea?

Shahzad Aslam
Software Engineer

Re: Populating Drop Down Using XMLDatasource:

But_Im_a_Lady4-Jul-07 21:06

But_Im_a_Lady

4-Jul-07 21:06

Your xml file is a different format to the sample one i sent you.
See http://www.topxml.com/code/default.asp?p=3&id=v20050220140055&ms=20&l=C&sw=categ[^]
for similar example to what you need

Janet

Reading RSS Attribute with a Colon( : )

wEb GuRu...4-Jul-07 0:48

wEb GuRu...

4-Jul-07 0:48

Dear Developers

I'm reading and showing RSS in a Datalist. But I'm unsure how to get values from attributes having colon( : ). Like http://www.carmagazine.co.uk/car.rss[^] uses colon( : ) in field "cfi:lastdownloadtime".

When I use DataBinder.Eval(Container.DataItem, "title") in datalist, it give an error. Any idea how to access this attribute???

-- modified at 6:56 Wednesday 4th July, 2007

All the way from Sialkot ...

Please Help: Javascript Error: Object doesn't support this property or method.

irsh_is4-Jul-07 0:21

irsh_is

4-Jul-07 0:21

Hi,
I have an object tag as below.

<object id="basket" name="basket" classid="http:/public/bin/SmartControls.dll#Mycompany.SmartControls.DocumentDownload" height="0" width="0" viewastext="">
<param name="Protocol" value="<%= GetContextProtocol() %>" />
<param name="Domain" value="<%= GetContextDomain() %>" />
<param name="DocumentRetrievalURL" value="showDoc/Research.dox?docIDs=" />

And from the javascript I am calling a method present in this dll as below

function SmartClientDownload(XmlString)
{
var err = "";
try {
alert("basket = " + document.all("basket"));
basket.Context= XmlString;
basket.Download();
}
catch(e){
err="There was an error on this page.\n";
err+="Error description: "+e.description+"\n";
alert(err);
}
}

Here I get an error Object doesn't support this property or method.
Sometimes it work sometimes it fails, Let me know if you have faced this issue.

Thanks and Regards
Irsh

Re: Please Help: Javascript Error: Object doesn't support this property or method.

RichardGrimmer4-Jul-07 4:51

RichardGrimmer

4-Jul-07 4:51

irsh_is wrote:
Here I get an error Object doesn't support this property or method

Where in the code is it failing?

"Knock me down, I'll get straight back up again, I'll come back stronger than a powered up pacman"
(Lilly Allen / Kaiser Chiefs)

Re: Please Help: Javascript Error: Object doesn't support this property or method.

Irshad Ahmed4-Jul-07 4:59

Irshad Ahmed

4-Jul-07 4:59

Hi Richard,

Thanks for responding.

I am getting the error in this statement.

basket.Download();

There is a method called Download() in the assembly which i am trying to access. It fails with the exception i have told before

Thanks
Irsh

cast in generics List of objects

papy-boom4-Jul-07 0:07

papy-boom

4-Jul-07 0:07

hi,
could anyone correct my code to make cast between two generic list of object
public List<string> GetAllBrands()
{
List<tblbrand> ListBrand;
//this line of code contain an error
ListBrand = (List<tblbrand>)Product.GetAllObjects("Brand");
......
}
public static List<object> GetAllObjects(string ObjectName)
{
...
}
thanks in advance !!!

Re: cast in generics List of objects

Pete O'Hanlon4-Jul-07 0:28

Re: Rusty Coder Needs Help

4-Jul-07 0:28

Are you looking to do something like this?

public List<TblBrand> GetAllBrands()
{
  return Product.GetAllObjects<TblBrand>("Brand");
}
public static List<T> GetAllObjects<T>(string objectName)
{
  ...
}

Please visit http://www.readytogiveup.com/ and do something special today.
Deja View - the feeling that you've seen this post before.

Rusty Coder Needs Help

munklefish4-Jul-07 0:06

munklefish

4-Jul-07 0:06

Hi,

Please forgive my ignorance, as ive not done much development on the Microsoft side for a few years, and im just moving back onto .Net 2.

My problem is i am displaying a simple list of words from an SQL2005 DB. However i need to display the info alphabetically across three columns ie:

1 6 11
2 7 12
3 8 13
4 9 14
5 10 15

or even:

1 2 3
4 5 6
7 8 9
10 11 12
13 14 15

etc. How do i do this / which control is the best method? Im not properly aqauinted with the 'new' controls in 2.0

Thanks in advance.

Urs Enzler4-Jul-07 0:22

Urs Enzler

4-Jul-07 0:22

Take a look at DataList. With this control you can define the number of rows or columns and the repeat direction.

-^-^-^-^-^-
no risk no funk

Re: Rusty Coder Needs Help

munklefish4-Jul-07 0:31

munklefish

4-Jul-07 0:31

Thanks Urs!

form authentication

24891284-Jul-07 0:05

2489128

4-Jul-07 0:05

in my application, there are some pages that are secured & some are non secure. all the pages are displayed in an iframe. how can i apply form authentication for secured pages?

Thanks & Regards,
SAMir Nigam,
Software Engineer,
STPL, Lucknow, India.

Problem with SqlDataReader

netwizerd4-Jul-07 0:01

netwizerd

4-Jul-07 0:01

I am building an ASP.Net C# Web project. in the HTML form of the .aspx file
I have

<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

SqlConnection conn = new SqlConnection("Data Source=DATA-SERVER;Initial Catalog=Intech;Trusted_Connection=true");
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM users WHERE username='"+Username.Value+"' AND password= '"+Password.Value+"'";

// Fill our parameters
cmd.Parameters.Add("@username", SqlDbType.NVarChar, 64).Value = Username.Value;
cmd.Parameters.Add("@password", SqlDbType.NVarChar, 128).Value = Password.Value; // Or "sha1"

// Execute the command
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
// Create a new ticket used for authentication
FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(
1, // Ticket version
Username.Value, // Username associated with ticket
DateTime.Now, // Date/time issued
DateTime.Now.AddMinutes(30), // Date/time to expire
true, // "true" for a persistent user cookie
reader.GetString(0), // User-data, in this case the roles
FormsAuthentication.FormsCookiePath);// Path cookie valid for

// Encrypt the cookie using the machine key for secure transport
string hash = FormsAuthentication.Encrypt(ticket);
HttpCookie cookie = new HttpCookie(
FormsAuthentication.FormsCookieName, // Name of auth cookie
hash); // Hashed ticket

// Set the cookie's expiration time to the tickets expiration time
if (ticket.IsPersistent) cookie.Expires = ticket.Expiration;

// Add the cookie to the list for outgoing response
Response.Cookies.Add(cookie);

// Redirect to requested URL, or homepage if no previous page
// requested
string returnUrl = Request.QueryString["ReturnUrl"];
if (returnUrl == null) returnUrl = "/";

// Don't call FormsAuthentication.RedirectFromLoginPage since it
// could
// replace the authentication ticket (cookie) we just added
Response.Redirect(returnUrl);
}

I have the table as

CREATE TABLE users
(
username nvarchar(64) CONSTRAINT users_PK PRIMARY KEY,
password nvarchar(128),
roles nvarchar(64)
)

CREATE INDEX credentials ON users
(
username,
password
)

Now I am trying to access the table but at

SqlDataReader reader = cmd.ExecuteReader();
reader.Read();

I am not getting any result from reader.Read();

I need help.

Re: Problem with SqlDataReader

Colin Angus Mackay4-Jul-07 0:09

Re: Problem with SqlDataReader

4-Jul-07 0:09

netwizerd wrote:
cmd.CommandText = "SELECT * FROM users WHERE username='"+Username.Value+"' AND password= '"+Password.Value+"'";

// Fill our parameters
cmd.Parameters.Add("@username", SqlDbType.NVarChar, 64).Value = Username.Value;
cmd.Parameters.Add("@password", SqlDbType.NVarChar, 128).Value = Password.Value; // Or "sha1"

Fill out what parameters? You aren't using any parameters in the SELECT statement.

To use the parameters you should write:

cmd.CommandText = "SELECT * FROM users WHERE username=@username AND password=@password";

netwizerd wrote:
I am not getting any result from reader.Read();

Perhaps the data does not exist. Or...

netwizerd wrote:
reader.GetString(0), // User-data, in this case the roles

The first column isn't the roles. You've used SELECT * so in fact you don't know which column will be the roles because the columns will be returned in what ever order SQL Server decides is most efficient. You must use SELECT roles to ensure that the roles column is the first one.

By the way - for security you should also consider using a salted hash for storing passwords.

Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...

"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."

Ready to Give up - Your help will be much appreciated.

My website

netwizerd4-Jul-07 2:50

netwizerd

4-Jul-07 2:50

Thank you Colin but I used username=@username AND password=@password before but still my SQLDataReader was empty it was producing any result.

Yasin

Re: Problem with SqlDataReader

Colin Angus Mackay4-Jul-07 3:17

4-Jul-07 3:17

I do recommend using the Parameter route. They help prevent SQL Injection Attacks.

Have you tried writing the same query and running directly on SQL Server? Do you get any results?

I'm actually thinking that since you are only ever getting one value back (the roles) that ExecuteScalar would be better for your requirements (unless you are planning to get more data from the reader in the future)

ExecuteScalar retrieves one value only, the fist column of the first row. It will manage the data reader for you, so you don't have to worry about it. All you need to do is call ExecuteScalar instead of ExecuteReader and if the value isn't null you have matched the login.

I give up!

Colin Angus Mackay4-Jul-07 3:11

4-Jul-07 3:11

Some people are just a bunch of ungrateful pricks! I did my best to answer the OP here by suggesting various things to look at for a problem that is not immediately apparent. But someone thought it was worthy of a 1-vote.

Sigh | :sigh:

I think I'll concentrate on writing articles and organising events instead of trying to help out here.

Pete O'Hanlon4-Jul-07 3:16

4-Jul-07 3:16

Don't give up - I've 5 voted it to raise it up. I guess this was the same idiot who 1 voted an answer I gave earlier.

Please visit http://www.readytogiveup.com/ and do something special today.
Deja View - the feeling that you've seen this post before.

Colin Angus Mackay4-Jul-07 3:25

4-Jul-07 3:25

Pete O`Hanlon wrote:
Don't give up

Thanks - I'll try not to give up completely but I've noticed that I'm responding less and less these days. I'm concentrating on presentations, articles and events more and more. That is much more rewarding.

Are you any good at presenting? Would you like to do a presentation in Glasgow sometime?

Pete O'Hanlon4-Jul-07 3:38

4-Jul-07 3:38

It's been a while since I did any presentation type of work, apart from sales pitches. Now, if it's to come back up to Glasgow sometime, then I might just be persuaded. Big Grin | :-D

Please visit http://www.readytogiveup.com/ and do something special today.
Deja View - the feeling that you've seen this post before.

Pete O'Hanlon4-Jul-07 3:54

4-Jul-07 3:54

I think I've figured it out - somebody's after your MVP status. You do seem to be the target of scattergun 1 voting.

Please visit http://www.readytogiveup.com/ and do something special today.
Deja View - the feeling that you've seen this post before.

Colin Angus Mackay4-Jul-07 4:15