Web Forms :: How To Filter A Category
Jan 11, 2011we are currently running a website in which the home page has recent tab section which contains list of category list i need to block a category.
View 1 Replieswe are currently running a website in which the home page has recent tab section which contains list of category list i need to block a category.
View 1 RepliesI have following situation
1. I have gridview which is bind with sql data source column name industry
2. I have checkbox list which has all industry name,
3. I want to pass checkboxlist selected value to sql data souce to filter data in gridview.
I am working in a project that is a musical website. I want to display the web page with all categories I have. In my database , named Category_Master, I have two fields like Category_Id (which is a primary key ) and Category_Name. I have generated category_Id with NEWID() function. The category_Id is not supposed to display on the web page. But, i have to select Category_Name and according to that , I have to get the category_Id. If I am using Static connection with SqlDataSource, i am able to make visible=false property so that the category_id won't be visible. But , at that time, I can't write code to Select the category_id of the selected index.
If i am using disconnected approach, I filled the dataset with the Category_Master, and binded it to GridView. But, at that time, I can't hide the category_id from the user. I want to select category_id by clicking on the category_name with out displaying category_id ..?
I have a category and a subcategory column in a Jqgrid. I have enabled inline editing, both category and subcategory are dropdownlists columns (edittype:'select'). I need to filter the subcategory list based on the selected category. I wonder how can I acheive this functionlity? I tried the below event but its not working for me
afterEditCell: function(rowid, celname, value, iRow, iCol) {
//to do here
}
the above event doesn't get fired. my all column are editable
i create example using Northwind database so i create a new website and add new ADO.Net Entity Data Model (.edmx) called Northwind.edmx and i add Categories and Products table inside this (.edmx) file
and add new ADO.Net Data Servuce called "ADODataService" and add it as WebReferences called NorthwindService
so i add new web page and drag DropdownList and Gridview as i want to bind Dropdownlist to all categories and when i select category from Dropdownlist bind Gridview to all Products related to this category
so my code
[Code]....
and my code
[Code]....
so when i select category from Dropdownlist nothing happen :(
also you will find commented code in method BindCategory whuch is not work also.
I'll try to explain as simple as I can in text what my problem is. I don't see any other way to make my issue clear.
I have a GridView that uses an ObjectDataSource.
The ObjectDataSource has an DataObjectTypeName defined, so I pass/get complete objects or list of objects to/from the data access methods.
The objects I'm working with, let's say we work with Book objects, contain a Title and a Category, BUT the Category is an object itself. When the Select method is called, we get a List of Book objects, which is perfectly displayed, overridden ToString method in the Category objects within the Book objects.
The problem I face is that I can't find a way to update the category in my GridView. What I did already accomplish is:I used a template field in the GridView for the Category so I could use a DropDownList for that field in Edit mode.
I bound the DropDownList to another ObjectDataSource that gives me a list of CategoryObjects.
So when I enter Edit mode... the row shows a nice ddl with the available categories. It even selects the right original category.
So far so good... but when I want to save my new selection, I get an error that a string (the selected category in the ddl) cannot be converted to a Category object (that's what the Book object, that is going to be used for the update, expects).
I need good css for Gridview just like the mac css
can we provide the filter functionality to gridview like the excel filter.
In securing actions/controllers, do I have to create a custom filter or use MVC built-in filter?
To use the built-in attribute Authorize() on an action/controller or create a separate class that inherits the ActionFilterAttribute which has a method (OnActionExecuting) to override and do the authentication there?
In my organization we use nested groups. For a particular usage, we have a group (let's assume that the group name "kuku"), and the names of all the nested groups under it contains "kuku" as well.
We may assume that no other group in the LDAP has "kuku" in the name.
I need to create a filter which will return all the users which belong to one of the "kuku"s group.
Obviously, using this filter will bring only the head kukus
(&(&(objectclass=user)(objectclass=person))(memberOf=CN=kuku,cn=...rest of the group DN...))
How can I use wild card to fetch all users which belong to any kuku?
For example: (&(&(objectclass=user)(objectclass=person))(memberOf=CN=.*kuku.*))
I have decorated my base controller with a couple of action filters. They work fine.
One of those filters sets up the request - does things like set the culture based on the domain, etc.
I also have a handful of actions that require authorization using the Authorize attribute.
My problem is that when an user attempts to request a page they are not authorized to access, the authorization filter kicks in and redirects them to a page telling them that they cannot vie the page.
The issue is that the action filters never run so the culture and other request data is never set. This effectively causes language to be wrong in the view and other data to be missing.
I know that authorization filters run first but my question is this: How can I design this such that I can ensure that certain methods are always run before the view is returned, regardless of the authorization.
does a action filter override a controller filter?
View 2 RepliesI'm databinding the checkbox list to a db table which has a category assigned for multiple records. I can list the checkbox but I can't sort them by category using the checkbox list control. Can somebody post an example on how to achieve this? Category 1chk Record 1 chk Record 2 chk Record 3Category 2chk record 4 chk record 5 Etc
View 3 RepliesI want to make Image Gallery for products By Category
for example clothes, books,...
I want doing it with the two links
Image-Gallery-using-ASP.Net-DataList-Control-Part-I
Image-Gallery-using-ASP.Net-DataList-Control-Part-II
without Category it works fine
but I changed this line
FROM tbl_product ) AS tbl WHERE Row >= '
to
FROM tbl_product ) AS tbl WHERE cat_id=@cat_id Row >= '
andI added
[Code]....
and now I face this messageProcedure or function spx_Pager has too many arguments specified.
I would like to put 4 categories (fixed) on my chart (example: 1,2,3,4 quarter on the x-axis) and display data from the database in the right category.
// AVG correspond à moyenne et on multiplie par 100 puisque à la base la colonne est de type Decimal
string query = string.Format("select Entite, AVG(AvancementQuantitatifT1 * 100) FROM reponse WHERE ObjectifStrategique = '{0}' GROUP BY Entite", Objectif_strategique.SelectedItem.Value);
[Code].....
For example I want to do something like that :
select Progressquarter1, Progressquarter2,Progressquarter3, Progressquarter4 and put respectively in quarter 1 quarter 2 quarter 3 and quarter 4.
I'm working on a dynamic table of contents (toc). The toc is generated from data in a sql database. There are 5 sections in the toc and within each of the five sections, there are a varied number of rows. (Section 1 may have 5 rows, while Section 2 has 12 rows). To help differentiate between the sections, I'd like the ability to add some type of grouping in my gridview. So, it would look like below. Do I just add a different gridview for each section, or is there a way to "categorize" the gridview to break up the data with a Section 1 Category
a
b
c
d
e
Section 2 Category
a
b
c
d
e
f
g
h
i....
i want to develop image album on my website
1 upload photo category wise
2 view photo category wise
I want to store the image in specific folder by giving some id to that and Dynamically i want to generate new folder for storing another image.I am using FileUpload.saveas(sever.map(imgpath))but with these method i am able to store the image in project folder and i want to create a new folder etither in project folder or anywhere in machine and in that folder again one new folder with some name and in that i want to save image with unique id.
View 1 RepliesMy question is, as I can get, show my users that section are, in my website. as aspforums does. I use a repeater or datalist or some other control ?.
View 1 RepliesCode Sum gridview by category in asp.net 2.0
View 3 RepliesI am having a problem .I want to display the book category and subcategories which is fetched from database .
I want to show record like
Example
--------
A
Autobiographies
- Advertising
- Artists
[Code]....
How to show record like this and which control I have to use for this.
I have a following requirement:
1. Create a blog with content and images.
2. Category for blogs
3. Comments on each blog
4. Monthly Archives, Recent Blogs and Recent comments.
im creating advance search for my project and end up with the problem of select statement format for 2category.
here is example:
i have advancesearch that has checkbox wherein you can select multiple checkbox. example is selecting category, for example ihave 5 category as shown below.
Category
News Sports Opinion Editorial Literary i did tried someformats for my select statements to make it work for 2 or more category, but i just cant get the right format of the select statement.
example if i select the following.
if selected is category 'Sports'
it wil work with this: " 'Select * MyTable1 where [Category Title]='Sports' "
if selected are category 'Sports' and 'News'. what must be the format for my selectstatement for 2 or more category in the same fieldname? should it work with this?
" 'Select * MyTable1 where [Category Title]='Sports','News'" no, how could i make it work. what must be the right format?
I have a sidebar on a page with vertical navigation about products The navigation links are created from an xml sitemap with a repeater control using 2-level nodes with product main categories and subcategories I want to display the data so when i click on a main category the page will reload showing the underlying subcategories names and description in the main section (div) of the page, but also when i click a subcategory's name from the sidebar, i will get its products (names and description from an SqlDataSource) in the main section. (In the main section i'm probably going to use a DataList)
Can i do that ? Display different category level data depending on the link that was clicked or do i need a seperate "maincategories" page. The scenario is similar to the master-pages-and-site-navigation tutorial in the data-access tutorials but that one goes as far as presenting the main categories [URL]
there is category and under its there are all forum of this category
to do that , I create 2 tables in DB
cat for category have 2 rows ( id,title) and table forum have 3 rows ( id,title,Cat_ID)
I can do it with Php but in asp.net I can't
I read in some article to create nested gridview
Im developing ecommerce website and i want to add category menu to my website. This category menu should have 2 levels for sub categories as well. I tried navigation controls in ASP.net. But still i cant understand how to create the navigation menu in order to integrate with back office. I understand that i can do this with XML file, But if i want to add new products categories or remove categories, XML file should update automatically according to that. I don't understand how to do that. In brief all i want is create category menu with subcategories and i want to control this from my back office.
View 1 Replies