I have a SQL table containing a list of questions which admin users can add new questions too as and when they feel necessary.
I have a web form with a Repeater which displays these questions next to a checkbox and a textbox. When the user clicks the checkbox or the enteres data textbox I want to click and update button and store this data in a different table.
My current thinking is that this would go into a table with 30 bit fields for the checkbox values (c1-c30) and 30 text fields for the textboxes (t1-t30).
This would allow the admins upto 30 questions in the database at anyone time.
The question is how do i bind the controls in each row of the Repeater to its corrosponding SQL database field i.e row1 t1 and c1, row 2 t2 and c2 etc.
Code:
Protected Sub Repeater1_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.RepeaterItemEventArgs) Handles Repeater1.ItemDataBound
Dim i = 0
Dim item As RepeaterItem
Dim checkBox As CheckBox = e.Item.FindControl("CheckBox5")
I have a asp:repeater control which I am using to display a photo and the Name. So for this I have to execute SQL query and unfortunately I dont have the control of the database - table design. So the photo comes from one table and the Name comes from another table. I wrote 2 sql queries to get both these information created 2 sqldatareader. So now I have to bind the repeater control to both of these reader. But I know it does not work. Is there any other way I can do this? I even tried to nest a repeater control inside another. But that does not work anyway.
I have a strange problem. I have made a PagedRepeater control, which inherits from the Repeater, from a tutorial I saw here: http://www.4guysfromrolla.com/articles/020905-1.aspx. It's in VB and I'm in C#, and it didn't quite have all the features I was lookingfor, so, I've modified it quite a bit. I added support for a SqlDataSource control, as well. The only problem is, that it always returns the first item from the SqlDataSource, even when the CurrentPageIndex on the PagedDataSource is set to a different value.
When I place the repeater inside a user control INSIDE ANOTHER user control and onto the page this works - the property is correctly set, if I inspect it inside the EnsureChildControls() method of the custom control the composite control's Value propertyis set to Eval("value") as intended.
Here i want to access the comment table, with the comments related to the taskID
</ItemTemplate> </asp:Repeater>
I've tried using: <%#Eval("Comment.Comment1")%> but that throws this error:
DataBinding: 'System.Data.Linq.EntitySet`1[[Assistr.Models.Comment, Assistr, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]' does not contain a property with the name 'Comment'.
My code-behind:
var tasks = db.PersonalTasks.OrderBy(x => x.IsDone).ToList(); PersonalTaskRepeater.DataSource = tasks; PersonalTaskRepeater.DataBind();
Do I need to use 2 repeaters to do what I want to do or? :)
I have a user control that displays a shopping cart in an ecommerce application.
The main cart display is a repeater that renders as a html table. In one of those table columns, there is another repeater to display people associated with the products int he cart (it's a repeater in case there is a line item >1 with multiple people).
I've added an ImageButton that I want to use to change the person associated with the item. At first, when I'd click on it I was getting this error:
Invalid postback or callback argument. Event validation is enabled using <pages enableEventValidation="true"/> in configuration or <%@ Page EnableEventValidation="true" %> in a page. For security purposes, this feature verifies that arguments to postback or callback events originate from the server control that originally rendered them. If the data is valid and expected, use the ClientScriptManager.RegisterForEventValidation method in order to register the postback or callback data for validation.
So as an experiment I disabled EventValidation on the page (not the control it's self) and now I do not get an error, but I also do not ever hit the breakpoint I set in the innermost repeater's ItemCommand event.
So I wonder how I might do this without disabling EventValidation, because this control will show up on multiple pages and we don't want to edit them all. Also, I'll need to know not only the repeater containing the control's row that the event came from but also the row index of the repeater containg this one. Is this possible?
I'm so confused I wasn't even sure what to make the title so that it would make sense.
Here is what I have:
[code]...
I have links at the top of the page that are the letters A-Z. What I want to do is click on one of the letters, then show only the div IDs that start with that letter. I can't figure out how to do this since I'm dynamically creating the ID names. I had it set up nicely with Javascript and CSS, but the function call was inside the repeater. The layout is changed now, and I don't understand how to make the div ID available outside the repeater.
what changed do I need to make to my code for it to achieve what I'm after.
At the moment I am getting a "cannot cast to type" error message with the below code.
I have also tried calling the ItemDataBound method in with the parent repeater tags and had no errors but when I clicked on the button it would just move back to the top of the page and would not hide or show any data. Also I have made the div style to none but the first record still shows its child but the rest don't.
I am using a repater whose item template is having a dropdownlist. Now i want to access that dropdownlist from a button click event. Here is the code iam using :
I want to create a form that will update an existing database record based on a querystring value passed to the page say UserId.
Rather then using data-bound controls such as the FormView, DetailsView, etc, I would like to use textbox controls, a dropdownlist and a checkboxlist to accomplish this alone. Is this possible? How do I go about binding the data from the database to these controls when the page is loaded and what data source should I create?
i had the sql 2008 enterprise and i want to go back to sql server 2005 because in 2008 i created new database but when i did some changes in the table , it gave me an eror that i cant save thins and i need to creat new one if some one know what i'm talking aboutif not i need the sql server installation tutorial i tried by myself but probebly i did it wrong and now i cant connect well to the sql
I was wondering about some best practices for data binding in web forms. For example we have a control:
public partial class MyUserControl : UserControl { public override void DataBind() {[code]...
If we wanted that control to bind its data automatically we would do something like this:
protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack)[code]...
In the first section of code if we do our data binding before the call to base.DataBind() (#1) then that means that, if for example we databind a ListView, we don't have to call ListView.DataBind() because when we call base.DataBind() on our control it recursively calls DataBind on all child controls. Also, we won't have access to any of the properties of the control that were assigned to it using the data binding code blocks <%# %>
If we do our binding on our controls after base.DataBind() (#2) then this means that DataBind is called on these controls twice. Once when base.DataBind() is called, and the second time when we are forced to call control.DataBind(). I can follow here that I don't know about?
EDIT: Looking at this page: http://msdn.microsoft.com/en-us/library/w5e5992d.aspx
Use this method to bind data from a source to a server control. This method is commonly used after retrieving a data set through a database query. The method is primarily used by control developers; most controls perform data binding automatically.It appears that best practice is to bind controls data automatically. Databinding is for when we explicitly set a data source.
I have a gridview in which I have two drop downs. One is populated with values that are static, so I have a regular sub that does that in the code behind. I tried to add code for databinding the other ddl to a datatable. I cannot get this to work. It just comes up empty. My asp code is fine, and the datatable definately has data in it - just nothing gets populated.
One other thing - the code for the static ddl has worked fine, but when I add this other block (either to the same sub as that, or dow the rowdatabound event) the static one doesn't work either.
Inside my repeater I'm calling an extension method like so:
[Code]....
he above is giving me an "Object not set to an instance of a object" exception inside the extension method. If I comment the above expression out, it works fine, and the items are binded wtih no problems.
im trying to use dynamic object in a databinding tag , it gives me error that the property does not exists even though i can see all the properties there in the vs debug mode
here is what im trying to do:
C#:
my method signature:
public static dynamic MyMethod()
ASPX:
in control itemtemplate:
<%# MyMethod().SomeProperty %>
if also trite the other way:
C#:
public static object MyMethod()
ASPX:
<%# ((dymanic)MyMethod() ).SomeProperty%>
But i dont know why it cant resolve the properties , even though i can see them when the databinder control throws an exception (its working fine outside the databinder tag (ie normal aspx tags <% %>)
I have a GV & a FV both linked to same sqldatasource.
When a GV row is clicked, the FV becomes available for editing the row but the GV as a result is reduced to only that row. I want to GV to remain showing all rows. I am using GV selected_index event to invoke "SqlDataSource1.SelectCommand=
