I'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 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 was wondering, how about can i databind some custom attributes to my Radiobuttonlist / Dropdownlist / Checkboxlist? My existing code as follows:
With Me.ddlOtherApplications
.DataTextField = "ApplicationName" + Me.iSolutions_SysVariables.sys_iLanguage.Replace("-", "")
.DataValueField = "ApplicationID"
.DataSource = dtOtherApplications
.DataBind()
End With
However, I have 2 more additional custom attributes: ApplicationID and ApplicationImgUrl..... how abt do i databind these 2?
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 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'm opening a new window and passing on to it variables in a querystring, the values are loaded into a function that is filling my dataset and then filling my Gridview. after i press the button field in my grid to delete an item, the databind doesn't show the updated grid but remains the same. i've noticed that if i navigate back and refresh i see it correctly. in FF btw no problem.
the code:
this is used to open the new window
[Code]....
[Code]....
[Code]....
[Code]....
I need to charge my checkboxlist1 from database, eg load fruits and vegetables. When selecting fruits, new filter based on the previous selection in my checkboxlist2. for specific search.
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 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 RepliesWhat would be the best way to handle the following scenario? I have an application where depending on what type of proceeding is selected, only certain input fields should be visible.
There are 33 proceeding types and 14 input fields in total
First case, make one big form with all of the fields and have a dropdown with proceeding type which depending on what is selected, makes certain fields visible?
i have a problem about listing. i have categories that it is added infinite category,subcategory. Table is like that:
id
ustid
kategori
seviye
i want listing like this:
For example when i click "Arac", the list will become like following:
Araç (category)
Otomobil (subcategory)
Motorsiklet (subcategory)
Then .when i click "Otomobil"
Araç
Otomobil
----Fiat
---Audi
---BMW
when i click "Fiat"
Araç
-Otomobil
--Fiat
---Murat
---Şahin
Nested Repeater Issue: Each category list gets populated with the same set of date values rather then being populated with the data associated with that category. Trying to Do: Trying to group FAQ's by category and then list them using the repeaters.
The data is queryed though a business logic layer object that makes a call to the data access layer object. The data access layer object uses linq to sql to return data. There are 3 parameters that are passed into the innerDataSource's ObjectDataSource control to populate the nested repeater control (propID, CatID, isVisible).
With the debugger, the correct data is being returned and written to the nested repeater firing from the nested repeater's ItemDataBound event. Once this event is finished, another event fires and runs the FAQRule object again on the business logic layer which re-populates the nested repeater with the same data for each category. I have 2 repeaters, outerRepater (parent) and innerRepeater(child) with 2 ObjectDataSource controls innerDataSource and outerDataSource. See code below : ASP Page:
<asp:Repeater DataSourceID="outterDataSource" EnableViewState="false" runat="server">
<ItemTemplate>
<%# Eval("Description") + " " + this.Property.PropertyName %>
<asp:Repeater EnableViewState="false" runat="server" DataSourceID="innerDataSource">
<HeaderTemplate>
<ul style="width: 500px">
</HeaderTemplate>
<ItemTemplate>
<div><%# Eval("Question") %></div>
<div><p><%# Eval("Answer") %></p></div>
</ItemTemplate>
<FooterTemplate>
</ul>
</FooterTemplate>
</asp:Repeater>
<asp:ObjectDataSource ID="innerDataSource"
runat="server"
SelectMethod="FetchFAQSByPrpAndCatID"
TypeName="PropertySite.BusinessRules.FAQRules">
<SelectParameters>......................................