C# - Databinding Two Sql Tables To One Repeater?

Oct 26, 2010

I'm very new to using Linq-to-SQL, that's why I'm asking this question. I've searched the site, but can't seem to figure out how to do this.

My problem is:

I have a database mapped with LINQ to SQL:

Table 1: PersonalTasks

TaskId
Header
[Content]
IsDone
CreatedDate

Table 2: Comments

CommentId
TaskId
UserId
Comment
CreatedDate

I have a repeater:

<asp:Repeater ID="PersonalTaskRepeater" runat="server">
<ItemTemplate>
<%#Eval("Header") %>
<%# Eval("Content") %>
Task done: <asp:CheckBox ID="IsDoneCheckBox" runat="server" Checked='<%#Eval("IsDone") %>' /><img src="Images/tick-circle.png" />

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? :)

View 1 Replies


Similar Messages:

Databinding Multiple Tables Linq Query To Gridview?

Jun 3, 2010

how can I display a linq query in a gridview that has data from multiple tables AND allow the user to edit some of the fields or delete the data from a single table?

I'd like to do this with either a linqdatasource or a linq query. I'm aware I can set the e.Result to the query on the selecting event. I've also been able to build a custom databound control for displaying the linq relations (parent.child).

However, I'm not sure how I can make this work with delete? I'm thinking I may need to handle the delete event with custom code.

View 2 Replies

VS 2005 - Databinding Repeater Controls

Mar 2, 2012

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")

[Code]...

View 7 Replies

Forms Data Controls :: Databinding A Repeater Control Twice In The Same Code?

Aug 4, 2010

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.

View 2 Replies

Forms Data Controls :: Paging Repeater Control In Databinding?

May 3, 2010

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.

View 1 Replies

Forms Data Controls :: Databinding Composite Control Properties Inside A Repeater?

Jul 14, 2010

I have a composite control inside a repeater. I am trying to set the controls public properties inline like so (this is a simplified example):

<uc1:Control runat="server" ID="id" Value='<%# Eval("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.

View 2 Replies

Databases :: Importing - Updating Sql Tables From Excel Sheet Into Multiple Tables Daily

Jan 4, 2011

I have an C# ASP application I am writing that needs to have the capability to import a generated excel or a comma delineated sheet each day. A clerk will have this job each morning so it doesn't need to be automated. My problem in trying to understand the solution to this is that the 1 sheet contains loan information, including customer information all in the same sheet. I would like to send certain columns to update information in the loan table and send other information to update the customer table. I need it to create relationships when new loans appear in the spreadsheet.

View 1 Replies

Web Forms :: Implement One More Repeater Control Inside Existing Repeater Control (Nested Repeater)

Feb 3, 2014

I am using a repeater control and i want to use one more repeater control inside the existing repeater control . 

Like this:

<asp:Repeater ID="Repeater1" runat="server">    <HeaderTemplate> </HeaderTemplate>       
<ItemTemplate>
<!-- start child repeater -->     Here I want to use one repater control      <!-- end child repeater -->
</ItemTemplate>
</asp:Repeater>

View 1 Replies

SQL Server :: How To Export The Data From Dat File To Tables(Two Tables)

Dec 30, 2010

I am using bulk insert concept to export the data from dat file to tables(Two tables). I am using the temporary table for to do the calculation and insertion to two tables. My problem is whenever I selecting the temp table data after the execution of bulk insertion , the order is changing .I need to get the order as it is in file order(csv,dat,txt).

View 5 Replies

C# - Nesting Repeater In Gridview: Hiding Gridview Row And Repeater Header If Data Is Not There In Repeater?

Apr 21, 2010

I have nested a repeater control in Gridview. Right now it is showing gridview rows and repeater header for every case(whether data is there or not for that particular grid view row in the repeater control). I want to hide the gridview row and repeater control header when there is no data present for that particular gridview row. That case I handled at code level by filtering the resulted data table.

Now the another problem I am facing: I have allowed the paging on the gridview i.e. pagesize 3. When page loads it works fine, but when I go to page 2 then it generates following error: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index

Below is the code to fill the grid, paging and fill repeater on rowdatabound event of grid.

[code].....

View 1 Replies

Get The Tables Name And The Relation (dependency) Among The Tables?

Jul 24, 2010

I make use of SMO namaspace to get Table, Function, Procedure names from the DB.

Now I've intended to get the tables [Column] name and the relation (dependency) among the tables. Is this possible?

View 2 Replies

Forms Data Controls :: Repeater Inside A Repeater (dataBound) Code Behind?

Jan 31, 2010

got an example of a repeater inside a repeater (dataBound) code behind?

View 3 Replies

Forms Data Controls :: ImageButton Inside A Repeater That Is In Another Repeater & Events?

Jan 18, 2010

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?

View 3 Replies

Forms Data Controls :: Repeater Paging - Retrieve Hyperlink Variable Inside Repeater?

Jul 12, 2010

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 Replies

Forms Data Controls :: Binding Parent Repeater Item Index In Child Repeater Control?

Jun 17, 2010

I want to bind parent repeater item index in child repeater control using inline code not code behind side.

For example

[Code]....

View 2 Replies

Nested Repeater Show Data That Matches Parent Repeater?

Mar 15, 2011

I am using a repeater to build a custom table. However, I can't figure out how to make the table show subtotal if the next rows tour does not match the previous rows.

Something similar to that.

row1 tour1
row2 tour 1
tour1 subtotal
row3 tour2
row4 tour2
subtotal
total

[code].....

but this shows all the data in the nested repeater not the ones that match the parentrepeater fields for example tour,theme,dep7 should match in the child repeater

View 1 Replies

Forms Data Controls :: Hiding A Repeater Div Using A Link Outside The Repeater?

May 25, 2010

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.

View 2 Replies

Forms Data Controls :: How To Use Button In Repeater Inside Repeater

Feb 6, 2011

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.

View 3 Replies

Forms Data Controls :: Show / Hide A Div In A Nested Repeater By Clicking On A Button Inside Parent Repeater?

Nov 12, 2010

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].....

View 1 Replies

How To Show / Hide A Panel Within A Repeater From A Button In The Repeater Itself

Apr 7, 2010

I have set up an asp repeater to go through and display a list of people based on input parameters. Within that repeater I have a repeater that displays specific details about each person. No problem so far.

However, my requirement is that I only display the names, with a plus/minus sign to the left of the name. Clicking on the plus sign will expand that person's information to show the details. Clicking the minus sign will collapse the detail info.

I have a panel set up within my primary repeater that encompasses the secondary repeater.

Here's the beginning of the code:

[Code]....

View 10 Replies

C# - Nested Repeater With Child Repeater In A User Control?

Feb 18, 2011

Edit: I have a working solution already - I would just like to know why my original attempt didn't work. My original attempt is the code below.

I'm using the approach I found here:[URL] 306154 to implement a nested Repeater. Each parent item has one or more children items (the point of having the nested Repeater) with a dropdown horizontally aligned to each child item. In an effort to re-use the nested part of the Repeater I wanted to develop that piece as a user control but couldn't get it to work. I am wondering if it is even possible and if so how?

Here is my user control apsx:

<asp:Repeater ID="NestedRepeater" runat="server">
....
<ItemTemplate>
<tr class="text" id="RepeaterItemRow" runat="server">
<td>
<%#DataBinder.Eval(Container.DataItem, "Name") %>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
</ItemTemplate>

And here is my code behind for the user control. I noticed when I debugged NestedDataSource was null even though in the parent page load the data is there:

public DataSet NestedDataSource
{
get;
set;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
NestedRepeater.DataSource = NestedDataSource;
NestedRepeater.DataBind();
}
}

In the parent Repeater in the `<ItemTemplate> I have:

<asp:RepUC ID="NestRep" runat="server" NestedDataSource='<%#((DataRowView)Container.DataItem).Row.GetChildRows("nestedrel") %>'>

And finally the page code behind:

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BuildWBS();
}
}
private void BuildPage()
{
DataSet ds = new DataSet();
ds = DataAccessLayer.GetData("System");
ds.Relations.Add("nestedrel", ds.Tables[0].Columns["Id"], ds.Tables[1].Columns["ParentId"]);
ParentRepeater.DataSource = ds;
ParentRepeater.DataBind();
}

The page loads but nothing relating to the repeater appears on the screen. So, can you see anything wrong with what I have? Is the way I tried doing this even possible?

View 1 Replies

How To Access Repeater Item Template Controls Outside The Repeater

Feb 2, 2011

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 :

protected void btn1_Click(object sender, EventArgs e)
{
foreach (RepeaterItem item in rptWord.Items)
{
DropDownList ddl1 = (System.Web.UI.WebControls.DropDownList)rptWord.FindControl("ddlWord");
}
}

But m getting ddl1 as null. For this i created a function which is as follows:

public void myFunction(object sender, RepeaterItemEventArgs e)
{
foreach (RepeaterItem item in rptWord.Items)
{
DropDownList la = (System.Web.UI.WebControls.DropDownList)e.Item.FindControl("ddlWord");
}
}

using this function iam able to access the repeater but i guess its not possible to call this function on button click event .

View 3 Replies

C# - How To Access One Repeater's Control Into Another Repeater's OnItemCommand() Method

Oct 15, 2010

lets say I want to make a label of repeater1 visible in repater2's ItemCommand() method..

e.Item.FindControl("rpt1Label").Visible=True;

is not working..how else do you do it ?

[EDIT]

changed that to repeater1.FindControl("rpt1Label").Visible=True;

This is throwing object reference null exception

View 1 Replies

C# - Repeater Within Repeater (ajax Based Web App) - Cannot Use Any Postback Methods

Jun 23, 2010

For the solution, I cannot use any postback methods, because this is all working through ajax. The solution need to be implemented in the asp.net code. 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>
<asp:Repeater runat="server" datasource='<%# Eval("Links") %>'>
<Itemtemplate>
<tr class="gradeX odd">
<td><%# Eval("Id") %></td> //property of WebPage (part of results repeater)
<td><%# Eval("Title") %></td> //property of WebPage (part of results repeater)
<td><%# Eval("Url") %></td> //property of WebPage (part of results repeater)
<td><%# Eval("URL") %></td>//Property of Link
<td><%# Eval("URLType") %></td> //Property of Link
<td><%# Eval("URLState") %></td> //Property of Link
</tr>
</Itemtemplate>
</asp:Repeater>
</Itemtemplate>
</asp:Repeater>
</div>

of course this doesnt work, how can i do this?

View 2 Replies

C# - How To Expose A Repeater's Templates From Another Control That Contains The Repeater

Sep 30, 2010

If I have a custom user control (say, MyCustomControl.ascx) which contains a number of other controls including a repeater, is there any way to expose that repeater's templates as templates for MyCustomControl?

For example, I would want to be able to do this:

[code]....

There could potentially be more than one repeater or other templated controls within the parent control, in which case I would like to be able to expose all of those templates for all of the controls in the same way.

My first thought was to simply expose the repeater's templates as ITemplate properties on MyCustomControl, but that didn't work since there's no (obvious) way to access the repeater's DataItem from the templates doing it that way.

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved