I had a web application that was binding a IDataReader to a repeater control. I converted the project from 3.5(2.0) to 4.0 and then I received the error:
An invalid data source is being used for rptData. A valid data source must implement either IListSource or IEnumerable.
So, I used a datatable instead and the binding worked. So it seems that they have removed this functionality with .NET 4.0.
I have what's bound to be a stupid question, so I'll apologize for what I think should be an obvious answer my brain just can't see. My problem is very simple. I have a Repeater control bound to a SqlDataSource. The ItemTemplate in this case is one complicated beast, and rendering can take a loong time if too many records are returned; so I need to maintain tight control over how many records are brought back from the data source.
Is there not some way of either stopping the creation of subsequent RepeaterItems once a certain count has been reached, or cancelling the bind if more than a certain number of records are returned? I know I can grab the record count from the AffectedRows property in the Selected event of the DataSource, but I've encountered a brain-lock on how to stop/inhibit the binding (or RepeaterItem creation beyond x records).
I'm happy with either aborting the binding altogether if the record count is too high (displaying no records), or simply stopping it after X records are returned; at this point, I'm not picky. Either way would work, and it seems I ought to be able to readily figure out either one, but my brain has simply gone into neutral.
I'm populating a DataList using the IDataReader object and it works fine it the reader contains data. If the data is not present it displays nothing. I want to capture that situation and insert a verbiage such as "No data" or something like that. I've tried to test the datareader for various conditions such as Null, String.Empty, or plain " " but nothing worked. Is there a way to make this happen? Below is my code sample for your review.EJM.Note: It has to be done programatically as I'm building this for a web part.
[Code]....
I have an ASP.NET page that has a code-behind method that is defined as follows:
[code]....
Essentially, when the TicketStatusID is bound, I want to call back to GetStatusColor and display the result of the method instead of the actual ID. How do I do this in a Repeater?
Did you check this c# - SQL Data Reader - handling Null column values - Stack Overflow
View 5 RepliesI heard that using "Using" Block avoids Connection Leaks in IDataReader. Is this correct??? If so how it will do that???
View 2 Replies[Code]....
now, I added information to the <headertemplate><table><tr><td>headers</td></tr></table></headertemplate>
and my label in the <itemtemplate><asp:Label id="Label1" runat="server"></asp:label></itemtemplate>
and now when I run my same code, I get [object reference not set to an instance of an object]
what gives? It was working until I added a header template.
I am familiar with populating a gridview with data. I am able to bind the Data pulled from the database into the gridview
gridview.DataSource = myDataTable;
gridview.Databound.
If I write the following code, teh gridview will no longer show the data
gridview.DataSource = null;
gridview.Databound.
My question is , I want to make the same thing with a user control that contain a gridview. when I use the user control in an aspx page, I am able to populate it with data, but when I try to make this code, the Datasource does not show, instead, I see .DV. So I tried this code but then , I do not see DataSource property instead I see DV (DataView), when I put .DV = null, I get an error message that the object is not in existed. any idea how to clear the user control gridview from its data.
I have to set a LinkButton's OnClientClick attribute but I don't know what this value is until the LinkButton is bound to. I'm trying to set the value when the repeater binds, but I can't workout how to get the 'boundItem/dataContext' value.
<asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate>
<asp:LinkButton Text="HelloWorld" ID="Hyper1" runat="server" OnDataBinding="Repeater1_DataBinding" >
</asp:LinkButton>
</ItemTemplate>
</asp:Repeater>
protected void Page_Load(object sender, EventArgs e)
{
var list = new List<TestObject>();
list.Add(new TestObject() {TestValue = "testing1"});
list.Add(new TestObject() { TestValue = "testing2" });
list.Add(new TestObject() { TestValue = "testing3" });
this.Repeater1.DataSource = list;
this.Repeater1.DataBind();
}
public void Repeater1_DataBinding(object sender, EventArgs e)
{
var link = sender as HyperLink;
//link.DataItem ???
}
Is there anyway to find out what the current rows bound item is?
In the code behind I have a function that returns a List(Of SomeClass):
rptRepeater.DataSource = SomeFunction(SomeVariable)
rptRepeater.DataBind()
<%#Databinder.Eval(Container.DataItem, "Parameter1")%>
I have a page that has a formview on it. Client info, name, address, usual stuff. The formview is populated by a DataSource, that calls a SQL stored procedure for the client info. It all works great.Within the formview, I have a dropdownlist for the Staff assigned to the client (StaffId is a member of the Client record called during the Formview binding). When the formview is in Item mode, the Staff name appears in a label, when in Edit mode, the dropdownlist
is bound and populated by another DataSource that calls a stored procedure of ActiveStaff. When the assigned staff exists, the StaffId is correctly bound to the DDL SelectedValue and the current staff name appears selected in the DDL when in edit mode, as it should.
protected void Page_Load(object sender, EventArgs e)
[Code]....
got an example of a repeater inside a repeater (dataBound) code behind?
View 3 RepliesI 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 have repeater in which I have 2 hyperlink in the footer of the repeater and I want that the hyperlink can navigate from the page_load
View 2 RepliesI want to bind parent repeater item index in child repeater control using inline code not code behind side.
For example
[Code]....
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.
I am using Nested Repeater repeater1 and repeater2 in my project . one button is there inside repeater2 but i cant use that button using e.commandname
so how to use that button and how to write code on it.
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.
[code].....
I would like to know how i could display data from an itemtemplate or any other form views/data-bound controls without having it render in tables? i know theres control adaptors, but is this reliable and will it work with asp.net 3.5?
View 4 RepliesI got his code for RowDataBound
[Code]....
I'm trying to extend the GridView control to enable sorting and paging for any situation.
When using my control I am fetching data from a database and filling a DataSet with it, then binding the GridView upon every page load. My first question would be, is this the correct approach?
To sort the GridView I am overriding the OnSorting method which stores the sort expression and direction in the ViewState, then creates a DataView and utalises the Sort method to sort the underlying data. It then sets the Data Source to this DataView and rebinds the GridView.
Paging is handled by OnPageIndexChanging which simply sets the PageIndex property and again rebinds the GridView.
My problem is; when any control causes a postback my GridView is no longer sorted, presumably because it is persistently rebound. If I don't rebind it then the GridView is empty on postback since the data isn't automatically stored in the ViewState. I have considered saving the data source in the ViewState but I would assume that this is bad practice for large amounts of data? - also DataViews are not seralisable.
The only solution I can think of currently is to override OnDataBound and sort the data every time. This results in a double sort when paging triggers a postback which seems inefficient. Code illustration of this below,
[Code]....
I'm looking for the cleanest 'best practice' solution as this is a learning exercise more than anything else.
I've been using the Item Inserted event for my data controls, such as details view. I'm wondering if there are advantages to doing this with the data sources instead of the data control. There is a lot of overlap in the events provided by these two types of controls. Are there advantages to using the events raised by the data source instead of the ones raised by the data control itself. Should I be using the events raised by the data source instead of the control used to enter the data?
View 2 RepliesI have a listbox that I want to check to see if the current row value already exists in another listbox. How can I hide/preven row from being added to listbox at databind/databound?
View 4 RepliesI have a foreign key (TeamID) in a GridView. I use a TemplateField to display it as the lookup value (TeamName) in a label, and a dropdown for editing. When row is selected and SelectedIndexChanged is fired, I want to access the TeamID. I can get the TeamName from the label. I tried putting the TeamID in DataKeyNames, but that fouled up my dropdown when saving (it reverts to the original value). So, how can I get the TeamID?
View 1 Replies