Forms Data Controls :: When Try To Include A Query Of The Section ID To The Link Of The Project Categories (DataView Of The Projects Repeaters Does Not Contain SectionID?
Jan 6, 2010
I have a parent repeater that lists the sections of the website. this repeater binds to display a table that contain another repeater of the website pages .. or may display a table that contains another two repeaters of the projects categories and sub-categories.Until now everything is going fine.
The problem comes when I try to include a query of the section ID to the link of the project categories (DataView of the projects repeaters does not contain SectionID)my question is : is there any way to call the SectionID of the first repeater in my projects categories and sub-categories repeaters?Here is my code:
[Code]....
the code behind is as follow:
[Code]....
View 8 Replies
Similar Messages:
Jan 21, 2011
Trying to use a dropdownlist to query a database so that it will return all values except 1 (or more in future versions).
For example, assume you had a simple table name "MYFRIENDS" which has two fields named "GROUP" and "NAME" with the following records:
Group
Name
A
John
B
Jane
C
Tony
D
Sue
What I want to do is create a DropDownList that has only 2 list items related to the "GROUP" field. The first list item should return records from the database related to Group A only. Then, the second list item should return all other records EXCLUDING those belonging to Group A.
The drop down list should look something like this (I've put a question mark where I don't know what to do):
[Code]....
After the selection is chosen in the above drop down list, it should query the database and return the desired result. I'm using an AccessDataSource with select parameters. Here's a sample of what that looks like:
[Code]....
Things I've tried that didn't work:
I tried using "Not A" as the the 2nd list item's value. I was thinking p1 would be replaced with the value "Not A" and the query would read "WHERE GROUP LIKE Not A". But, the query syntax "Like Not" is technically wrong. I tried changing the Where Clause to "WHERE GROUP p1" and then replaced the list item's value to "LIKE A" and the second to "NOT LIKE A". Again, I was thinking p1 would be replaced to read "WHERE GROUP LIKE A" and "WHERE GROUP NOT LIKE A". I also tried changing the "SelectCommand" itself so that after the dropdownlist changed, it would first change the selectcommand first and then run the query.
Why the first 2 items didn't work became somewhat obvious to me after thinking about it for a little while. However, I would think the 3rd one would/should work... as long as you have the sequence of events correct which up to this point I haven't been able to figure out.
View 3 Replies
Jul 10, 2010
I'm trying to design a page that displays all suppliers by their location. I'd quite like this to work from a query that will automatically include new locations added in the future.
At the moment my design has a table that holds 'locations' with locationID and locationName fields. In my 'suppliers' table I also have a locationID to join them.
I'm not sure how to query the database to return all the suppliers in location 1, then all in location 2. (Or even sure of the terms I need to Google to get some examples!) For example:
Location 1
Supplier 1
Supplier 2
Location 2
Supplier 3
Supplier 4
View 3 Replies
Sep 2, 2010
I want to have a gridview which first column is a link to another page. For that I want to create a
link text through a SQL query!
I have the following piece of SQL code, to create the first column of the gridview:
[Code]....
View 2 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
Nov 9, 2010
I have a SQL Server 2000 table that has an insert trigger that e-mails the user when a record is inserted for them. i want to include a link to a page that will disply a list (datagrid) of their records only. What is the best way to do this? The trigger is already completed and currently includes a link that displays all records but I want to be able to narrow that based on the user.
View 1 Replies
Mar 3, 2010
I have a table with articles. Every article has a column named category which value is either 1 or 2 On my landingpage the article headers are displayed as hyperlinks. All the articles with category 1 will be displayed in a repeater control on the left side of page and all the articles with category 2 will be displayed in another repeater control on right side of page. I know I can bind the repeaters to two different sqldatasource controls with different SELECT statements. But I wonder if I can do this by only using one sqldatasource control, and if this is better and proper way of doing it. If so, do I create a (datatable?) and do the sorting there?
View 5 Replies
Mar 18, 2011
I have a set of records that will go into a repeater, however, the query being used has a grouping on it and i need to apply this to the repeater i.e.
GROUP NAME
Record 1
Record 3
GROUP NAME
Record 2
Can this be done?
View 7 Replies
Jan 26, 2010
First, I'm needing to report info from a database (currently an Access database that will be migrated to a SQL database shortly). There are too many fields in the database to just let them go on and on across the page. I've got the first repeater working GREAT! but none of the other repeaters populate at all.
[Code]....
View 1 Replies
Feb 14, 2010
[Code]....
I use if(! Page.postback) to fill those two repeaters I want to get the data related to checked checkboxes when using the below code it get only the data of the first checked box how to make it brign all the data
private void Btn_Confirm_Click(object sender, System.EventArgs e)
{
//CheckBox checkedButton = null;
foreach (RepeaterItem item in ParentRepeater.Items)
{
CheckBox control=(CheckBox)item.FindControl("CheckBox1");
if (control.Checked)
{
//checkedButton = control;
foreach(DataRow r in GetInnerData(control.Text).Rows ) // GetInnerData is used to pring datarelated to the selected check box
{
if(r["DESCRIPTION"].ToString() == control.Text)
{
Response.Write(r["DESCRIPTION"].ToString() + r["Date" ].ToString() + r[ "Trx" ].ToString() + r[ "GL" ].ToString() + r["Amount" ].ToString() +"
");
}
}
control.Dispose();
//checkedButton.Dispose();
break;
}
}
}
}
View 2 Replies
Jan 6, 2011
i have two projects in one solution...
project A
project B
in project A i have page in--->Home/Account(page)
what link i have to use from project B to open the page in project A
View 5 Replies
Jun 22, 2010
I have an application that I am developing using ASP.Net with visual basic code. I have a table called "Customers" that contains 3 fields. The name of each field is "Name", "LocationA", and "LocationB". I want to code a select query that list two columns. The first column should contain the field "Name". I want the second column to contain the value in the field "LocationB" if "LocationB" is not null, else I want the second column to contain the value in the field "LocationA".
View 4 Replies
Jan 22, 2010
I am having trouble getting the following code to display side by side in a table. At the moment it displays next to each other in different cells but the cell on the right stretches further down than i would like, the opening item in the cell - <%#Eval("Product_ID") %> - is level with the end of the image in the cell on the left and everything else continues on new lines below it, when what i was hoping would happen would be for the product id to be directly across from the top of the image and the rest of the items to go below that. I have tried datalists and detailsview but they do not give me what i want either
[Code]....
View 1 Replies
Mar 4, 2010
I have several repeaters on the same page. They are not nested. Because of design and database issues I had to keep them independent. I need to total the amount in a particular column for all repeaters. Is there a common approach to this or do I have to hack something?
View 1 Replies
Feb 1, 2010
i did like all instruction in this link
[URL]
but i have a problem,this erer arise "Can not find tabel1"
View 2 Replies
Feb 22, 2011
i posted a question yesterday but it got taken off by moderator mbanavige with the reason indicating it was a duplicate post. i know for sure it was the first time i was asking that question. i will have to ask it again NOW because it was deleted. hope THIS one does not duplicate the one i made yesterday. so here goes:
I need to query a products table based on categories selected by the user. The selection of the categories is a checkbox list, and user can select any number of categories (including none at all). I only know how to compare one parameter at a time. Like this:
[Code]....
View 3 Replies
Jan 11, 2011
I have 3 nested repeaters and in my code behind I can't seem to lock onto the second level repeater. I have written code for the third level but I will once I figure out how to get to the second level. My code is written below.
[Code]....
CODE-BEHIND
[Code]....
View 4 Replies
Jun 23, 2010
For the solution, I cannot use any event handling methods, because my webapp is fully ajax based and no complete postback is possible. So here's the problem.I have a `List<WebPage>` that contains a list of Links `(List<Link>)` and I need for all the links to bind repetitive information such as page title, id, url. Here is my current repeater.
<div id="result">
<asp:Repeater runat="server" id="results">
<Itemtemplate> [code]....
View 1 Replies
Jan 18, 2010
First of all thanks to the active members of this site.I want to know the Controls used in New age FAQ pages.simulating the FAQ's used inhttp://uidai.gov.in/faq.html .how can I build the FAQ section as in link using ASP C#.
View 1 Replies
Apr 30, 2010
I am using nested repeaters and wanted to access a value from my parent repeater within the child...is this possible?
View 3 Replies
Jul 28, 2010
Is there any way to have the gridview page by categories instead of pages. In other words instead of at the bottom having some sort of page numbering scheme there would be categories from a specific column (kind of like a group by in sql) arranged along the bottom and when I would click one it would page to the start of all those matching rows (preferably return all of them rather than just say 10 or 20).
View 1 Replies
Dec 8, 2010
i have one requirement like i want to show all the categories with the subcategories ..
i mean if i have the Sale category it will be heading of the gridview and all sub categories of the Sale category foreign key related subcategories display in that gridview like urls .same way it will show all the categories ..
View 7 Replies
Jun 8, 2010
I have a repeater that displays a list of job openings. I now need to modify the repeater and break out the job openings by category.
See below for the existing code for my repeater. I'm not sure how I need to modify my repeater to display the jobs under the appropriate categories.
I've added a new JobsCategory table to the database and added the foreign key relationship between my jobListing table and the jobcategory table.
I've created a new stored procedure to pull the jobs my category:
CREATE PROCEDURE [dbo].[GetJobsByCategory]
@categoryId int
AS
BEGIN
SET NOCOUNT ON
SELECT j.JobID, j.JobTitle, j.URL, j.City, j.State, j.Country, c.CategoryName
FROM ADPJobListing j
INNER JOIN ADPJobCategory c ON j.CategoryID = c.CategoryID
WHERE j.CategoryID = @categoryId
END
In my typed dataset (tableadapter), I'll add a new query to the above stored procedure and finally in my business logic layer, I'll add a new method to call down into my data access layer:
[DataObjectMethod(DataObjectMethodType.Select, false)]
public ADP.JobsDataTable GetJobsByCategory(int categoryId)
{
return this.Adapter.GetJobsByCategory(categoryId);
}
How do I need to modify my repeater to display the jobs by category?
[Code]....
View 1 Replies
Sep 27, 2010
Is there a straightforward way to create a dataset after querying a dataview? The query itself returns DataRowView objects, which I cannot get to work with CopyToDataTable().
The query looks like:
Dim dvQueryView As DataViewdvQueryView = (dataview object of large dataset)
detailTableQuery = From rowView
As DataRowView
In dvQueryView _
Order
By sSortOrder _
Select rowView _
Skip nQuerySkipRow _
Take nQueryCountRows
I only want a small selection of records from the large dataview and use those to create a smaller dataset. The large dataset stays in place while multiple views are created from it, and then from those views I want to create the smaller datasets.
View 7 Replies
Oct 14, 2010
I know nopCommerce and dashCommerce quite well, but I so far have never found any open source shopping cart (including HumanResources and Vendors) bigger than the nopCommerce. I'm wondering whether AdventureWorks database comes together with a web project or other UI projects as an open source. Or it just exists as a sample database only.
View 2 Replies