|
Hi,
I am using VB.NET 1.1 and 2.0. I was wondering if any one knows of a free URL rewriting tool that I can use. Currently I had a look at http://UrlRewriter.NET but I don't seem to understand it because there aren't many samples.
Basically what I want to do is to have a friendly product name field in my products table. This I want to use for the URL, instead of something like ProductDetails.aspx?ProductID=123, and replacing it with ProductDetails.aspx?CoolComputer.aspx
And if the user types in ProductDetails.aspx?CoolComputer.aspx, then it must show the product details of product 123.
I hope someone can help me.
Regards
ma se
|
|
|
|
|
Hey guys, I'm having a little problem with my drop down list and gridview.
I used the drop down list to select what data is going to be shown in the gridview, it was working fine earlier but I changed the SQL string around a little bit and it went all haywire. Usually I back up my data every few hours, but just as my luck would have it, last time I backed up was right before I started that form.
The error I'm getting is "Must declare the scalar variable "@Name".", but I thought it was declared, I must have a line left out in the drop down list settings. Here is the code that I think matters. If I'm leaving any out please let me know!
<asp:DropDownList ID="myDropDownList" runat="server"
DataSourceID = "myFilteringDataSource"
DataValueField = "Name"
AutoPostBack = "True" DataTextField="Name"
/>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT *
FROM tblCallers,
tblTicket,
tblUsers
WHERE tblTicket.TicketID = tblCallers.TicketID
AND tblTicket.UserID = tblUsers.UserID AND tblUsers.Name = @Name">
</asp:SqlDataSource>
Thanks,
aqzman
Edit: Just thought this might help elimate some problems. When I run this code without the "AND tblUsers.Name = @Name" code the gridview and drop down list both fill up with all the data they need to, but obvisiouly none of the data in the gridview is filtered
|
|
|
|
|
How are you providing value to @Name?
Gautham
|
|
|
|
|
Hi, thanks a lot for your reply!
I never changed any code with the dropdownlist, and that's where I thought where the value was getting assigned to @Name. I just noticed that not all the code for the drop down list is getting displayed in my first post for some reason.
Here is the drop down list code.
<asp:DropDownList ID="myDropDownList" runat="server"
DataSourceID = "myFilteringDataSource"
DataValueField = "Name"
AutoPostBack = "True" DataTextField="Name"
/>
|
|
|
|
|
Hi,
I want you to check your command text, i.e. your select query.
In your select query after the and condition you are using the variable @name , how is the value getting substituted to that @name?
Dont you have to add this parameter to the command?
Gautham
|
|
|
|
|
Thanks again for the reply.
Well this is actually sort of strange, but good at the same time I guess. I made of copy of that page when it was working and it was saved in a folder, so I forgot about it. Anyway, that page is working fine, but the strangest thing is that I carried over all the code, and even checked the settings, they all match. One works, and the other doesn't.
There is no value getting put into the @name on either page, the only time the actual phrase "@Name" is being used is in the selet query.
Should I just write some code to assign the currently selected item in the drop down list to the @Name instead of just wondering how one page works? Haha.
Thanks,
aqzman
|
|
|
|
|
What i would say first leave the form with its functionality working then start your research and try to pass the value.
But strange though!!!
Gautham
|
|
|
|
|
Yup, I'll just throw everything on the working form. Thanks for the help!
|
|
|
|
|
SelectCommand="
Declare @Name varchar
SELECT *FROM tblCallers, tblTicket, tblUsersWHERE tblTicket.TicketID = tblCallers.TicketID AND tblTicket.UserID = tblUsers.UserID AND tblUsers.Name = @Name";
I was born dumb!!
Programming made me laugh !!!
--sid--
|
|
|
|
|
Hai there..
I created one installer file, that'll check AJAX Extensions registry file and if it's not there it'll install Ajax Extensions amd if it's there it'll install my appliation.
Now wat is the problem is: it's checking correct and installing Ajax if it's not there, but it's not installng my application once it's finished. If already AJAX is installed means then only it's installing my application. But i want this two things to be installed in one setup. I'm using SearchFor and Launch Condition. Please help...
Regards n Thks
Sam.M
|
|
|
|
|
how to add marquee (scrolling text) in asp.net page, i am using ASP.NET WITH C#, i have found no control in visual Studio 2005, i am designing a desktop application along with website
|
|
|
|
|
Use AdRotator control instead of Marquee.
Regards,
Satips.
Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus
|
|
|
|
|
<marquee>Hello
God Bless you.
Always do good to others
|
|
|
|
|
He is actually looking at a desktop application I guess.
|
|
|
|
|
|
In page design you can add the marquee tag i guess with the text!!
I have used that it works!!!
I was born dumb!!
Programming made me laugh !!!
--sid--
|
|
|
|
|
|
Highlighter[^]
Regards,
Satips.
Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus
|
|
|
|
|
Thanks dude
Will it work for ASP.net 2.0 too???
|
|
|
|
|
Yes.
Regards,
Satips.
Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus
|
|
|
|
|
It will only work if you install PHP on IIS[^].
There are other simpler options available like the SeeSearchWords control[^].
Cheers,
Mircea
Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.
|
|
|
|
|
Urgent!!!!!!!
I want to upload image by drag and drop means I want to drag the image diectly from external folder and drop to webform instead of browse the image by using UploadFile control.And then upload it.
Another thing is droped images should be in thmbnail form.
which control I have to use or which software I have to use for this purpose.
If possible can any one send me sample code ?
|
|
|
|
|
Don't Repost.
Regards,
Satips.
Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus
|
|
|
|
|
Can we integrate Ajax with .Net 1.1 version?
|
|
|
|
|
Yes.
Regards,
Satips.
Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus
|
|
|
|