SQL Server :: Adding "categories" To Website And Making Them Searchable?
Jan 25, 2011
I wanted to make categories for my website. I have plans for 4 categories - we can call them CAT3,CAT2,CAT1 and CAT0.
So for example:
Technology (CAT3) - > Software (CAT2) - > Microsoft (CAT1) -> ASP.NET (CAT0)
These will be clickable links which the user should be able to go through.
What I have done so far is created the CAT3 categories in a Table. Now I want to display them on my website and I have chosen to show it in a ListView control.
How do I make them links so that it will link to the CAT2's then CAT1's then CAT0's. The user should be able to create new Category 0's but not be able to delete them. Also the user should be able to search through the database of all the CAT's using a search box.
What's the best way of doing this? How should I structure this? I've been looking for quite some time now (slept at 2AM :) ) for a solution but I still can't find one.
P.S I am using Visual Studio 2010 Web with ASP.NET and C# and for SQL Server Management Studio.
View 8 Replies
Similar Messages:
May 8, 2010
i m making website in asp.net and my website is not searchable buy search engine i use this in master page
<meta name="description" content="Trump Academy offers various Courses in Aviation,Ground Staff,Travel and Tourism & Hospitality"/>
View 3 Replies
Jan 9, 2010
I want to add unlimited categories and sub categories facility, But I couldn't solve it for last two days.
1. DB
CategID,CategName,parentid
Data:
CategID CategName Parent ID
1 Electronics 0 (where 0 means it is main category)
2 TV 1 (Self Join whith the categ id Electronics)
3 Panasonic 2
4 LG 2
5 Toys 0
6 Girls Toys 5
7 Boys Toys 5
8 Criket Related 7
9 Dolls 6
Here I want to display this data in Combo Box like
Electronic
>>TV
>>Panasonic
>>LG
Toys
>>GirlsToys
>>Dolls
>>Boys Toys
>>Criket Realted
View 6 Replies
Jun 9, 2010
I have a product category table with the following fields:
cat_id (PK)
Cat_name
Cat_desc
Parent_Cat_Id
Now when a user wants to add a product he should be able to select multiple categories from a listbox(multiselection enabaled). But to let the user know the hierarchy of the categories, I need to display them in the following style:
parent category 1
parent category 1->sub category 1
parent category 1->sub category 1->sub-sub category 1
parent category 1->sub category 1->sub-sub category 2
parent category 1->sub category 2
Parent category 2.........
I know that to achieve this I need to use recursive programming. But how can we do it via stored procedures?
View 2 Replies
Jun 19, 2010
I have a developed a new website for online document management. I have setup everything on the local network and the site is available on localhost. What I want to do is to make it available on internet. Its my first web project and configuring IIS and resolving database problems after publishing was real headache for me apart from development work (thats another long story). But i have made it up to here (with the help of a lot of people in this forum) and now there is one more step.
How to make a web server live?
I am using asp .net 3.5. The server is in my home (windows xp, IIS 6, microsoft sql server 2005, 10MB bandwidth for internet connection).
I dont want to buy a domain because the website is not commercial. Its just me and my friend who will be using the website and we dont mind putting in ip address. Also, do I have to get a static ip from my ISP?
View 3 Replies
Aug 2, 2010
Me with C# asp.net, I want to make a public forum in my website. Any good article for making forum will be helpful. Is there any bultin fourms that can be used in .Net?
View 3 Replies
Nov 29, 2012
i want to make a league table on my website.
is there a way of doing it with out a database.
i want to be able to update as results come in.
View 1 Replies
Jan 5, 2011
I was working on some website in ASP.NET 3.5 on VS 2010. Though, some of the work is left, I intend to make it live. I have a domain and a host. But are there any chnages to be done in web.config etc before uploading? or how does this process work?
View 2 Replies
Aug 19, 2010
I have a User Control (ascx) and a property which a want to display in my categories tab in Visual Studio in the category named "Styles".
[Code]....
And here is the problem: Actually I do not need a get, because I only have to set the property (write only property). But when I omit the get, the property is displayed in the "Misc" category in the categories tab in Visual Studio. Only when I code the get as well, then the property is displayed correctly in the "Styles" category in the categories tab in Visual Studio.
Does anybody know why? How can I display the category correctly only with set?
View 2 Replies
Dec 3, 2010
i have a newswebsite, i need to make RSS for my news website to increase the page rank on Search Engins like Google.
1. how can i make an RSS to be readable by search Engins,
2. can i make the RSS for a single page so i increase the rank for this page when search by Google.
View 1 Replies
Jan 8, 2011
I have requirement of dropdownlist with checkboxes and also this dropdownlist is seachable and contain tooltip for each control
View 5 Replies
May 7, 2015
jQuery plugin to make searchable combobox which also works in mobile browsers.
Currently i am using Chosen but it is not working in mobile.
View 1 Replies
Mar 20, 2011
I need help making selections on my installation of SQL Server 2005 Developer Edition onto my Laptop (the only computer in my house). I need to develop a couple of different databases and use them from my Visual Studio applications. Then I will upload the SQL databases and the Web Applications to GoDaddy for deployment to general public.My question is that installation is asking me questions I honestly don't know how to answer because I am using a different SQL this time around after reformatting my hard drive"
1. Do I use Default or Named Instance?2. Do I use the Built-In System account or a Domain User account?3. If answer 2 is Domain User then I am in trouble because I don't think I have a Domain, and I don't know what one is. Where would I find the user name, the password, and the domain?
View 1 Replies
May 26, 2010
I'm looking to use a gridview to create a basic search page for my website. On the page I have the following:
1.) A dropdown list with the search parameters
2.) Textbox where the user enters their search
3.) A Submit button.
In the submitclick, I want the gridview to display the contents of my database, but only the items that match what the user has entered into the textbox based on the parameter they chose from the dropdown list. I have the following code:
SqlConnection SearchConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["LandRover"].ToString());
SqlCommand SearchCommand = new SqlCommand("SELECT * FROM ORDERLINE WHERE " + ddlSearch.SelectedValue.ToString() + " = @Search", SearchConnection);
SearchCommand.Parameters.Add("@Search", SqlDbType.NVarChar).Value = txtSearch.Text;
SearchConnection.Open();
SqlDataReader SearchReader = SearchCommand.ExecuteReader();
if (SearchReader.HasRows)
{
grvHistory.DataSource = SearchReader;
grvHistory.Visible = true;
grvHistory.DataBind();
}
I'm code this in C#
View 2 Replies
Jun 20, 2010
I have a developed a new website for online document management. I have setup everything on the local network and the site is available on localhost. What I want to do is to make it available on internet. Its my first web project and configuring IIS and resolving database problems after publishing was real headache for me apart from development work (thats another long story). But i have made it up to here and now there is one more step.
How to make a web server live?
I am using asp .net 3.5. The server is in my home (windows xp, IIS 6, microsoft sql server 2005, 10MB bandwidth for internet connection).
I dont want to buy a domain because the website is not commercial. Its just me and my friend who will be using the website and we dont mind putting in ip address. Also, do I have to get a static ip from my ISP?
View 1 Replies
Nov 17, 2010
I would like to know if the forieng key should be nullable or not. We shuld struggle for not making it nullable as much as possible or it doenst matter.
View 1 Replies
Mar 17, 2011
I am trying to make a PhoneNumber Control. I inherit from Composite Control. It contains 5 controls : 1 Label (Text to show before), 3 TextBoxes(area, prefix and line) and a Custom Validator. What I want to happen is the validator to validate the control is belongs to in two ways: 1. that the field is required and 2. That the COMBINED text of the 3 textboxes is 10 digits. I believe i can accomplish this with the expression ^d{10}$. Now I have it about halfway working, it will validate the control using client-side
embeded validation on a submit click, however I need the control to validate as soon as the text of any of the boxes changes. I know this is done on the aspx page by using a Custom Validator -> specifying client and server side validation functions -> and then at end of page doing ValidatorHookupControlID(control, va lidator). My goal is to do all of this within the control to clean aspx code and make it more reusable.
[code]...
View 1 Replies
Jun 21, 2010
I want the same solution like Making A Cool Login System With PHP, MySQL & jQuery But in ASP.Net 3.5, SQL Server 2008 and jquery.
I want this solution for my ASp.Net(C#) site in which I'm using ASP.Net's default membership module and now I want to put its loginview and registaration system in a jquery modal windows and validate the user in the system and create the new user in the sytem by entering user credentials in the loginviews and registaration fields inside the modal windows and then by clicking on the button palced in the modal windows as well.
View 3 Replies
Aug 13, 2012
I created a web application using visual studio 2010 (.NET framework 4.0). I am trying to add this website in IIS on a remote server. The remote server only has .NET Framework 2.0. I am getting an error:
Could not load file or assembly 'projectname' or one of its dependencies. This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded.
Is there any workaround for this, without added .net framework 4.0?
View 2 Replies
Sep 14, 2010
I'm a bit of a noob to RSS and would like to know how I can add a BBC sports feed to my website. The feed is at:
[URL]
have the code for this in C# ASP.NET?
I would like the articles displayed as one line links if possible.
View 3 Replies
Mar 4, 2011
my requirement is i want to upload word documents and pdf documents into my website with security (i mean encryption) and i want to retrieve documents by giving password the document should visible(or the document should visible for only some people how to do it)
View 4 Replies
Jan 16, 2011
I have a website deeloped in ASP.NET and I want it to be accessed via local URL, for eg: http://localhost/website20I tried once but the CMS in my website started giving error "It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS."
View 2 Replies
Jan 13, 2010
I have many different websites under the same directory on my server. I want to know if there is a way I can register a dll for many websites once. That way, I won't have to go to each website and do reference -> add reference , etc.
View 4 Replies
Apr 7, 2010
We have a web site that sits on a DotNetNuke platform and all of our coded modules are written in VB.Net for consistency. However, we have been sent a web page that works as a link and it is written in C# and references a cs file in its App_Code folder. If we try and load this into our website we get an error saying that it is not written in VB we then tried converting the homepage to VB but the reference folder is very complex and written in C#. Can we load the reference file even though it is C# and reference it using VB code. The current all is OurRemService RemService = New OurRemService(); where OurRemService is a file in the App_Code folder in the web page folder. The only other way around this is for us to set it up in IIS as a virtual directory and reference it directly but we would prefer to integrate it into our website.
View 1 Replies
Oct 17, 2010
Since a Web Site doesn't have a project file or a bin folder,
how will a Web Site identify of what are all the dlls to be used.
And if i am adding a third party dll to my web site, and i need to
add this web site folder to a source control, how should i include
this third party dll in the source control?
View 1 Replies
