I am trying to find a good way of building out dynamic controls in a repeater from sql. Basically I have bunch of questions(male/female, where are you from) and question type(textbox, radio button) in sql. In the repeater I need to build the control object based on sql table and the answer. Does anyone have a good example or ideas who it can be done.
View 2 Replies
Here is my .aspx page
<asp:Repeater ID="Repeater1" runat="server"> <HeaderTemplate> <tr bgcolor="maroon"> <th>
Subject Id </th> <th>
Subject Name </th> <th>
Obtained Marks </th> </tr>
</HeaderTemplate> <ItemTemplate>
[Code] .....
c# - code behind
protected void Page_Load(object sender, EventArgs e) {
if (!IsPostBack) {
this.PopulateRepeater();
} } private void PopulateRepeater() {
[Code] .....
Current repeater looks as...
Subject_Id Subject_Name Marks
s1(lable) subject1(lable) 56(textbox)
> Now, I want to make Updation with repeater (in same application).
I want to update Marks(into textboxes only, sub_id and name fatched from database dynamically) in each row of repeater.... how is it possible ??
the repeater I have doesn't show the buttons that are dynamically created according to my query. The source of the page is:
[Code]....
Yet, literally nothing is shown on the page.
Here's my code:
[Code]....
In my project i have and repeater control in wich i m giveing templete of table formate like this
<asp:Repeater ID="DataList" runat="server">
<HeaderTemplate>
<table cellspacing="0" class="dataTable myClients" id="clientListTable" style="width:100%">
<tr>
<th>firstname</th>
<th>Phone</th>
<th>Email</th>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr >
<td><a <%# Eval("ID") %>"><%# Eval("FirstName") %> <%# Eval("LastName") %></a></td>
<td><%# Eval("WPhone")%></td>
<td><%# Eval("Email")%></td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
i want when user click on row of repeater, then selected users detail will be shown in next <tr> so i want dynamic row should generate which hold details of client.
I have created a page in which it shows the list of users using repeater..
And i wanted to give these usernames as hyperlinks to their respective pages..
But i doesn't know how to create dynamic url for this users..
I am using C# language..
Im binding an image to a repeater and giving the image id a unquie value based on the id from the database. The problem im having is trying to find the control within the repeater as i dont know the exact id of the control as its generated at runtime.
What im trying to do is count how many items are bound then after the first one assign a new css class to the rest.
How am i able to find the controls id on itemDataBound ?
The code is provide below:
[Code]...
Hello Good Day,
I want to change the ItemTemplate of Repeater based on different queries on my database.
Scenario -
Say for example,
- First query returns EmployeeID, EmployeeName - In this case repeater should display both fields.
- Second query returns EmployeeID, EmployeeDOB, EmployeeMemo - In this case repeater should display all three fields.
However this cant be done if I set hardcore EVAL in the markup. So i need it to be Dynamic.
Possible Solution in my opinion -
I found one way, that is creating a dynamic Template and then assigning its fields during Item_DataBinding.
Question -
Is there any other simple method, other than creating a dynamic Template all from its scratch. Means let me say, I hardcore fields like
EmployeeID, EmployeeName, EmployeeDOB, EmployeeMemo in the MarkUp, but in case of first query it (Repeater) should neglect
EmployeeDOB, EmployeeMemo and in case of second query it should negect EmployeeName.
I need to bind a repeater with data having indefinite number of columns. How can i do that? Do i have to create template class for that?
View 7 RepliesI have one dropdownlist,one textbox control and one button control.
Now i want to show value in repeater control like this when i click on button.
dropdownvalue1 texboxvalue1
dropdownvalue2 textboxvalue2
dropdownvalue3 textboxvalue3
I need that value in literal controls which is in repeater control.
I'm using a repeater and need to change an image value based on the ID and folder value (both stored in a database); but to do this, I need to know that current database ID for that row.Is there a way to get the current database ID based on the row being rendered using _ItemDataBound???
View 2 RepliesJust dipping my toe with doing simple VB.NET stuff. Have used classic ASP, so im used to being able to place any field from a recordset whereever i want to putit , and i have just tried to recreate this event.Its got me a bit lost.. now i have read up and understand why it doesnt work - cant use DataItem in a HeaderTemplate - i get that, but how would you do something where you have complete control of the way the table is being set up? and you can use the contents of the container whereever you want, however you want?I just want to be able to get the values from database table, and put them into an html table, in a specific way.
[Code]....
[Code]....
I need a sample how I can check checkboxes in repeater using SQL statement. The checkboxes within repeater are populated fine and are named with ObjectName value from database but I just need to checked those values that are returned by a select statement:
private void CheckUserLocations()
{
// user reference that is currently viewed [code]....
Tell me how can i avoid reconnection to database while paging in repeater?
View 1 Replieshere is my code:
My sql query is returning 2 rows by my repeater is only displaying 1.
[Code]....
I need to utilize about 30 different database values from within a repeater ItemDataBound Event and I am wondering if there is a better way to do it. I am currently exposing them by doing something like this 30 times:
[Code]....
Rather than making 30 declarations, is there a way I can make them all available as short variable names? The variable name could be the same as the field name.
i want to build dynamic sitemap from database..even my menu items are also dynamic...and i want do display sitemap having categories and related menu items from database..
so i dont know how to build dynamic site and create dymanic links of that menus and categories..
I have my repeater loading in plain text from a database right now e.g.
<td>
<a href="<%# DataBinder.Eval(Container.DataItem, "URL")%>">
<img alt="<%# DataBinder.Eval(Container.DataItem, "AltTag_Thumbnail")%>" src="<%# DataBinder.Eval(Container.DataItem, "URL_Thumbnail")%>" />
</td>
<td>
<%# DataBinder.Eval(Container.DataItem, "Name") %>
</td>
My plain texts are image links and pdf URLs from a database table, in groups, in the correct order but I'm not sure how to render them correctly (sample image below shows what I am trying to render)
Is there any way to make a repeater template intelligent enough to render an "image link" OR "pdf link" based off the [type] column returned in the record?
table:
pk
Name
Type (image or pdf)
URL
Description
URL_Thumbnail (if image)
GroupId (associate these records to each other)
OrderNumber (order of these records within their GroupId)
I have a databound repeater and in this repeater is an imageButton. How do I pass info from the database into the click event? For example, I've got the description, heading and price fields populating labels, but want the id to go into the imagebuttons click event in order to build a querystring.
View 6 RepliesExample: we have different articles in a database like cars, jewelery, boats. The data related to these articles is different in the tables. I have to show that data in a textboxes and let the user change those data and update. I can do the update and reading the data from database. But the problems is for each item the no.of columns and rows will differ.
My task is I need to get the data according to the use selection in the table with textboxes. I dont know which container (gridview, formview or etc) will suites for my requirement. send me any sample code or any tutorial related to this.
Note: showing the data in a table should be a constraint. Because I should show data row wise (each row contains 3 textboxes and 3 labels (DB table column names))
I am unable to create dynamic menu from database. I have made two tables for this work.First table is Menu which stores menu id and its relevant name.
MId Text
------------
1 File
2 Edit
3 View
..
..
Second table is subMenu which stores submenus which will be linked to the menu table with menu id.
SId Text MID
-------------------
1 New 1
2 Open 1
3 Save 1
4 Cut 2
5 Copy 2
the menu should be created dynamically from the database, each menu should be displayed in single row
when we click on a menu the submenus are displayed in rows that in expand & contrast form
how to design & develope this page
I have used this gridview in my project nad its working fine.
View 2 RepliesI have a page with a data repeater. Each row has a dropdownlist for the user to select a value and the values in every dropdown are the same. I also have an SqlDataSource which each dropdownlist gets its values from as its created. Everything is working as it should but for each dropdown that is rendered a seperate call is made to the database.
suggest a better way for me to do this that means only one call to the database for all dropdowns rendered?
I am displaying data in html table using Repeater. And I have two button for each row. When I click 1st button I want to insert particular row and using second button the same row to be updated. But my prob is When i click button all row is inserting. And I am using Button click event for two button.
View 1 RepliesI need to display image and other column data from database into repeater control.
View 1 RepliesWhen user upload new documents then this document goes for approval to supervisor and for this i use dropdowns ...when I use dropdown the exact result not occur and now i wat to approve/reject through checkboxes...
Here is code:
<table class="CSSTableGenerator" border="0" cellpadding="0" cellspacing="0" id="results">
<asp:Repeater ID="Repeater2" OnItemCommand="Repeater2_ItemCommand"
runat="server" onitemdatabound="Repeater2_ItemDataBound">
<HeaderTemplate>
[Code] ....
Now I want to use checkboxes, how I replace dropdown checkboxes in html and also in asp.net ....
