|
My experience is that the installation of the 2.0 framework, provided that IIS is already installed, will hook the IIS manager with the ASP.NET configuration tab. Are you certain 2.0 is installed on that server? (is it possible it is 1.1 instead?)
|
|
|
|
|
I have .NET 2.0 installed. I have also added .NET Management Extensions in MMC, but still I do not see the ASP.NET TAB.
Note: The server is Windows 2000 and IIS is 5.0
- ashish
|
|
|
|
|
comm.CommandText = "select distinct BrandID,Brand as PictureFileName" +
" and BrandID = @BrandID";
comm.Parameters.Add("@BrandID", BrandID);
SqlDataReader dr10 = comm.ExecuteReader();
CatName.Text = dr10;
dr10.Close();
the above code is SUPPOSS to query BrandID from the database table Brand and show it out in the label.
pls some one debug this i think it went wrong somewhere >.<
|
|
|
|
|
Your query doesn't appear to be valid SQL. I'd recommend checking this[^] quick reference on basic SQL syntax.
Hope that helps.
--Jesse
|
|
|
|
|
What is it that you are trying to do, really?
I have seldom seen a piece of code with so many errors...
Let's have a look at your code:
comm.CommandText = "select distinct BrandID,Brand as PictureFileName" +
" and BrandID = @BrandID";
Why are you using distinct? Can there more than one record with the same BrandId?
You have forgotten the keyword "from" before the table name.
You are creating the alias "PictureFileName" for the table, but you are not using this alias anywhere.
You have forgotten the "where" keyword.
You have the operator "and", as if you were trying to combine conditions, but you only have one condition.
If you fix the query so that it works, it's still pointless. There are only two different results that you can get from it; either the exact same value that you put in the parameter if there is a matching record in the database, or an empty result if there is no matching record.
comm.Parameters.Add("@BrandID", BrandID);
Looking good. You might consider to specify the data type of the parameter once you get it up and running, though, to save a round trip to the database.
SqlDataReader dr10 = comm.ExecuteReader();
Nothing wrong here.
CatName.Text = dr10;
You can't put the entire DataReader object in the label. You have to read a value from the DataReader, perhaps using the GetInt32 method.
Before you try to read anything from the DataReader, though, you have to call the Read method.
neodeaths wrote: dr10.Close();
Another correct line.
---
b { font-weight: normal; }
|
|
|
|
|
comm.CommandText = "select BrandID,Brand from Brand where BrandID = @BrandID";
comm.Parameters.Add("@BrandID", BrandID);
SqlDataReader dr10 = comm.ExecuteReader();
CatName.Text = dr10;
dr10.Close();
is this how it should be done?
|
|
|
|
|
That's a lot closer.
You are still not calling the Read method before you try to read from the DataReader, and you are still trying to put the entire DataReader in the label.
---
b { font-weight: normal; }
|
|
|
|
|
i think i understnd where you are going but could you show an example or something since i have never used the read method or the GetInt32 method before
and the webpage about the sql syntex doesnt seems to have it as well >.<
|
|
|
|
|
|
please help me evaluate >.<
the sql database consist of 3 attributes BrandID,Brand,Brandlogo
comm.CommandText = "select Brand from Brand where BrandID = @BrandID"; //select which data i want from the database
comm.Parameters.Add("@BrandID", BrandID); //add parameters to query
SqlDataReader dr10 = comm.ExecuteReader();
dr10.Read(); // Call Read before accessing data.
int id = dr10.GetInt32(0); //<== this part i dont quite get it becoz my result was supposs to be an string
CatName.Text = id.ToString();
dr10.Close();
if the above code have anything wrong please tell me where cause i tryed to run it and it still cant work
(p.s thansk to all those who have been helping me)
|
|
|
|
|
neodeaths wrote: int id = dr10.GetInt32(0); //<== this part i dont quite get it becoz my result was supposs to be an string
Then you use the GetString method instread.
Do you remember that the very first thing I asked you was what you were trying to do? You never answered that, so I still have no idea if the code is even remotely close to what it is that you are actually trying to do.
---
b { font-weight: normal; }
|
|
|
|
|
thx i finally got it haha it ended up it was suppos to be like this
comm.CommandText = "select BrandID,Brand,BrandLogo from Brand where BrandID = @BrandID";
SqlDataReader dr10 = comm.ExecuteReader();
dr10.Read();
string id = dr10.GetString(1);
CatName.Text = id;
dr10.Close();
thx to all those who have help =)
|
|
|
|
|
Hi,
I have a web application and users can register themselves on it.
I would like to have special URLs for each client that is a registered user, much like a friendly URL.
a good example would be the way myspace.com works...
a registered user can have www.myspace.com/joebloggs as their myspace url.
i have tried to get this to work but can only manage to get www.mywebsite.com/joebloggs.aspx to work.
I do this by having a custom 404 page then perform a database lookup based on the name and redirect to their page.
If i drop the aspx off the end IIS kicks in and shows its own 404 page.
Is their any way i can have it without the aspx on the end? so it would be www.mywebsite.com/joebloggs
I am using asp.net 1.1 with visual studio.net 2003.
Thank you in advance for any help.
Regards,
Guy
|
|
|
|
|
It sounds like you'll want to look into url rewriting. To get you started, here are a couple of articles that Google spit out for me:- Richard Birkby's article[^] here at CodeProject
- Robert Chartier's article[^] at 15 Seconds
- Jesse Ezell's blog post[^] on working around some common problems
Just for completeness, here[^] is the search that gave me those results. I hope that helps to get you started.
--Jesse
|
|
|
|
|
Have the real address be www.mywebsite.com/joebloggs/default.aspx and you can just do www.mywebsite.com/joebloggs/ and if you have the default document set to default, it works. You can even do query strings: www.mywebsite.com/joebloggs/?sec=2&page=3
|
|
|
|
|
surely that means i would need to have a pre-created directory with the name 'joebloggs' though???
i dont really want directories for each user i just want it to be dynamic.
Because there is only ever really one page called viewclient.aspx this accepts an ID as a parameter and shows the clients content based on the ID.
So to view joe bloggs client page i want to type www.mywebsite.com/joebloggs
Is this actually possible in asp.net?
im wondering if i could do it by changing the IIS error page for 404.
then checking the url asked for (the query) and then looking this up in the database.
anyone know if this type of technique would work and how to achieve it?
---Guy H ( ---
|
|
|
|
|
It is possible through the use of url rewriting, and in a much more efficient way then using a 404 error as flow control. I linked several articles to get you started in my initial reply.
--Jesse
|
|
|
|
|
Hi Friends,
Can any one let me know how we can implement security using MYSQL.
Creating user login.
though i have created user table and login and its working for me but I am facing problem.
How to sign out user. because when i sign out user he/she can user browser back button to view previous pages although he/she is logged off.
any article link or code will be appreciated.
thanks
Naveed Kamboh
|
|
|
|
|
Hi,
I have a web application(ASP.net) running in our local Network. I want to send some messages to all the clients those are logined in. Is it possible? I have no Idea, where to start? and how to do?
pls hgelp me . This is very urgent..........
(i can get IP address of each machine when they login. I have also winpopup control, which displays message in pop ups)
|
|
|
|
|
meetbinu2003 wrote: This is very urgent..........
It always is...
|
|
|
|
|
Hi there. Do you want to try submitting your question again? Looks like the <> angle brackets didn't come through. (You may want to check the box "Ignore HTML tags in this message" when you submit)
|
|
|
|
|
I'm new to ASP.NET and with my first experiment I've run into a bunch XML problems. First I found out that the XMLDataSource control does not support namespaces. Now this. I'm trying to use the XPath position() function from within a DataList control. Here is my code:
<asp:DataList ID="DataList1" runat="server" DataSourceID="XmlDataSource1">
<ItemTemplate>
item # = <%# XPath("position()")%>. item price = <%# XPath("ele") %>
</ItemTemplate>
</asp:DataList>
<asp:XmlDataSource ID="XmlDataSource1" runat="server" DataFile="~/cleancrash.xml" XPath="gpx/trk/trkseg/trkpt">
</asp:XmlDataSource>
unfortunately when my code runs the position() function returns "1, 1, 1". I expect it to return the number from within the node set. In my case I have 3 nodes in my set, so I expect it to return, "1, 2, 3". I am attempting to produce a numbered list of items from within my XML file. My XPath command XPath("ele") works correctly, and the Datalist does see that my set has 3 items.
1. Is position() the correct function to be using?
2. How can I get the results I am looking for?
3. Can someone explain to me how to correctly read the XPathBinder documentation (http://msdn2.microsoft.com/en-us/library/system.web.ui.xpathbinder.aspx). I cannot figure out what syntax it is looking for. I'd love to be able to figure this out in the future.
Thanks, -=STZ=-
|
|
|
|
|
I have code that stores the shopping cart in a session object. It works fine until recently when it kept throwing an 'object reference not set to an instance of an object' exception.
This is my code:
<br />
If HttpContext.Current.Session("ShoppingCart") Is Nothing Then <-- exception thrown here<br />
HttpContext.Current.Session("ShoppingCart") = New Lists.CartList()<br />
End If<br />
It seems to occur when called by this code
<br />
Dim _objCart As New Lists.CartList<br />
Public Sub New()<br />
_objCart = CartManager.ShoppingCart ' <-- this is session bit above<br />
End Sub<br />
Any help is appreciated here
|
|
|
|
|
You didn't chage the code and all of the sudden you are getting an error?
Try resetting IIS.
how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things
--thedailywtf 3/21/06
|
|
|
|
|
I have no idea what the problem was but it has sorted itself out. Ya gotta love Windoze :p
|
|
|
|